PENDING SCCM Inventory Report

[khisrawa]

Hello

i need help on creating the query in sccm report.
Select Distinct
sys.Netbios_Name0,
sys.User_Domain0,
sys.User_Name0,
sys.AD_Site_Name0

FROM
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
sys.ResourceID in (select sys.ResourceID
from
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
where
DisplayName0 like '%AppName%'
and Version0 like 'version')
and sys.Operating_System_Name_and0 like '%workstation%'

 

[Garth]

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

 

[khisrawa]

i can't find the built-in report. thats why running my own report dont know where to put the code.

 

[Hackmuss]

There is a built-in report called 'Computers with a specific product name and version'. It is in the 'Software - Companies and Products' section.

 

[khisrawa]

yes, it won't generate the report comes empty.

 

[Hackmuss]

Do you know you definitely have Wireshark installed somewhere?
If you type nothing in the box, do you get the full list of all products installed?
If not, do other reports work OK?

 

[khisrawa]

none of report works. and no software showing either.

 

[Hackmuss]

OK - so looks like you need to review the configuration/set-up of your Reporting Services Point.
Check the post here:

https://www.prajwaldesai.com/install-sccm-reporting-services-point-ssrs/

 

[Garth]

First start off this this built-in report. Count of all instances of software registered with Add or Remove Programs

 

[Garth]

yes, it won't generate the report comes empty.
View attachment 5656

This report is base on SW inv., which is not enabled by default. Use Count of all instances of software registered with Add or Remove Programs instead.