Hi there Todd
Many many thanks That is the one that I have already and what I suggested. In this environment however there seem to be a limited number of objects for which we have BOTH a Manual Machine Entry AND a Heartbeat record. I've not been able to replicate this in my lab but we see them here Jason From: [email protected] [mailto:[email protected]] On Behalf Of Mote, Todd Sent: 22 September 2015 14:21 To: '[email protected]' <[email protected]> Subject: RE: [mssms] Collection Query Brainfade select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SY STEM.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]> [mailto:[email protected]] On Behalf Of Jason Wallace Sent: Tuesday, September 22, 2015 7:53 AM To: [email protected] <mailto:[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
