[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

Find software location in System Center 2012 Configuration Manager

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.
  • 4
1 Solution
Nagendra Pratap SinghCommented:
You can click on 5. which report are you looking at?
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

mobankerAuthor Commented:

The software counts are not links.  I have posted a image with this response as to where I am looking.
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

mobankerAuthor Commented:

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.
mobankerAuthor Commented:
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.
mobankerAuthor Commented:
It gives the easiest answer.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now