Not sure why, but the above query did not quite work. Here is my query from SCCM 2012 to list all servers that do not have the SCCM client installed: <code> 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.OperatingSystemNameandVersion like "%server%" and SMS_R_System.Client is null </code> -Raj W.
This might sound like a silly question but how can you tell if Network IP (subnet) discovery is running or even queued up? I checked the netdisc.log and there are no events since this past Sunday. I added a new subnet AND I created a new schedule for today. The time for the job to run had past and I don't see any network discovery. I see that AD Group discovery has run. I see that AD System discovery has run.... but nothing for Network Discovery. Confused.. Thanks, Raj