Query Help

declare @olddate datetime
set @olddate=dateadd(day,-8, getdate())

select
CS.Name0 as ‘Computer Name’,
arp.installdate0 as ‘Installed Date’,
arp.displayname0 as ‘Application Name’,
from
dbo.v_GS_ADD_REMOVE_PROGRAMS arp,
dbo.v_GS_Computer_System CS
where
CS.resourceid = arp.resourceid
and datediff(DD,arp.installdate0, @olddate) < 8
and displayname0 not like (‘%Update%’)
and displayname0 not like (‘%hotfix%’)
and arp.installdate0 not like (‘NULL’)
order by
CS.Name0,
installdate0 desc

Leave a Reply

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