ARP Dates

select
CS.Name0 as ‘Computer Name’,
  convert(datetime,isnull(ARP.installdate0,’1980-1-1′)) as ‘Installed Date’
From
dbo.v_GS_ADD_REMOVE_PROGRAMS ARP,
dbo.v_GS_COMPUTER_SYSTEM CS
Where
CS.ResourceID = ARP.ResourceID

Leave a Reply

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