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

solved 0
sridhar k adhisheshaiah 2020-06-25T15:10:46+05:30 1 Answer 195 views Beginner
0

Answer ( 1 )

  2. Anoop C Nair
    0
    2020-06-25T22:24:08+05:30
    Reply

    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’

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .