SELECT DISTINCT
v_R_System.Netbios_Name0 as 'ComputerName'
,v_r_system.Full_Domain_Name0 as 'Domain Name'
, v_gs_softwareFile.FilePath
,v_gs_softwarefile.filename
,v_GS_ADD_REMOVE_PROGRAMS.InstallDate0
,v_GS_ADD_REMOVE_PROGRAMS.DisplayName0
FROM v_R_System INNER JOIN v_GS_SoftwareFile
ON (v_GS_SoftwareFile.ResourceID = v_R_System.ResourceId)
inner Join v_GS_ADD_REMOVE_PROGRAMS
on (v_GS_ADD_REMOVE_PROGRAMS.ResourceID = v_R_System.ResourceID)
WHERE v_GS_SoftwareFile.FileName = 'outlook.exe' and V_GS_ADD_Remove_programs.DisplayName0 like 'Microsoft Office Professional Plus 2016'
Subscribe to:
Post Comments (Atom)
site backup job manually
Start a scheduled SCCM 2012 site backup job manually You might want to start a scheduled SCCM 2012 site backup job manually. off co...
-
Application app enforcement deployment status with installation errors select distinct vrs.user_name0,fn.machinename,fn.applicationnam...
-
SQL Query for Computers Disk Space :- Select v_R_System.name0, v_R_System.Resource_Domain_OR_Workgr0 as Domain, v_GS_LOGICAL_DISK....
-
SQL Query To Return Add OR Remove Programs Installed On A Specified Machine SQL Query: Select P.DisplayName0, P.ProdId0, P.Publis...
No comments:
Post a Comment