Tuesday, July 18, 2017

Application installation report for a OUTLOOK.EXE

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'

No comments:

Post a Comment

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...