SCCM SQL Report – Compare Installed Apps on TWO Different Computers

Recently, I worked on an SCCM report that compares the list of applications installed on two different computers—typically an older device and a new PC. This is particularly useful in scenarios such as hardware migrations or system upgrades or Virtual to physical migration, where you need to ensure that users have the necessary applications on their new devices.

Why This Report is Useful:

Though customer is using SCCM for application deployments, but there is no standard practice of automated deployments of applications such as user/device based requests etc. During the process of migrating users to new hardware, the management of applications is going to hard task.

if you are using user targeted applications, as the user goes to new device, the targeted applications will get installed automatically otherwise devices need to be mapped accordingly (tedious task)

This SCCM report helps the comparison process, providing a detailed list of applications installed on both the old and new PCs.

SQL Views used in the report:

How to Use the Report:

Here’s a step-by-step guide on how to use this report:

1. Download the Report: First, download the report from the GitHub repository.
   
2. Upload to SSRS server : Once downloaded, upload the report to your SCCM's SSRS server for easy access.
3. Modify the Data Source: You’ll need to configure the data source so that the report pulls data from the correct SCCM server.
4. Run the Report: After configuring the data source, run the report. The report will require two parameters:
   • Old Computer: The device you are migrating from.
   • New Computer: The device you are migrating to.
5. Simply enter the names of the old and new computers, and the report will generate a detailed comparison.
6. The report excludes anything that contains the following display name. Feel free to edit the report and update your exclusions.

'KB'
'.NET Framework'
'Proof'
'Components'
'Tools'
'Microsoft Visual C++'
'Office 16 Click-to-Run'
'Citrix Browser Content Redirection'
'Citrix Diagnostics Facility'
'Citrix Director VDA Plugin'
'Citrix Web Helper'
'Citrix WMI Proxy Plugin'
'Citrix WorkSpace Browser'
'Citrix Start Menu Disconnect Button'
'Citrix Group Policy Client-Side Extension 7.24.4000.0'
'Citrix Workspace Inside'
'Microsoft Edge Update'
'Microsoft Help Viewer 2.3'
'Microsoft Search in Bing'
'Microsoft Silverlight'
'Microsoft Edge Update'
'Citrix Identity Assertion VDA Plugin'
'Citrix Monitor Service VDA Plugin'
'Citrix Workspace(USB)'
'Redistributable'

Output:

This SCCM report is an useful tool for IT teams involved in hardware migrations. It simplifies the process of comparing installed applications across devices, making sure that the user’s new PC is fully equipped with all the necessary applications. By automating the comparison process, the report reduces the risk of errors, streamlines migration workflows, and ensures a smoother transition for end-users.

Hope you find this useful!