One question we seem to get around here a lot concerns the installation of ACS. You put in the CD, you install Audit Collection Services and do everything the deployment guide tells you, but then in the console you can’t find your Audit Reports. What’s the deal? Well, there are a few more steps you’ll need to be sure to complete in order to get these working and I’ve listed them below:
3. Copy the reportingconfig.exe from the SCOM 2007 CD (under the Support Tools folder) to the same folder you created in step #1.
5. Open Internet Explorer and enter the following in the address bar:
This opens the SQL Reporting Services’ Home page.
6. Click Audit Reports
7. Click Show Details (located in the upper right part of the screen).
8. Click on the Db Audit data source.
9. In the Connection string box, verify the text that starts with “data source =” reads:
data source=” “<WhateverYourAuditReportingServerNameIs>;initial
10. Under the Connect Using section, change from “Credentials are not required” to
“Windows Integrated Security” and click Apply.
11. On the top of the page, click Audit Reports to get back to the audit report
12. To test, log on and off of a couple of machines that you enabled audit collection on. Then, back on the Operations Manager server, open http://<WhateverYourAuditReportingServerNameIs>/reports and under Audit Reports, click the Usage – User Logon report. This report displays logon activity of the specified user in the specified time period on computers that have audit collection enabled.
– J.C. Hornbeck