Site Administrator Repository Query Tool

Browse Media

Tags

Previous | Next | View all files | View Slideshow

Download

posted by Doug Davis

Wed, Feb 11 2009

3 comments

Downloads: 287

File size: 1.7MB

Site Administrator Repository Query Tool

Filed under: Query, Site Admin, Repository

This tool allows you to run simple and quick queries from the Site Administrator repository, which includes information gathered about systems, as well as configuration information on Recovery Manager for SharePoint and Migration tools.

For feedback please post to the SA Repository Forum

Quick Install Instructions

- net Framework 3.0 is required

- Unzip it and change this string <system:String>Data Source=spb8159;Initial Catalog=big_sp_logs;Integrated Security=SSPI</system:String> in RealData.xaml You need to specify your SQL Server (Data Source) and your Data Base (Initial Catalog)

- Run start.cmd, wait a few seconds, then Query Dialog shows up

Comments

Grigory Vasiliev wrote re: Site Administrator Repository Query Tool

on Fri, Feb 13 2009 8:37 AM

In addition to built-in Queries here are some recommended examples of other queries:

1. Find out who modified documents for specified period of time (with filter of system data). This query is based on Event table which contains add/modify/delete events.

from Event where timelastmodified < '07/25/2008 11:00:00 AM' and timelastmodified > '07/25/2008 1:00:00 AM' and modifiedby != 'System Account' and itemname not like '%.aspx' order by timelastmodified desc

2. Find out who accessed documents sorted by time of access. Access info is based on SharePoint logs:

select l.User.Name,

l.Document.Collection.FullUrl,

l.Document.RelativeUrl,

l.Document.Name,

l.DateTime

from LogEntry l order by DateTime desc

Carl Nakamura wrote re: Site Administrator Repository Query Tool

on Mon, Feb 16 2009 3:21 PM

Are the suggested queries information that is otherwise availale in the auditing piece of Site Administrator?

Doug Davis wrote re: Site Administrator Repository Query Tool

on Tue, Feb 17 2009 8:34 AM

Hi Carl;

It doesn't query the auditing database, just the SA Reporting database, but some of the info does overlap but the SA Reporting data is a bit more general. The Auditing database is gathering from the Security log we create and it adds extra data, so pure auditing should still rely on that info.