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 SMS_R_System.AgentName = "Manual Machine Entry"
and SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId
from SMS_R_System where SMS_R_System.AgentName =
"Heartbeat Discovery")
this query gets manual machine entries that do not have a heartbeat. Same
thing right?
Todd
From: [email protected] [mailto:[email protected]] On
Behalf Of Jason Wallace
Sent: Tuesday, September 22, 2015 7:53 AM
To: [email protected]
Subject: [mssms] Collection Query Brainfade
Hello folks
I wanted to take a collection query and extend it a little. As a result of
this I have gotten up myself so reaching out for help.
I want to be able to build a collection which contains devices where "Manual
Machine Entry" AgentTime is greater than "Heartbeat" AgentTime
Aim here is to try and speed up the collection processing speed for newly
reimported devices
Jason
