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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...