WQL Query
Question
Hi All,
I have a Application “A” which is packaged and Tested for En Version, This needs to be deployed to around 25k+ machines.
Ran a query to see the different versions/languages available and found many different Language version’s of this Application “A”.
Can you please help if a WQL be created only for PC ‘s with English version
Answer ( 1 )
Here you GO:- Change the name of the app ….
Select Distinct
v_R_System.Name0 AS MachineName,
vSMS_R_System.Operating_System_Name_and0 AS OSVersion,
v_GS_OPERATING_SYSTEM.OSLanguage0,
v_R_System.AD_Site_Name0 as ‘Location’,
v_R_System.Resource_Domain_OR_Workgr0 as ‘Domain’,
v_Add_Remove_Programs.DisplayName0 as ‘displayname’,
v_Add_Remove_Programs.Version0 as ‘Version’
FROM dbo.v_R_System
INNER JOIN v_Add_Remove_Programs on v_R_System.ResourceID = v_Add_Remove_Programs.ResourceID
INNER JOIN dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID
INNER JOIN dbo.v_GS_OPERATING_SYSTEM on dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID
INNER JOIN dbo.vSMS_R_System ON dbo.v_R_System.Name0 = dbo.vSMS_R_System.Name0
WHERE dbo.v_GS_OPERATING_SYSTEM.OSLanguage0 = ‘1033’
and v_Add_Remove_Programs.DisplayName0 Like ‘%Mozilla Firefox%’
and v_Add_Remove_Programs.DisplayName0 not Like ‘%update%’
and v_Add_Remove_Programs.DisplayName0 not Like ‘%appsense%’
and v_R_System.Active0 = ‘1’