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
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Hi Team
Am looking for Sql query to get Audio driver installed date and version for all system
Answers ( 2 )
Thanks lot for your Quick response its working as expected
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