SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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
Published Jul 02 2012, 08:27 PM by Garth
Filed under: , , , , , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems