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
Answers ( 3 )
Have You already Find out the Fix for this issue. This thread is been inactive more many days hence closing the forum thread .If in case any additional details needed ,please feel free to raise a new question.
Have You already Find out the Fix for this issue. This thread is been inactive more many days hence closing the forum thread. If in case any additional details needed ,please feel free to raise a new question.
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’