Alert.png The wiki is deprecated and due to be decommissioned by the end of September 2022.
The content is being migrated to other supports, new updates will be ignored and lost.
If needed you can get in touch with EGI SDIS team using operations @ egi.eu.

List of sites not publishing userDN

From EGIWiki
Revision as of 15:15, 5 December 2012 by Krakow (talk | contribs)
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;