Difference between revisions of "List of sites not publishing userDN"
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:''' 14.01.2013 | ||
Page is updated only when we receive report form APEL team. | Page is updated only when we receive report form APEL team. | ||
Line 11: | Line 11: | ||
[https://ggus.eu/ws/ticket_info.php?ticket=88641 Master ticket] | [https://ggus.eu/ws/ticket_info.php?ticket=88641 Master ticket] | ||
no of sites: | no of sites: 41 | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
Line 19: | Line 19: | ||
! '''Site''' | ! '''Site''' | ||
! '''Comment''' | ! '''Comment''' | ||
|- | |- | ||
| NGI_BY | | NGI_BY | ||
Line 45: | Line 24: | ||
| | | | ||
*BY-UIIP | *BY-UIIP | ||
| <br> | | <br> | ||
Line 75: | Line 47: | ||
*[https://ggus.eu/ws/ticket_info.php?ticket=89014 NIHAM]<br> | *[https://ggus.eu/ws/ticket_info.php?ticket=89014 NIHAM]<br> | ||
*[https://ggus.eu/ws/ticket_info.php?ticket=89019 RO-13-ISS] | *[https://ggus.eu/ws/ticket_info.php?ticket=89019 RO-13-ISS] | ||
*[https://ggus.eu/ws/ticket_info.php?ticket=89020 RO-14-ITIM]<br> | *[https://ggus.eu/ws/ticket_info.php?ticket=89020 RO-14-ITIM]<br> | ||
*RO-15-NIPNE | |||
*RO-09-UTCN | |||
*RO-07-NIPNE | |||
| | | | ||
Line 96: | Line 71: | ||
*LSG-VU <br> | *LSG-VU <br> | ||
*LSG-WUR <br> | *LSG-WUR <br> | ||
*SARA-MATRIX <br> | *SARA-MATRIX <br> | ||
| <span class="solution">NIKHEF-ELPROD remarks the following: | | <span class="solution">NIKHEF-ELPROD remarks the following: | ||
Line 106: | Line 84: | ||
"We do send the DN information for those VOs that have opted into EGI | "We do send the DN information for those VOs that have opted into EGI | ||
central accounting via the SSM interface. If only EGI accounting finally | central accounting via the SSM interface. If only EGI accounting finally | ||
looked at their SSM system for production everything would work. | looked at their SSM system for production everything would work. | ||
I think we already communicated this for the last 12 months several | I think we already communicated this for the last 12 months several | ||
times to EGI, Tiziana, Peter & all the world. Even to wLCG. | times to EGI, Tiziana, Peter & all the world. Even to wLCG. | ||
As soon as EGI finally switches to SSM reporting all will be fine." | As soon as EGI finally switches to SSM reporting all will be fine." | ||
Line 173: | Line 165: | ||
| <br> | | <br> | ||
|- | |||
| NGI_IT | |||
| | |||
| | |||
*Hephy-Vienna | |||
| | |||
|} | |} | ||
<br> | <br> | ||
= How the list is gathered = | = How the list is gathered = |
Revision as of 10:58, 14 January 2013
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
no of sites: 41
NGI | Master Ticket | Site | Comment |
---|---|---|---|
NGI_BY | 88658 |
|
|
NGI_DE | 88649 |
|
|
NGI_RO | 88648 |
|
|
NGI_NL | 88647 |
|
NIKHEF-ELPROD remarks the following:
"We do send the DN information for those VOs that have opted into EGI
|
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 |
|
|
ROC_LA |
|
||
NGI_IT |
|
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;