Difference between revisions of "List of sites not publishing userDN"
Line 14: | Line 14: | ||
! '''Ticket''' | ! '''Ticket''' | ||
! '''Site''' | ! '''Site''' | ||
! '''Comment''' | ! '''Comment''' | ||
|- | |- | ||
| NGI_IBERGRID | | NGI_IBERGRID | ||
Line 28: | Line 28: | ||
*CERN-PROD | *CERN-PROD | ||
| 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. | | 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 | | NGI_BY | ||
Line 49: | Line 49: | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=88654 88654] | | [https://ggus.eu/ws/ticket_info.php?ticket=88654 88654] | ||
| | | | ||
*CA-ALBERTA | *CA-ALBERTA | ||
*WESTGRID-T2 | |||
| | | | ||
Line 86: | Line 87: | ||
*RO-15-NIPNE | *RO-15-NIPNE | ||
| NIHAM will not publish user DNs as long as this is not mandatory. | | NIHAM will not publish user DNs as long as this is not mandatory. | ||
|- | |- | ||
| NGI_NL | | NGI_NL | ||
Line 163: | Line 164: | ||
|} | |} | ||
<br> | <br> | ||
= How the list is gathered = | = How the list is gathered = |
Revision as of 15:44, 5 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: 5.12.2012
List of sites
NGI | Ticket | Site | Comment |
---|---|---|---|
NGI_IBERGRID | 88662 |
|
|
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_HU | 88657 |
|
|
ROC_CANADA | 88654 |
|
|
NGI_IL | 88651 |
|
|
NGI_DE | 88649 |
|
|
NGI_RO | 88648 |
|
NIHAM will not publish user DNs as long as this is not mandatory. |
NGI_NL | 88647 |
|
|
|
|
||
|
|
||
|
|
| |
|
|
How the list is gathered
The data in the following tables have been generated by the Accounting Portal staff, on June 5th, 2012.
The "published_perc" column indicated the number of non-NULL DNs this site has published on the period since 2012.
A 100% percentage means all the records have non-NULL UserDN, but may have gaps in the publishing. The accounting portal staff is working on a visualization of these publication gaps.
Sites with NULL "published_perc" don't have any user records on the APEL repository.
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;