interior of office building
Photo by Manuel Geissinger on

Sometimes inbuilt reporting doesn’t suffice the requirement and you have to be little more creative in order to achieve your answer:


I have got the requirement from security department in my company asking for details of all ARP entries for specific devices with the installed date, tried multiple things but didn’t get the expected data.

Then I tried below query which I have created, you have to play little with excel once you get the data but it may helpful for you as well as you can add and change columns as per your need:


select sys.Netbios_Name0, arp.DisplayName0, arp.Version0, arp.Publisher0, arp.InstallDate0 from v_R_System sys  left join v_Add_Remove_Programs arp on sys.ResourceID = arp.ResourceID  left join v_FullCollectionMembership C on sys.ResourceID = c.ResourceID  where c.CollectionID like 'XXXXXX'