FAQShop.com : Finding Machines that Have Installed the SMS Client but Aren’t in the SMS Database or Assigned

Finding Machines that Have Installed the SMS Client but Aren’t in the SMS Database or Assigned

Is there any way I can find out how many machines installed the SMS client but didn't show up in the database or are assigned to any site? Basically, I just want to find out the number, irrespective of their successful client installs.

Contributed By: Hans Schefske [MVP SMS]
You would have to create a query to look for system where the SMS Assigned Site Value is NULL, similar to the one below:

Copy and paste this into the WQL query Language Window, when creating the new query:

==========================================================
select IPAddresses, IPSubnets, LastLogonUserName, NetbiosName, SMSAssignedSites, ClientVersion, ResourceDomainORWorkgroup from SMS_R_System where SMSAssignedSites is NULL
==========================================================

If they installed the client and are not in the database (i.e. local DDR got created but never made it to the SMS Site server to be put in the database), there is no good way to locate these systems since no data has been put in the database about them. If they have at least been discovered then you have at least some (minimal) information to work with.