Difference between revisions of "List of sites not publishing userDN"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
[[Category:Grid Operations Meetings]] | [[Category:Grid Operations Meetings]] | ||
'''Page contains current status of handing sites not publishing UserDN''' | |||
'''Last update:''' 5.12.2012 | |||
=List of sites= | |||
=How the list is gathered= | |||
The data in the following tables have been generated by the Accounting Portal staff, on June 5th, 2012. | 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. | * The "published_perc" column indicated the number of non-NULL DNs this site has published on the period since 2012. | ||
Line 8: | Line 18: | ||
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; | 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> | ||
Revision as of 15:15, 5 December 2012
Page contains current status of handing sites not publishing UserDN
Last update: 5.12.2012
List of sites
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;