Did you ever needed to analyze the installed software in your business? For those who experimented it, you know that it’s not an easy task. In SCCM, one of the way to achieve this goal is by using Add Remove Programs but you’ll have to deal with a minimum of customization.
The problem is that software companies don’t work in the same direction and not even standardize their own product, Adobe and Microsoft included.
You can experiment issues where publisher or product names are different on the same product. You can even have the same executable file version for two different product. This explains why you see discrepancies with SCCM inventories mechanism.
- Hardware Inventory (Add Remove Program, Installed Software)
- Software Inventory (File Inventory)
- Software Metering
Because these names are not always standardized in the file header information, when you view software inventory information in Resource Explorer or run queries, different versions of the same manufacturer or product name can sometimes appear. If you want to standardize these display names….
There’s an option for software inventory in client settings where you can configure display names for manufacturer or product that help you standardize some discrepancies.
Click on Administration / Client Settings / Software Inventory and Set Names to list the inventoried names.
The problem is that it affects only software inventory which doesn’t included Add Remove Programs.
There’s no solution if you want to modify the value of data reported in Add Remove Programs. Creating software reports in SCCM become difficult if you constantly need to deal with exclusions to create data quality.
As an example, querying Visio gives this result :[pastacode lang=”sql” message=”” highlight=”” provider=”manual” manual=”SELECT%20DISTINCT%20ProductName0%20AS%20’ProductName%20from%20v_GS_Installed_Software’%0AFROM%20v_GS_INSTALLED_SOFTWARE%0AWHERE%20ProductName0%20LIKE%20’%25%20Visio%20%25’%20AND%20ProductName0%20NOT%20LIKE%20’%25%20MUI%20%25’%20AND%20ProductName0%20NOT%20LIKE%20’%25Language%20Pack%25’%20AND%20ProductName0%20NOT%20LIKE%20’%25Viewer%25’%20AND%20ProductName0%20NOT%20LIKE%20’%25Services%20Web%25’%20AND%20ProductName0%20NOT%20LIKE%20’%25Compatibili%25’%20AND%20ProductName0%20NOT%20LIKE%20’%25Modeler%25’%20AND%20ProductName0%20NOT%20LIKE%20’%25SDK%25’%0AORDER%20BY%201″/]
- What is the difference between Microsoft Office Visio and Microsoft Visio?
- Why Microsoft Visio Standard 2013 is there twice?
This explains why there’s company like Flexera or Provance that help the community to have best results in your Asset Management inventory. What are the possible solutions if an enterprise does not want to invest in third party applications?
A good starting point would be to use Asset Intelligence in SCCM. You have the ability to manipulate and standardize each software details by using a total of 5 custom labels. It’s enough to create something really clean and organized.
In a next blog post, we will show you how to use those 5 custom labels in SCCM 2012 Asset Intelligence so you can customize your own structure.
Asset Intelligence Blog Series
- Part 1 | Why should you use Asset Intelligence in SCCM 2012
- Part 2 | How to maximize the use of Asset Intelligence with Labels
- Part 3 | Create Custom Reports with Labels of Asset Intelligence
- Part 4 | Merging Last Usage of Software Metering with Custom Labels of Asset Intelligence
- Part 5 | Automatically Uninstall Unused Applications based on Software Metering with SCCM
sccm 2012 asset intelligence
Founder of System Center Dudes. Nick has been awarded in 2016 as a Microsoft MVP in Enterprise Mobility category.
Working as a senior SCCM and Intune advisor as well as a specialist Microsoft Cloud solutions specialist.