May 19, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Site Usage QuerySite Usage Query
Previous Previous
 
Next Next
New Post
 2/21/2007 5:15 PM
 
Hi there
I've just download the trial version, it's a great product :)

I'm wondering if it's possible to create a query, where I get:  A list of all sites (all toplevel and all subsites) with their last usage date, name and url

Best Regards,
Severin
New Post
 2/22/2007 4:49 PM
 
 Modified By Frédéric LATOUR  on 2/22/2007 5:51:36 PM
Hi Severin,

Unfortunately, SharePoint doesn't provide any web services method for enumerating all the site collections (SPSite) for a given virtual server (Wss V2 terminology).
To get along with our "listPermission/listCollection/webPermission" keywords, we were thinking of developping our own web service but we decided not to follow this path because of the possible configuration complexity.
Instead, we decided to make it possible to specify a SharePoint list containing a set of sites.

This would be quite easy to fill this list with a command line program using SharePoint object model.

SPGlobalAdmin globalAdmin = new SPGlobalAdmin();
SPVirtualServer virtualServer = globalAdmin.OpenVirtualServer(new uri("url"));

// Collect available sites collection
if ( virtualServer.State == SPVirtualServerState.Ready)
{
    Rapport(String.Format( rm.GetString("VirtualServerCollectSites"), vsUri.ToString()));
    collectVirtualServerSPSite(virtualServer);
}
else
{
    Rapport(String.Format( rm.GetString("VirtualServerState"), virtualServer.State.ToString()));
}
globalAdmin.Close();


/// <summary>
/// Collects available sites for a given virtual server
/// </summary>
/// <param name="virtualServer">Virtual server</param>
private void collectVirtualServerSPSite(SPVirtualServer virtualServer)
{
            SPSiteCollection siteCollections = virtualServer.Sites;
            foreach (SPSite siteCollection in siteCollections)
            {
             // Add siteCollection to SharePoint list
            }
}

That said, it does not really meet your need as we haven't provided such a feature that returns information about a site. That would be quite easy to implement adding a new keyword like <siteInfo>.

We are currently thinking of our future policy regarding support for SQL 2000/Wss V2 but that feature could be added in a minor revision.
I'll let you know soon.
Regards,

PD: Are you using Reporting Service 2005 or 2000?


Frederic LATOUR
ENESYS
New Post
 2/23/2007 8:38 AM
 
thanks for your detailed answer :)

we use Reporting Service 2005 and SPS v2

When I have this list containing a set of sites, is it possible to get the last modification date, for each site and subsite?

New Post
 2/23/2007 6:50 PM
 
Hi,
Unfortunately not.
I'll see if we can add this feature very soon.
I'll come back to you next week
Regards,

Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Site Usage QuerySite Usage Query

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement