All Windows 7 Systems

[XPrten]

When I use the settings from your topic "All Windows Vista Systems", I also get all Windows 7 Systems.

I would like to separate Vista from 7 but I don't know how.

[anyweb]

try the following Query instead, notice the use of = instead of like

 

All Windows 7 systems

 

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 OperatingSystemNameandVersion = '%Workstation 6.1%'

 

All Windows Vista Systems

 

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 = "%Workstation 6%"

[XPrten]

Thanks but that didn't work

I had to do like this to separate 7 from Vista

 

All Windows 7 systems

 

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.Name like "%7%"

 

All Windows Vista Systems

 

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.Name like "%Vista%"

[anyweb]

what do you mean it didnt work ? did you update the collection membership/refresh ?

[XPrten]

Yes I did, but it could not find any machines.

When I used my code it did find all of my Windows 7

[Constantine]

hi there,

 

where this table SMS_R_SYSTEM is stored?

 

i tried to find it almost everywhere but i couldnot.

[Trevor Sullivan]

Hello Constantine,

 

In answer to your question, SMS_R_SYSTEM is a Windows Management Instrumentation (WMI) class definition that resides in the SCCM provider's WMI namespace (eg. root\sms\site_lab). It directly maps to the SQL view (not table) named v_R_System in your SCCM database.

 

When SCCM populates "system resources" into collections, those system resources represent instances of the SMS_R_SYSTEM class. If you look at the WMI class definition, you'll notice all the same properties that show up in a collection enumerated inside the console. Examples of those properties are: Name, Domain, Client, Active, Obsolete, and so on.

 

Hope this helps.

 

Cheers,

Trevor Sullivan

http://trevorsullivan.net

http://twitter.com/pcgeek86