Alert.png The wiki is deprecated and due to be decommissioned by the end of September 2022.
The content is being migrated to other supports, new updates will be ignored and lost.
If needed you can get in touch with EGI SDIS team using operations @ egi.eu.

List of sites not publishing userDN

From EGIWiki
Revision as of 12:38, 29 January 2013 by Krakow (talk | contribs)
Jump to navigation Jump to search
Main EGI.eu operations services Support Documentation Tools Activities Performance Technology Catch-all Services Resource Allocation Security



Page contains current status of handing sites not publishing UserDN

Last update: 14.01.2013

Page is updated only when we receive report form APEL team.

List of sites

Master ticket

no of sites: 34

NGI Master Ticket Site Comment
NGI_BY 88658
  • BY-UIIP

NGI_DE 88649
  • MaiGRID            
  • RWTH-Aachen

NGI_RO 88648
  • RO-13-SS - Waiting to clear up the possible legal issues regarding user privacy


NGI_NL 88647
  • BCBR
  • BelGrid-UCL
  • LSG-AMC  
  • LSG-HUB    
  • LSG-KUN    
  • LSG-LUMC    
  • LSG-NKI      
  • LSG-VU  
  • LSG-WUR   
  • RUG-CIT
ROC_Russia 88646
  • ru-Moscow-SINP-LCG2
  • RU-SPbSU

NGI_AEGIS 88644
  • AEGIS01-IPB-SCL
  • AEGIS02-RCUB
  • AEGIS03-ELEF-LEDA
  • AEGIS04-KG
  • AEGIS11-MISANU
Due to privacy protection laws, we are not permitted to publish User DNs
ROC_AP 88643
  • JP-HIROSHIMA-WLCG
  • KR-KISTI-GSDC-01
  • KR-KNU-T3    
  • KR-UOS-SSCC
  • MY-UM-CRYSTAL 
  • NCP-LCG2  
  • TH-NECTEC-LSR  
  • TH-HAII

CERN 90985
  • CERN-PROD


How the list is gathered

mysql> select c.rocname, c.sitename, (count(a.UserDN)-sum(IF(a.UserDN='NULL',1,0)))*100/count(a.UserDN) as published_perc, sum(NJobs) as num_jobs, MAX(RecordEnd) as last_published from gocdb3.org_EGEE join gocdb3.sites as c on RefID=SiteID and status='Certified' and type='Production' left join UserCPU2 as a on c.sitename=a.ExecutingSite and RecordStart>'2012-01-01' group by sitename, rocname order by rocname, published_perc;