The Exchange Server Configuration report doesn’t return any data


I figured out why - and instead of just posting about the workaround... I thought I'd take a moment and post on the process I used to determine the how and the why:


When you run the "Exchange Configuration Report" per the guide, you are supposed to add objects of type "Exchange 2003 Role".  Well, if you do this - the reports will never return any data.


image


So - to try and look at the SQL code... I went to the RDL file in the reporting website....  http://reportingservername/reports


I browsed over to the report - which I found at:  Home > Microsoft.Exchange.Server.2003.Monitoring > Report.Exchange.ExchangeServerConfiguration.  Select the "Properties" link.... and normally there would be an "Edit" button here... where I could download the RDL (report definition) file.... but instead - I see this is a linked report:


image


Aha!  It is linked to: /Microsoft.SystemCenter.DataWarehouse.Report.Library/Microsoft.SystemCenter.DataWarehouse.Report.CustomConfiguration


Microsoft.SystemCenter.DataWarehouse.Report.Library is the Generic Report library.... so off I go looking for a generic report. 


Found it:


image


So - I simply run this report.... and immediately I can see something different... I am now offered a new parameter area... called Report Fields.  So, I add the Exchange 2003 Roles instance to the report as an object.... and now I can pick and choose from a whole list of discovered attribute data.... and customize the order I want it to show up in:


Here I am running the report for the same object... and now I get to pick the cool things I want to see:


image


Now.... if I want to run this report in the future... and add more servers, etc... I simply save it to my favorites.  Then - on future runs of the report, I can drop the parameter header back down and make any changes I want.

Comments (1)

  1. Blake Mengotto says:

    Thanks for this, too bad it isn’t outlined in the Exchange MP guide.

Skip to main content