Report Tweaking Help – Installed Date

Select
    sys.Netbios_Name0,
    fcm.SiteCode, 
    sys.User_Domain0,
    sys.User_Name0,
    sys.Operating_System_Name_and0,
    arp.DisplayName0,
    ARP.InstallDate0
FROM
    v_R_System sys
    JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
    JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE
    DisplayName0 = @displayname
    and fcm.CollectionID=@CollID

Leave a Reply

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