Find all SW installed using the timestamp field

Set nocount off
Declare @now datetime
set @now = getdate()

SELECT DISTINCT
CS.Name0,
ARP.DisplayName0,
ARP.TimeStamp
FROM
v_GS_ADD_REMOVE_PROGRAMS ARP,
v_GS_COMPUTER_SYSTEM CS
WHERE
CS.ResourceID = ARP.ResourceID
And DateDiff(dd,ARP.TimeStamp, @now) < 30

Leave a Reply

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