SQL Squery for Audio Drver Installed date and version

Question

Hi Team
Am looking for Sql query to get Audio driver installed date and version for all system

solved 0
Naga Raju 12 months 2020-05-06T15:35:25+05:30 2 Answers 477 views Beginner 0

Answers ( 2 )

  1. Naga Raju
    0
    2020-05-06T16:58:39+05:30
    Reply

    Thanks lot for your Quick response its working as expected

  2. Mohan Kumar
    1
    2020-05-06T16:22:53+05:30
    Reply

    Hi NagaRaju,

    Actually Audio driver package installation details recorded in Add & Remove programs, try this query.

    Select
    vrs.Name0 AS [Computer Name],
    vrs.Resource_Domain_OR_Workgr0 [Domain],
    opp.Caption0 [Operating System],
    CASE WHEN b.ClientActiveStatus = 1 then ‘Active’ else ‘InActive’ end as ‘CM Client Active Status’,
    sof.DisplayName0 [Installed Software],
    sof.Version0 [Version],
    sof.Publisher0 [Publisher],
    sof.InstallDate0 [Software Installed Date]

    FROM
    dbo.v_R_System AS VRS LEFT OUTER JOIN
    dbo.v_CH_ClientSummary as b on vrs.ResourceID = b.ResourceID left outer join
    dbo.v_ADD_REMOVE_PROGRAMS AS SOF ON vrs.ResourceID = sof.ResourceID LEFT OUTER JOIN
    dbo.v_GS_OPERATING_SYSTEM AS OPP ON vrs.ResourceID = opp.ResourceID

    where sof.DisplayName0 like ‘%Audio%’
    AND sof.Version0 not like ‘NULL’

    Let us know if it helps you

    Best answer

Leave an answer

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