List of sites not publishing userDN
Jump to navigation
Jump to search
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;