This is using MS SCCM 2012 R2 server. The reporting service point was installed and SRSS is working fine. I know that in monitoring > reporting > reports, there is a report called " All program in add/remove for specific computer. Please see the query:
Select v_Add_Remove_Programs_Alias.DisplayName0, v_Add_Remove_Programs_Alias.Publisher0, v_Add_Remove_Programs_Alias.Version0
FROM fn_rbac_Add_Remove_Programs(@UserSIDs) v_Add_Remove_Programs_Alias
JOIN fn_rbac_R_System(@UserSIDs) v_R_System_Alias ON v_Add_Remove_Programs_Alias.ResourceID = v_R_System_Alias.ResourceID
WHERE v_R_System_Alias.Netbios_Name0 = @computername
However, how to modify to prompt for "collectionID" instead computername, so as, all programs of all computers in the collection is diplaying? Please show step-by-step.
Thanks in advance.