SOLVED Crteating report like ARP MS patches Install Date

[Tino_B]

Hi,
I try to create a Report which shows me all Computers from a specified collection with all installed MS Updates. The important thing is the install date. Like the overview in ARP but as Report.
I tried include a mof File to get the install date and the Update overview.
Has anybody tried it before?

 

[Gokul]

Hi There ,

try this and you have to add one query for specific collection which

v_add_remove_Programs.

select sys.Name0 as PCName,
arp.DisplayName0 as Program,
InstallDate0 as Time
from v_Add_Remove_Programs arp
inner join v_R_System sys on sys.ResourceID =arp.ResourceID
where arp.DisplayName0 like '%<YourAPPName>%'