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...
-
select SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS...
-
select Name0, netbios_name0,user_name0,ProdID0 ,Displayname0, installdate0,publisher0,version0 from v_r_system inner join v_Add_Remove_Prog...
No comments:
Post a Comment