Adding software version to SMS report 1

[billybarty]

I am using the built-in report "computers with specific software listed in add\remove programs". I would like the report to have the software version as well as the other info in the report.
This is the statement currently,
Select sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0
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

 

[johnnyb99]

Add arp.Version0 to your "Select" statement ... the is Version0 from v_GS_ADD_REMOVE_PROGRAMS.

 

[billybarty]

Thanks for the help.