ACS Reports for Windows 2008 and Windows 2008 R2

First published on TECHNET on May 08, 2009

ACS reports that will come out of the box with System Center Operations Manager 2007 R2 , will support Windows Server 2000, 2003, 2008 and 2008 R2.
In addition, R2 which has many new enhancement and features - and for ACS in particular, it will also include more robust creation of indexes for better query performance.
Oh, and here's the cool part - by 2nd half of 2009 - the System Center Cross Platform team will extend ACS in OpsMgr R2 to support Linux and Unix systems as well!

We have also included several new reports:

• Access_Violation_-_Account_Locked.rdl


• Policy_-_Account_Policy_Changed.rdl


• Policy_-_Audit_Policy_Changed.rdl


• Policy_-_Object_Permissions_Changed.rdl


• Policy_-_Privilege_Added_Or_Removed.rdl

Most reports have been rewritten for enhanced performance. Each report will query for relevant security events from Window Server 2000, 2003, 2008, 2008 R2 (as well as Windows XP, Vista and Windows 7) and normalize the different fields from different OS versions such that the data are presentated in a single coherent format.

Ok, but what if you are using System Center Operations Manager 2007 SP1's ACS feature and need reporting support for Windows Server 2008 today?
Well, we have taken the curtosy of providing these reports for you here* (see attachement - please do not re-distribute the reporting package).
Installation is pretty simple:

1. Rename your existing Audit Reports folder in SRS to another name (Say Old Audit Reports)


2. Copy the zip file to your local machine and unpackage it into a local folder (say C:\ACS)


3. In C:\ACS, run UploadAuditReports

UploadAuditReports {DatabaseServerAndInstance} {ReportingServiceURL} {ReportFolder}
Example (database with instance):
UploadAuditReports MyDBServer\Instance1 http://MyDbServer/ReportServer$Instance1 C:\MyReports
Example (database with no instance):
UploadAuditReports MyDBServer http://MyDbServer/ReportServer C:\MyReports

That's it!

*note: these reports have only been tested and verified for R2, but should technically work for SP1 as well

This posting is provided "AS IS" with no warranties.
Use of included tools and reports are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

ACS Reports.zip