Some sdb sls numbers
Download
1 / 5

Some SDB/SLS numbers - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Some SDB/SLS numbers' - garin


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

180 IT-DB

122 IT-ES

93 IT-ES-VOS

42 IT-DSS

33 IT-CS

27 IT-PES

27 IT-PES-PS

25 PH-UCM

21 IT-DSS-FDO

21 IT-GS

21 IT-OIS

16 GS-AIS

15 IT-GS-EIS

13 PH-DI

13 IT-SDC-MI

12 PH-LBC

10 IT-CIS

10 IT-DI-CSO

10 IT-DSS-TAB

8 IT-DB-DBF

5 IT-CF-ASI

5 PH-CMG-CO

4 PH-SFT

3 IT-OIS-IN

3 IT-OIS-ODS

3 EN-EL-CO

3 IT-PES-ES

2 IT-DB-IMS

2 IT-SDC

2 IT-CF

2 IT-CIS-DLT

2 IT-CIS-DLS

2 IT-CIS-AVC

2 EN-ICE-SIC

2 IT-DI

2 IT-PES-IS

1 IT-GT

1 PH

1 IT-GT-TOM

1 IT-LCG

1 IT-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

ROOTweb PH-SFT

Savannah PH-SFT

CrabServer PH-UCM

MCDB PH-UCM

cmsdoc PH-UCM

cmsweb_workqueue

VISUALIZATION-TESTSERVICE

CMS_WBM_Services

cmsweb_couchdb

cmsweb_dmwmmon

cmsweb_reqmgr2

cmsweb_gitweb

CMS_FRONTIERT0

cmsweb PH-UCM

cmsweb_phedex

ATLAS-TagCollector PH

cmssdt PH-CMG-CO

cmsrep PH-CMG-CO

cmstc PH-CMG-CO

HyperNews PH-CMG-CO

Cmsbuildservers PH-CMG-CO

cmst0-late-runs PH-DI

ss_FZK PH-DI

ss_SARA PH-DI

CMS-T0 PH-DI

CMST0-backlog PH-DI

ss_NDGF PH-DI

ss_TIER0 PH-DI

ss_CNAF PH-DI

ss_LYON PH-DI

ss_TRIUMFPH-DI

ss_ASGC PH-DI

ss_CERN PH-DI

ss_RAL PH-DI

LHCb_Nightlies_buildlhcb02 PH-LBC

LHCb_Nightlies_buildlhcb07 PH-LBC

LHCb_Nightlies_buildlhcb08 PH-LBC

LHCb_Nightlies_Webpage PH-LBC

LHCb_Nightlies_RSS PH-LBC

LHCb_Nightlies_buildlhcb10 PH-LBC

LHCb_Nightlies_AFS PH-LBC

LHCb_Nightlies_Coverity PH-LBC

LHCb_Nightlies_buildlhcb09 PH-LBC

LHCb_Nightlies_buildlhcb03 PH-LBC

LHCb_Nightlies_BuildMachines PH-LBC

LHCb_Nightlies_buildlhcb01 PH-LBC

LCGBUILD PH-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