You can apply this query on SCCM 2007/2012. This query will show the machines that are not contacting with SCCM from the last 15 days.
****************************************
select
SMS_R_System.ResourceID,
SMS_R_System.ResourceType,
SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_R_System.Client from SMS_R_System where AgentName in ("Heartbeat Discovery") and DATEDIFF(day,AgentTime,GetDate())>=15
***************************************
No comments:
Post a Comment
Give me you feedback!