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')
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