Utilities : Repository, Site Admin

Site Administrator repository cleanup

Ilia Sotnikov — Tue, 28 Jul 2009 17:05:12 GMT

Site Administrator repository cleanup tools consist of two Python scripts that allow to remove the reporting data from Site Admin's reporting database based on its age or specific to certain accounts that you want to exclude from reporting (such as service accounts). The files in attached archive are:

clean.cmd - runs both scripts and contains the input settings
SiteAdminRepositoryCleanUpByChunks.py - removes of reporting data older than N days in the specified Site Admin repository
SiteAdminRepositoryCleanUpSPLogs.py - removes of reporting data for specified account
Python scripting software
Readme.txt that explains parameters for the clean.cmd

Site Administrator Repository Query Tool

Doug Davis — Wed, 11 Feb 2009 08:20:38 GMT

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