It is possible to create custom reports for Exchange 2007 using the Service Level Dashboard Solution Accelerator and the Exchange 2007 Management Pack. The Opsmgr Team made a nice guide on how to make a Service Level Dashboard for Exchange.
But you have to change the Monitor dependency of the distributed applications otherwise the Health wouldn’t rolling up.
In the monitoring section of the console, under “Distributed Applications”, right-click on the “Exchange 2007 Server Availability” distributed application that you defined and select to open the Diagram View
Right-click on Exchange 2007 CAS Servers and select “Health Explorer”.
Right-click on Component Group Health Roll-up for type Ex. Client Access Servers and select “Monitor Properties”.
On the Monitor Dependency tab, click “MOM 2005 Computer Role Health” and click ok. This will allow health to roll up to the Component Group level. By default, health of converted Management Packs rolls up via MOM 2005 Computer Role Health.
But now come the tricky part. The state of you distributed applications will stay on unmonitored until a state change occurred for state to start rolling up.
The solution for this problem is just to put your exchange servers in maintenance mode for a while!
That’s how I resolved the unmonitored issue for my service level dashboard.
After the maintenance mode my