Jump to content




XPrten

All Windows 7 Systems



Recommended Posts



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%"

Share this post


Link to post
Share on other sites

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%"

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×