Reporting in SCE
I am trying to run some basic report from the SCE console but I always get a empty report. These are the steps I follow:1) In SCE, I click on Reporting2) Click on Windows Client XP Pro OS3) Double-Click on Logical Disk report4) Set the dates from Yesterday to Today, add group ALL Computers.5) Click on RUNI get an empty reportPlease let me know if I am doing anything wrong or if this function will not work for.The only report I am able to run in Essential Reports.Our current set up: Running SCE2007 on Windows Server 2008 which is also running SQL Server 2005 express.
August 12th, 2009 11:29pm

Hi, Please try the following steps to reset reporting in SCE: 1. Open up the Reports site (probably <http://localhost/Reports$SCE>) . 2. Click New Data Source 3. Enter the following: a. Name: WSUS Database b. Check both Hide in list view and Enable this data source c. Connection Type: Microsoft SQL Server d. 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 required f. Click OK or Apply 4. Click New Data Source 5. Enter the following: a. Name: Data Warehouse Main b. Check both Hide in list view and Enable this data source c. Connection Type: Microsoft SQL Server d. 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 required f. Click OK or Apply 6. Wait about 10-20 minutes for Reports to deploy 7. Make sure reports run in SCE Console
Free Windows Admin Tool Kit Click here and download it now
August 14th, 2009 11:58am

Hi,I should try this even though some of the reporting works? I just don't wantto mess up anything.Basically, I just want to knowwhen I am in Reporting and try to run the Windows Client XP Report that it should work with my current set up.What will the steps above do?
August 14th, 2009 8:32pm

Hi, Above steps will reset reporting in SCE, did you try it? How about the result?
Free Windows Admin Tool Kit Click here and download it now
August 18th, 2009 1:16pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics