How to Deploy ACS Reporting
You deploy Audit Collection Services (ACS) Reporting on a supported version of Microsoft SQL Server Reporting Services (SSRS) instance. If System Center 2012 – Operations Manager Reporting has also been installed on the same SSRS instance, you can view the ACS Reports in the Operations console. Before you deploy ACS, there are a number of prerequisite steps you must perform, such as ensuring that a ACS is configured on management server within your management group. For more information, see Deploying ACS and ACS Reporting.
To deploy ACS Reporting
Log on to the server that will be used to host ACS reporting as a user that is an administrator of the SSRS instance.
Create a temporary folder, such as C:\acs.
On your installation media, go to \ReportModels\acs and copy the directory contents to the temporary installation folder.
There are two folders (Models and Reports) and a file named UploadAuditReports.cmd.
On your installation media, go to \SupportTools and copy the file ReportingConfig.exe into the temporary acs folder.
Open a Command Prompt window by using the Run as Administrator option, and then change directories to the temporary acs folder.
Run the following command.
UploadAuditReports “<AuditDBServer\Instance>” “<Reporting Server URL>” “<path of the copied acs folder>”
For example: UploadAuditReports “myAuditDbServer\Instance1” “http://myReportServer/ReportServer$instance1” “C:\acs”
This example creates a new data source called Db Audit, uploads the reporting models Audit.smdl and Audit5.smdl, and uploads all reports in the acs\reports directory.
The reporting server URL needs the reporting server virtual directory (ReportingServer_<InstanceName>) instead of the reporting manager directory (Reports_<InstanceName>).
Open Internet Explorer and enter the following address to view the SQL Reporting Services Home page. http://<yourReportingServerName>/Reports_<InstanceName>
Click Audit Reports in the body of the page and then click Show Details in the upper right part of the page.
Click the Db Audit data source.
In the Connect Using section, select Windows Integrated Security and click Apply.