Skip to content

All Windows 7 Systems

Featured Replies

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.

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

  • Author

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

  • Author

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

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

  • 9 months later...

hi there,

 

where this table SMS_R_SYSTEM is stored?

 

i tried to find it almost everywhere but i couldnot.

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

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...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.