Locating Machines Not Reporting Heartbeat Discovery In The Last

Locating Machines Not Reporting Heartbeat Discovery In The Last Week - Don Hite

This SQL query will allow you to find or locate machines in your SMS database that have not reported a Heartbeat discovery record in the last week or seven days.

SQL Query:

Select
SD.Netbios_Name0,
A.AgentName,
DI.AgentTime

From System_Disc SD

Inner Join DiscItemAgents DI on SD.DiscArchKey = DI.DiscArchKey
Cross Join Agents A

Where A.AgentName = 'Heartbeat Discovery'
And DatePart (D,DI.AgentTime) >= 7