Tuesday, July 18, 2017

Application NOT Installed machine names query

Application NOT Installed machine names
-------------------------------------------------------------------------

select v_R_System.ResourceID,
v_R_System.Netbios_Name0 as 'ComputerName',
v_r_system.Full_Domain_Name0 as 'Domain Name',
v_R_System.Name0,
User_name0,
v_R_System.SMS_Unique_Identifier0,
v_R_System.Resource_Domain_OR_Workgr0,
v_R_SYSTEM.Client0
from v_R_System
inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceId
where v_GS_COMPUTER_SYSTEM.Name0 not in
(select distinct v_GS_COMPUTER_SYSTEM.Name0
from  v_R_System inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.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_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE '%Microsoft Outlook MUI (English) 2016%' AND  v_GS_ADD_REMOVE_PROGRAMS.prodID0 Like '%XXXXXXXX%' AND
V_GS_ADD_REMOVE_PROGRAMS.version0 like '%XXXXXXXXX%')


-------------------------------------------------------------------------------------------------------



select v_R_System.ResourceID,
v_R_System.Netbios_Name0 as 'ComputerName',
v_r_system.Full_Domain_Name0 as 'Domain Name',
v_R_System.Name0,
User_name0,
v_R_System.SMS_Unique_Identifier0,
v_R_System.Resource_Domain_OR_Workgr0 as 'Region',
v_R_SYSTEM.Client0
 from v_R_System
where v_R_System.Netbios_Name0 not in

(select distinct v_GS_COMPUTER_SYSTEM.Name0
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)
inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceId


Where v_GS_SoftwareFile.FileName = 'outlook.exe'and ProdID0 = '{XXXXXXXXXX}' and Version0 = 'XXXXXXXXXXXX')








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