How to find an application installed in the last 7 days

For full details see

http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f96191-6e3e-4150-8f3a-18b1c4db8d7d

SELECT
	R.Netbios_name0,
	R.AD_Site_Name0,
	ARP.DisplayName0,
	ARP.InstallDate0,
	DATEDIFF(Day, CONVERT(Datetime,ARP.InstallDate0), GETDATE()) AS [days since installed]
FROM
	dbo.v_R_System R 
	join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = R.ResourceID
	join dbo.v_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = R.ResourceID
WHERE
	(ISDATE(ARP.InstallDate0) =1) 
	AND ARP.DisplayName0 = 'Enhanced Web Reporting' 
	AND FCM.CollectionID = 'SMS00001'
	and Datediff(dd,ARP.InstallDate0,getdate()) < 7

Leave a Reply

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