Installed Software Inventory Count without being broken up by version information SCCM

Denning, James 0 Reputation points
2025-01-23T17:59:40.9466667+00:00

Installed Software Inventory Count without being broken up by version information SCCM

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,988 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Garth 806 Reputation points
    2025-01-23T18:26:31.55+00:00

    You can clone the report and adjust the SQL query to not display "version" and this will bring merge the counts to the display name.

    Remember that CMPivot is more about real-time data.

    if you are looking for a book to help you with creating queries for ConfigMgr you can try. It will also show you about how to create reports too. https://www.informit.com/store/system-center-configuration-manager-reporting-unleashed-9780134466811

    0 comments No comments

  2. AllenLiu-MSFT 47,706 Reputation points Microsoft Vendor
    2025-01-24T06:26:45.04+00:00

    Hi, @Denning, James

    Thank you for posting in Microsoft Q&A forum.

    Like garth mentioned, you may use CMPivot to get the results:

    InstalledSoftware | where ProductName == 'xxxxx' |count
    

    User's image


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.