History install date for ARP (example)

Select
    ARP.DisplayName0,
    HARP.InstallDate0
from
    dbo.v_GS_ADD_REMOVE_PROGRAMS ARP,
    dbo.v_HS_ADD_REMOVE_PROGRAMS HARP
Where
    ARP.ResourceID = HARP.ResourceID
    and ARP.ProdID0 = HARP.ProdID0
Group by   
    ARP.DisplayName0,
    ARP.InstallDate0,
    HARP.InstallDate0
Having
    isnull(ARP.InstallDate0,’1980-1-1′) <> Min(isnull(HARP.InstallDate0,’1980-1-1′))
Order by
    ARP.DisplayName0,
    HARP.InstallDate0

Leave a Reply

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