1 / 5

Some SDB/SLS numbers

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

garin
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Some SDB/SLS numbers Zhechka Toteva IT/DI-SM

  2. 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

  3. 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

  4. 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

  5. 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

More Related