Some sdb sls numbers
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

Some SDB/SLS numbers PowerPoint PPT Presentation


  • 85 Views
  • Uploaded on
  • Presentation posted in: General

Some SDB/SLS numbers. Zhechka Toteva IT/DI-SM. Services from SDB to SLS. select count(*) From SERVICES where SLS_ID is not null --988 select count(*) From SERVICES where SLS_ID is not null and VISIBLE_IN_SLS = 1 -- 863

Download Presentation

Some SDB/SLS numbers

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Some sdb sls numbers

Some SDB/SLS numbers

Zhechka Toteva

IT/DI-SM


Services from sdb to sls

Services from SDB to SLS

  • select count(*) From SERVICES where SLS_ID is not null

    --988

  • select count(*) From SERVICES where SLS_ID is not null and VISIBLE_IN_SLS = 1

    --863

  • select count(*) From SERVICES where SLS_ID is not null and VISIBLE_IN_SLS = 1 and PRODUCTION_LEVEL = 0

    --768

  • select distinct sls_threshold_affected, sls_threshold_available, sls_threshold_degraded from services where sls_threshold_affected is not null;

    --84


Services per organic unit

Services per organic unit

  • select count(*), CERNUNIT_ID, CERNUNITS.SHORT_NAME From SERVICES, CERNUNITS where SLS_ID is not null and VISIBLE_IN_SLS = 1 and PRODUCTION_LEVEL = 0 and CERNUNITS.ID = SERVICES.CERNUNIT_ID group by CERNUNIT_ID, CERNUNITS.SHORT_NAME order by count(*) desc

180IT-DB

122IT-ES

93IT-ES-VOS

42IT-DSS

33IT-CS

27IT-PES

27IT-PES-PS

25PH-UCM

21IT-DSS-FDO

21IT-GS

21IT-OIS

16GS-AIS

15IT-GS-EIS

13PH-DI

13IT-SDC-MI

12PH-LBC

10IT-CIS

10IT-DI-CSO

10IT-DSS-TAB

8IT-DB-DBF

5IT-CF-ASI

5PH-CMG-CO

4PH-SFT

3IT-OIS-IN

3IT-OIS-ODS

3EN-EL-CO

3IT-PES-ES

2IT-DB-IMS

2IT-SDC

2IT-CF

2IT-CIS-DLT

2IT-CIS-DLS

2IT-CIS-AVC

2EN-ICE-SIC

2IT-DI

2IT-PES-IS

1IT-GT

1PH

1IT-GT-TOM

1IT-LCG

1IT-UDS


Ph services in sls

PH services in SLS

  • select full_name, services.short_name, sls_id, CERNUNITS.SHORT_NAME From SERVICES, CERNUNITS where SLS_ID is not null and VISIBLE_IN_SLS = 1 and PRODUCTION_LEVEL = 0 and CERNUNITS.ID = SERVICES.CERNUNIT_ID and CERNUNITS.SHORT_NAME like 'PH%' order by CERNUNITS.SHORT_NAME

PH-SFT-Group PH-SFT

ROOTwebPH-SFT

SavannahPH-SFT

CrabServerPH-UCM

MCDBPH-UCM

cmsdocPH-UCM

cmsweb_workqueue

VISUALIZATION-TESTSERVICE

CMS_WBM_Services

cmsweb_couchdb

cmsweb_dmwmmon

cmsweb_reqmgr2

cmsweb_gitweb

CMS_FRONTIERT0

cmswebPH-UCM

cmsweb_phedex

ATLAS-TagCollectorPH

cmssdtPH-CMG-CO

cmsrepPH-CMG-CO

cmstcPH-CMG-CO

HyperNews PH-CMG-CO

Cmsbuildservers PH-CMG-CO

cmst0-late-runs PH-DI

ss_FZKPH-DI

ss_SARAPH-DI

CMS-T0PH-DI

CMST0-backlog PH-DI

ss_NDGFPH-DI

ss_TIER0PH-DI

ss_CNAFPH-DI

ss_LYONPH-DI

ss_TRIUMFPH-DI

ss_ASGCPH-DI

ss_CERNPH-DI

ss_RALPH-DI

LHCb_Nightlies_buildlhcb02PH-LBC

LHCb_Nightlies_buildlhcb07PH-LBC

LHCb_Nightlies_buildlhcb08PH-LBC

LHCb_Nightlies_WebpagePH-LBC

LHCb_Nightlies_RSSPH-LBC

LHCb_Nightlies_buildlhcb10PH-LBC

LHCb_Nightlies_AFSPH-LBC

LHCb_Nightlies_CoverityPH-LBC

LHCb_Nightlies_buildlhcb09PH-LBC

LHCb_Nightlies_buildlhcb03PH-LBC

LHCb_Nightlies_BuildMachinesPH-LBC

LHCb_Nightlies_buildlhcb01PH-LBC

LCGBUILDPH-SFT


Ph services in sls 2

PH services in SLS (2)

cmsweb_dqm

cmsweb_t0mon

cmsweb_t0datasvc

cmsweb_sitedb

cmsweb_filemover

cmsweb_reqmgr

cmsweb_mongodb

cmsweb_overview

cmsweb_dbsmigration

cmsweb_das

cmsweb_reqmon

cmsweb_dbs

Please check all these on

https://sls.cern.ch//sls/service.php?id=XYZ


  • Login