Running Network Discovery on SMS 2.0

[Busuka]

I've loaded SP5 for SMS 2.0. I would like to discover Windows 2000 and Windows XP boxes. Can someone advise on how I can create a query or run a collection looking for these operating systems?

Thanks
Busuka

 

[ceigl]

Query for WinXP:

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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Version like "5.1%" order by SMS_R_System.Name
__________
Query for Win2000:

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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Version like "5.0%" order by SMS_R_System.Name
__________

Hope this helps !

Cheers,
Chris