SCCM WMI question

I’m trying to query SCCM , filtering by computer, using the following script:

Get-WmiObject -ComputerName SOMESERVER -Namespace “root\sms\site_SOMESITE” -Class “SMS_CollectionMember_a” -Filter “ResourceID=‘SOMEDEVICEID’”

It isn’t outputting anything though I’ve confirmed via the SCCM console that the Device ID is correct and the machine does belong to several collections. I would appreciate some help.

Have you tried this with the -Filter removed?

SCCM comes with a bunch of cmdlets. If you like to make your life easier you should use those.

Don, I did try it. There are over 2,000 machines in SCCM. Based on the time the query ran I think it was successful, however, again it didn’t output any information.

Olaf, thank you for the suggestion. I looked into using Get-CMDevice but felt that the WMI Objects were better suited to my needs. I may have to reinvestigate.

For investigative purposes only you could try

Get-WmiObject -ComputerName SOMESERVER -Namespace “root\sms\site_SOMESITE” -Class “SMS_CollectionMember_a” | Where ResourceID -eq SOMEDEVICEID

ResourceID should be a 32 bit unsigned integer

Alternatively try

Get-WmiObject -ComputerName SOMESERVER -Namespace “root\sms\site_SOMESITE” -Class “SMS_CollectionMember_a” | sort ResourceID
| select Name, ResourceID

The SMS_CollectionMember_a class is documented here

Thanks Richard. That query works and will suffice for my immediate needs.