Difference between revisions of "List of sites not publishing userDN"
Jump to navigation
Jump to search
Line 3: | Line 3: | ||
'''Page contains current status of handing sites not publishing UserDN''' | '''Page contains current status of handing sites not publishing UserDN''' | ||
'''Last update:''' | '''Last update:''' 10.12.2012 | ||
= List of sites = | = List of sites = | ||
Line 99: | Line 99: | ||
| | | | ||
*INDIACMS-TIFR | *INDIACMS-TIFR | ||
*JP-HIROSHIMA-WLCG -<br> | *JP-HIROSHIMA-WLCG -<br> | ||
*KR-KISTI-GSDC-01 -<br> | *KR-KISTI-GSDC-01 -<br> | ||
*KR-KNU-T3 | *KR-KNU-T3 | ||
*KR-UOS-SSCC | *KR-UOS-SSCC | ||
Line 106: | Line 106: | ||
*MY-UPM-BIRUNI-01 | *MY-UPM-BIRUNI-01 | ||
*MY-UTM-GRID | *MY-UTM-GRID | ||
*T2-TH-CUNSTDA-<br> | *T2-TH-CUNSTDA-<br> | ||
*TH-HAII | *TH-HAII | ||
*TH-NECTEC-LSR | *TH-NECTEC-LSR | ||
| | | | ||
|- | |- | ||
| NGI_CYGRID | | NGI_CYGRID | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=89352 89352] | | [https://ggus.eu/ws/ticket_info.php?ticket=89352 89352] | ||
| | | | ||
*CY-01-KIMON | *CY-01-KIMON | ||
| | | | ||
|- | |- | ||
| NGI_IT | | NGI_IT | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=89351 89351] | | [https://ggus.eu/ws/ticket_info.php?ticket=89351 89351] | ||
| | | | ||
*Hephy-Vienna | *Hephy-Vienna | ||
| | | | ||
|- | |- | ||
| NGI_UK | | NGI_UK | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=89350 89350] | | [https://ggus.eu/ws/ticket_info.php?ticket=89350 89350] | ||
| | | | ||
*UKI-SCOTGRID-ECDF | *UKI-SCOTGRID-ECDF | ||
*UKI-SOUTHGRID-BRIS-HEP | *UKI-SOUTHGRID-BRIS-HEP | ||
| | | | ||
|- | |- | ||
| ROC_LA | | ROC_LA | ||
| | | | ||
*[https://ggus.eu/ws/ticket_info.php?ticket=88898 CBPF ] | *[https://ggus.eu/ws/ticket_info.php?ticket=88898 CBPF ] | ||
*[https://ggus.eu/ws/ticket_info.php?ticket=88789 ULA-MERIDA] | *[https://ggus.eu/ws/ticket_info.php?ticket=88789 ULA-MERIDA] | ||
| | | | ||
*CBPF | *CBPF | ||
*ULA-MERIDA | *ULA-MERIDA | ||
| | | | ||
|} | |} | ||
<br> | <br> | ||
= How the list is gathered = | = How the list is gathered = | ||
<code>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; </code> | <code>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; </code> | ||
[[Category:Grid_Operations_Meetings]] | [[Category:Grid_Operations_Meetings]] |
Revision as of 11:55, 10 December 2012
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: 10.12.2012
List of sites
no of sites: 42
NGI | Ticket | Site | Comment |
---|---|---|---|
ROC CERN | 88660 |
|
Publishing the user DN is indeed part of our future tasks. We hope to be able to take care of this in the next few weeks. |
NGI_BY | 88658 |
|
|
NGI_DE | 88649 |
|
|
NGI_RO | 88648 |
|
NIHAM will not publish user DNs as long as this is not mandatory. |
NGI_NL | 88647 |
|
|
ROC_Russia | 88646 |
|
|
NGI_BG | 88645 |
|
|
NGI_AEGIS | 88644 |
|
Due to privacy protection laws, we are not permitted to publish User DNs |
ROC_AP | 88643 |
|
|
NGI_CYGRID | 89352 |
|
|
NGI_IT | 89351 |
|
|
NGI_UK | 89350 |
|
|
ROC_LA |
|
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;