Difference between revisions of "List of sites not publishing userDN"
Jump to navigation
Jump to search
Line 47: | Line 47: | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=88648 88648] | | [https://ggus.eu/ws/ticket_info.php?ticket=88648 88648] | ||
| | | | ||
*NIHAM | *[https://ggus.eu/ws/ticket_info.php?ticket=89014 NIHAM] | ||
*RO-01-ICI | *[https://ggus.eu/ws/ticket_info.php?ticket=89015 RO-01-ICI] | ||
*RO-07-NIPNE | *[https://ggus.eu/ws/ticket_info.php?ticket=89017 RO-07-NIPNE] | ||
*RO-13-ISS | *[https://ggus.eu/ws/ticket_info.php?ticket=89019 RO-13-ISS] | ||
*RO-14-ITIM | *[https://ggus.eu/ws/ticket_info.php?ticket=89020 RO-14-ITIM] | ||
*RO-16-UAIC <br> | *RO-16-UAIC <br> | ||
Revision as of 14:20, 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 |
|
|
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;