SOLVED SCCM Report for Installed Softwares on Computers + User Names

[Diego Rodrigues de Paula]

A few days ago I have tried to create a report that gives me the information of Applications installed on computers of a specific collection, showing the name of the computer in front of each application name.

Can someone help me?
Thank you

 

[Edy]

this is the SQL version

select distinct Netbios_Name0, User_Name0, DisplayName0, Version0, Operating_System_Name_and0 Version0 from v_R_System vrs inner join v_Add_Remove_Programs varp on vrs.ResourceID = varp.ResourceID inner join v_FullCollectionMembership vfcm on vrs.ResourceID = vfcm.ResourceID
where (varp.DisplayName0 like '%APPNAME%') and (varp.Version0 like '%VERSION%') and vfcm.CollectionID = '%COLLECTIONID%'

 

[Diego Rodrigues de Paula]

this is the SQL version

select distinct Netbios_Name0, User_Name0, DisplayName0, Version0, Operating_System_Name_and0 Version0 from v_R_System vrs inner join v_Add_Remove_Programs varp on vrs.ResourceID = varp.ResourceID inner join v_FullCollectionMembership vfcm on vrs.ResourceID = vfcm.ResourceID
where (varp.DisplayName0 like '%APPNAME%') and (varp.Version0 like '%VERSION%') and vfcm.CollectionID = '%COLLECTIONID%'

Thanks for the answer,

Is it possible to list ALL installed applications for ALL computers in a specific collection?

Even if this research brings many things

 

[Diego Rodrigues de Paula]

this is the SQL version

select distinct Netbios_Name0, User_Name0, DisplayName0, Version0, Operating_System_Name_and0 Version0 from v_R_System vrs inner join v_Add_Remove_Programs varp on vrs.ResourceID = varp.ResourceID inner join v_FullCollectionMembership vfcm on vrs.ResourceID = vfcm.ResourceID
where (varp.DisplayName0 like '%APPNAME%') and (varp.Version0 like '%VERSION%') and vfcm.CollectionID = '%COLLECTIONID%'

Thank you !

Based on your query, i'm working in a more detailed report , when i finish ill be post the result here .

Thank you , one more time

 

[Edy]

Thanks for the answer,

Is it possible to list ALL installed applications for ALL computers in a specific collection?

Even if this research brings many things

remove this bit will do the job
(varp.DisplayName0 like '%APPNAME%') and (varp.Version0 like '%VERSION%')