Difference between revisions of "List of sites not publishing userDN"
Jump to navigation
Jump to search
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: 34 | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
Line 30: | Line 30: | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=88649 88649] | | [https://ggus.eu/ws/ticket_info.php?ticket=88649 88649] | ||
| | | | ||
*MaiGRID <br> | *MaiGRID <br> | ||
*RWTH-Aachen | *RWTH-Aachen | ||
| | | <br> | ||
|- | |- | ||
| NGI_RO | | NGI_RO | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=88648 88648] | | [https://ggus.eu/ws/ticket_info.php?ticket=88648 88648] | ||
| | | | ||
*[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-15-NIPNE | ||
*RO-09-UTCN | *RO-09-UTCN<br> | ||
* | *NIHAM | ||
| | | | ||
*RO-13-SS - <span class="internal">Waiting to clear up the possible legal issues regarding user privacy</span> | *RO-13-SS - <span class="internal">Waiting to clear up the possible legal issues regarding user privacy</span> | ||
Line 71: | Line 62: | ||
*LSG-VU <br> | *LSG-VU <br> | ||
*LSG-WUR <br> | *LSG-WUR <br> | ||
* | *RUG-CIT | ||
| | | | ||
Line 80: | Line 71: | ||
*ru-Moscow-SINP-LCG2 | *ru-Moscow-SINP-LCG2 | ||
*RU-SPbSU<br> | *RU-SPbSU<br> | ||
| <br> | | <br> | ||
Line 104: | Line 88: | ||
| [https://ggus.eu/ws/ticket_info.php?ticket=88643 88643] | | [https://ggus.eu/ws/ticket_info.php?ticket=88643 88643] | ||
| | | | ||
*JP-HIROSHIMA-WLCG<br> | |||
*JP-HIROSHIMA-WLCG | |||
*KR-KISTI-GSDC-01 <br> | *KR-KISTI-GSDC-01 <br> | ||
*KR-KNU-T3 <br> | *KR-KNU-T3 <br> | ||
Line 112: | Line 94: | ||
*MY-UM-CRYSTAL <br> | *MY-UM-CRYSTAL <br> | ||
*NCP-LCG2 <br> | *NCP-LCG2 <br> | ||
*TH-NECTEC-LSR <br> | *TH-NECTEC-LSR <br> | ||
*TH-HAII | |||
* | |||
| <br> | | <br> | ||
|- | |- | ||
| | | CERN | ||
| [https://ggus.eu/ws/ticket_info.php?ticket= | | [https://ggus.eu/ws/ticket_info.php?ticket=90985 90985] | ||
| | | | ||
* | *CERN-PROD | ||
| | | |
Revision as of 12:38, 29 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: 34
NGI | Master Ticket | Site | Comment |
---|---|---|---|
NGI_BY | 88658 |
|
|
NGI_DE | 88649 |
|
|
NGI_RO | 88648 |
|
|
NGI_NL | 88647 |
|
|
ROC_Russia | 88646 |
|
|
NGI_AEGIS | 88644 |
|
Due to privacy protection laws, we are not permitted to publish User DNs |
ROC_AP | 88643 |
|
|
CERN | 90985 |
|
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;