When servers appear to be missing from the the availability reports it could be because of many reasons, but whenever I run into this type of issues these are the kinds of troubleshooting steps I take.
First of all, to troubleshoot this issue we should be clear on the workflow going on behind the scenes that allows these reports to work:
If any of these fail then the report will not be generated.
A few of the issues are listed below:
The system is not generating 7036 events:
The 7036 events are generated by the System Control Manager. In case they are not getting generated for a stop or start of the service try the following:
The system is generating 7036 events but some servers are missing from the reports:
· Event - Run Availability Reporting Service Discovery (Enabled)
· Collection - Availability Reporting Service Synthetic Uptime Event Collection (Enabled)
· Event - Availability Reporting Service Synthetic Uptime Event Generation (Enabled)
SELECT distinct ms.nvcServerName,* FROM mras_Sojourn s JOIN MRAS_ApplicationVersion av ON s.ServerVersion = av.uidApplicationVersion JOIN mras_server ms ON ms.uidServer=av.UidServer WHERE modelname like '%<ModelName>%' AND nvcServerName='<SERVERNAME>' ORDER BY timein desc
Note: <Modelname> is Exchange ,AD,SQL,OS etc and <Servername> is the name of the server not appearing in the list.
http://support.microsoft.com/kb/899158 or http://blogs.technet.com/smsandmom/archive/2006/07/13/441644.aspx
To troubleshoot ReliabilityAnalysisReporting you can use:
http://support.microsoft.com/kb/926102 or http://support.microsoft.com/kb/918119
Select * from dbo.MRAS_ReportFriendlyname where reportName like ;%<ReportName>%’
The report name is the name of the report given when we scheduled the report. From the output of this query you will get the uidreport value which corresponds to the report we are looking for. With that value of the uidreport run this query:
select * from dbo.MRAS_ReportRunLog where uidreport =’<the result of the previous query>’
Then check the value of the istatus column corresponding to the report:
0 : Success 1 : Failed 2 : No Data
· select * from dbo.computer where name='<SERVERNAME>'
· select * from DBO.SC_COMPUTERDIMENSION_TABLE WHERE computername_pk= '<SERVERNAME>'
· select * FROM DBO.MRAS_SERVER WHERE nvcServerName='<SERVERNAME>'
Hope this helps,