Find software location in System Center 2012 Configuration Manager

Posted on 2014-08-19
Last Modified: 2014-08-25
My Configuration Manager 2012 is properly inventorying software.  My question is, when it shows a software count of say "5", how can I find what machines that software is located on?  I would prefer not to go through every device one by one.

Thank you.
Question by:mobanker
    LVL 23

    Expert Comment

    by:Nagendra Pratap Singh
    You can click on 5. which report are you looking at?
    LVL 31

    Expert Comment

    Or do a simple query in SQL Server. Here a example with Skype

    SELECT sys.name0, user_name0, DisplayName0, Version0
    FROM v_Add_Remove_Programs
    inner join v_R_System sys on sys.ResourceID = [v_Add_Remove_Programs].ResourceID 
    WHERE DisplayName0 LIKE '%skype%'
    order by version0

    Open in new window


    Author Comment


    The software counts are not links.  I have posted a image with this response as to where I am looking.

    Author Comment


    Are you doing this query inside of Configuration Manager, or actually inside of SQL?  I see the query builder inside of Configuration Manager, but will need to learn a bit on actual usage of the builder.
    If you are doing this inside of SQL, I can do that, but need to know learn how to hit Configuration Manager database and which table to use.

    Accepted Solution

    I have found the answer!  In the Monitoring tab, there is a query called "All Systems with Specified Software Product Name and Version".    The query returns the information that I am looking for.

    Author Closing Comment

    It gives the easiest answer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    The canonical version of this article is on my web site here: A companion presentation is available here:
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    Viewers will learn the different options available in the Backstage view in Excel 2013.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now