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 4 months 1 Answer 120 views Beginner 0

Answer ( 1 )

  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’

    Best answer

Leave an answer

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