Reports are all blank
I'm probably missing something simple, but ever since installing SCE, a majority of the reports in the Reporting section are blank when run. No errors or anything, the report runs, but it has no data in it. It doesn't matter what computers, groups, or objects I choose, they are all blank. Some reports, like the hardware and software lists work perfectly, but I can't get anything to show in reports for SQL Server, Exchange, and more. Does the reporting for these need to be turned on somehow? If so, how? Thanks.
May 20th, 2009 12:58am
Hi,I'd like to suggest you try the following steps to reset reporting in SCE:1. Open up the Reports site (probably <http://localhost/Reports$SCE>) . 2. Click New Data Source3. Enter the following:a. Name: WSUS Databaseb. Check both Hide in list view and Enable this data sourcec. Connection Type: Microsoft SQL Serverd. Connection string: data source=[servername]\[instancename];initial catalog=SUSDB;Integrated Security=SSPI ([servername]\[instancename] is the database server the WSUS database is on. If this was originally an upgrade of WSUS, then the name may also be different from SUSDB)e. Choose Credentials are not requiredf. Click OK or Apply4. Click New Data Source5. Enter the following:a. Name: Data Warehouse Mainb. Check both Hide in list view and Enable this data sourcec. Connection Type: Microsoft SQL Serverd. Connection string: data source=[servername]\[instancename];;initial catalog=OperationsManagerDW;Integrated Security=SSPI(servername]\[instancename] is the database server SCE was installed on.)e. Choose Credentials are not requiredf. Click OK or Apply6. Wait about 10-20 minutes for Reports to deploy7. Make sure reports run in SCE Console
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2009 1:14pm
I guess I should add some info. I guess I wasn't accurate when I said the reports were blank. The reports have the header info, but they don't contain any data, just the header. Would you still suggest the same resolution?
May 21st, 2009 7:17pm
Hi, Yes, please try the above steps
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2009 1:20pm