SQL Query : Add/Remove Progs + Version + Install Date

Extracts data directly from Add/Remove Programs

SELECT VRS.Name0
    ,HIS.ARPDisplayName0
    ,HIS.Timestamp
    ,HIS.ProductVersion0
 FROM v_HS_INSTALLED_SOFTWARE HIS
    join v_R_System VRS on HIS.ResourceID = VRS.ResourceID
 WHERE ARPDisplayName0 like 'Microsoft Office 365 ProPlus%'
 ORDER by VRS.Name0

Sample OUTPUT

Related posts

Leave a Comment