Device Collection - Not checked in for 30 days

[bowlen]

Hi Guys,

 

I'm wanting to create a query based device collection which shows all computers that have not checked in for the last 30 days.

 

I can see a query that would show machines that haven't had a software scan in the last 30 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 inner join SMS_G_System_SUP_SCAN_TOOL on SMS_G_System_SUP_SCAN_TOOL.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SUP_SCAN_TOOL.LastCompletionTime <= DATEADD(dd,-30,GetDate())

 

But I was wondering if there's a query which will target the "Days since last communication" field?