SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Let’s learn in this blog post how to create SCCM Dynamic report link to get specific application details installed on systems.

Most of the SCCM administrators might receive requests to provide the report, like a specific application installed on how many devices. Then as an admin, you have to go to the SQL database, write a query, extract a report, and share.

This is a daily task for the SCCM admin. So I feel let’s automate this task and create a custom query link. I will share my experience on how to create a Dynamic report link to get the specific applications installed on the machines.

After creating the custom report link, you can share it with respective members to get the details easily.

Patch My PC

How to Create Dynamic Report Link

Before creating a custom report link, create a folder where you need to keep all the custom links. There are options available in ConfigMgr Console and SQL server report link to create custom reports.

In the Configuration Manager console, go to the Monitoring tab -> Reporting and right-click create a report. Provide the name of the report and browse the path where you want to save the report.

Click next to complete the task. Then edit the report in report builder.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Also, you can browse the SQL server report link, go to the folder location and select the report name you created in the ConfigMgr console. Edit the report with report builder.

Adaptiva

You see this below screen as we already integrated the Power BI with our lab SCCM environment. But in your case, the below would not be the same.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
Custom Report – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Note: If you have already installed the report builder in the ConfigMgr box, then you can edit the report in the same box.

Once you edit the report in report builder it will show as below screen.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
Custom Report in Report Builder – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Expand the Datasets Select the dataset and Right-click. Then click ‘Dataset Properties‘.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
Edit Report in Report Builder – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Paste the below query in the Query field.

select VRS.Name0 as 'Machine Name',
ARP.DisplayName0 as 'Application Name',
ARP.Version0 as 'Version',
ARP.Publisher0 as 'Publisher',
ARP.InstallDate0 as 'Application Installed Date'
from v_Add_Remove_Programs ARP
join v_R_System VRS on ARP.ResourceID=VRS.ResourceID
where ARP.DisplayName0 like @ProgramName
SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
SQL Query in Report Builder – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

After pasting the query, once you click on the ‘Ok’ button, it will ask you to provide the user name and password to connect to the data source. If you have full permission, you can choose the ‘Use the Current Windows User‘ option. Else you can use your user name and password.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
User Credential – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Once you submit the Ok button, you will see all the fields will be created below Datasets. Now go to the ‘Insert’ tab and Create table according to the requirement. Do the formatting and select the appropriate fields in each column.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
Custom Report Fields in Report Builder – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

For example, I’m using the Report Name, Folder Path, Report URL, etc., on the report page.

To create such a field, create another table and specify the name you want to use in the table. In each field Right-Click on the column and select ‘Expression.’

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
Custom Report Header – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Go to ‘Built-in Fields‘ and choose the appropriate ‘Item‘ according to the table. Copy the field from the Example and paste it into the Value Expression Tab. Then click Ok.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
Custom Report Value – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Result of the Dynamic Report

To check the report, click on the report link and open it on the browser. Put the application name you want to look for and click on View Report to get the results.

SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr
Dynamic Report Application Installed – SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr

Resources

Author

Debabrata Pati has more than 7+ years of experience in IT. Skilled in MEMCM, Azure, and Powershell. More than five (5) years of experience in MEMCM (SCCM) administration, OSD, and Troubleshooting for the environment with more than 100K client devices.

1 thought on “SCCM Dynamic Report Link to Get Specific Application Details | ConfigMgr”

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.