If they have both, doesn't that mean that the SCCM client has been installed? All of my clients are this way post deployment. In which case, I don't think you could ever have manual machine entry be after heartbeat.. unless there's something going on with record reconciliation?
Say a record was created manually, but there already exists a client on a device with slightly different data but close enough to the manual entry that CM merges the records? In that case, I could see how heartbeat could be before manual entry. However if the client were healthy, you'd expect the heartbeat to change regularly, and then over take manual entry. A weird one to be sure... From: [email protected] [mailto:[email protected]] On Behalf Of Jason Wallace Sent: Tuesday, September 22, 2015 8:41 AM To: [email protected] Subject: RE: [mssms] Collection Query Brainfade 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]> [mailto:[email protected]] On Behalf Of Mote, Todd Sent: 22 September 2015 14:21 To: '[email protected]' <[email protected]<mailto:[email protected]>> Subject: RE: [mssms] Collection Query Brainfade 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]> [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
