Try to search your question here, if you can't find : Ask Any Question Now ?

SCCM WQL Query – List version of installed application?

HomeCategory: stackoverflowSCCM WQL Query – List version of installed application?
Avatargaurav asked 4 months ago

I’m struggling to create a WQL query for SCCM as I’m really new and rarely use it in a complex manner.

My goal is to list 3 things : Computer name – Display Name (“Google Chrome”) – Display Version

I’m starting with this :

$SiteCode = "XXX"
$SiteServer = "XXX"


$query = @"

select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version
from  SMS_R_System
inner join SMS_G_System_ADD_REMOVE_PROGRAMS
on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Google Chrome"

"@


Get-WmiObject -namespace rootsmssite_$SiteCode -computer $SiteServer -query $query

The output is a bit strange to me :

__GENUS                          : 2
__CLASS                          : __GENERIC
__SUPERCLASS                     : 
__DYNASTY                        : __GENERIC
__RELPATH                        : 
__PROPERTY_COUNT                 : 2
__DERIVATION                     : {}
__SERVER                         : XXX
__NAMESPACE                      : rootsmssite_PR1
__PATH                           : 
SMS_G_System_ADD_REMOVE_PROGRAMS : System.Management.ManagementBaseObject
SMS_R_System                     : System.Management.ManagementBaseObject
PSComputerName                   : XXX

What am I missing here? Again i’m really new at this so I must be missing a key part of the logic. Much appreciated.

1 Answers
Best Answer
AvatarFernando answered 4 months ago
Your Answer

13 + 3 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com