ARP Dates August 8, 2008 Posted by Garth Jones 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 Updated: February 24, 2016 at 5:11 pm Tags: Code, SMS, SQL ◀ Two NICs enabled at the same time History install date for ARP (example) ▶ Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website