List of PC with Project and Subnet

For full details, see posts:

http://www.myitforum.com/forums/SCCM-report-m235714.aspx

http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/07158c51-06e1-4afb-8a46-187eaf8e82eb

 

select Distinct
	CS.Name0
from 
	dbo.v_GS_COMPUTER_SYSTEM CS
	join dbo.v_Add_Remove_Programs ARP on CS.ResourceID = ARP.ResourceID
	join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceID = NAC.ResourceID
Where
	ARP.DisplayName0 like '%Project%'
	and (IPAddress0 like '10.1.%'
	or IPAddress0 like '10.4.%')

Leave a Reply

Your email address will not be published. Required fields are marked *