PENDING SCCM – REPORT ALL SOFTWARE IN ADD AND REMOVE PROGRAMS

[Samrith]

SCCM – REPORT ALL SOFTWARE IN ADD AND REMOVE PROGRAMS

Select DISTINCT SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.CompanyName, SP.ProductName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = ‘ITI’
ORDER By SYS.Netbios_Name0, SP.CompanyName, SP.ProductName, SP.ProductVersion

I tried with some device collection. Result report blank. Please help to correct it.

 

[Garth]

What is wrong with the built-in report for this?

 

[Garth]

SCCM – REPORT ALL SOFTWARE IN ADD AND REMOVE PROGRAMS

Select DISTINCT SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.CompanyName, SP.ProductName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = ‘ITI’
ORDER By SYS.Netbios_Name0, SP.CompanyName, SP.ProductName, SP.ProductVersion

I tried with some device collection. Result report blank. Please help to correct it.

BTW, v_GS_SoftwareProduct is NOT ARP!

 

[Samrith]

What is wrong with the built-in report for this?

For Build-in report, I don't find - REPORT ALL SOFTWARE IN ADD AND REMOVE PROGRAM. I do need a report which show all software registered in Add Remove Program for all computers. Please share.

 

[Prajwal Desai]

Go to Monitoring > Reporting > reports and you should find 4 reports.. Are the reports not visible in your case ?.