SQL Query To return MOM Resources Heartbeat Age

 

This MOM SQL query will return the heartbeat age in days for all MOM resources.

 

SQL Query:

 

Select

C.Name,

DateDiff(D, H.LastHeartbeat, GetDate()) 'Last Heartbeat Age'

From Computer C

Join ComputerHeartbeat H on C.IdComputer = H.IdComputer

 

Published Sunday, July 08, 2007 7:08 AM by dhite
Filed under:

Comments

# re: SQL Query To return MOM Resources Heartbeat Age

hi..

firstlry Im not sure where to post a question, so Im using the comment area. Sorry abouy it.

I want a sql query that gets the count of public folders from SystemCentreReporting (MOM 2005). Simililary other queries to find count of servers like LCR, CCR. Can you provide me where to find these data in SystemCentreReporting ?

Thanks.

Thursday, September 04, 2008 11:37 PM by DFELIX19