Query Statement to discover computers without SCCM Clients
I need to create a query statement to accurately identify/discover machines on the network without an SCCM Client? Please advise...
April 8th, 2011 12:40pm

There's one built in: it's called "All Non-Client Systems".Jason | http://myitforum.com/cs2/blogs/jsandys | Twitter @JasonSandys
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2011 1:28pm

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.Client is nullKent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
April 8th, 2011 1:34pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics