Link to home
Start Free TrialLog in
Avatar of ndalmolin_13
ndalmolin_13Flag for United States of America

asked on

Finding all Microsoft products in our organization

Hello All,

I have been tasked with trying to find all of the Microsoft products in our organization so that we may "true up" our licensing.

We have SCCM 2007.  I logged into the configuration manager for the first time today.  Is it possible to use this tool to find this information?  If so, can someone help me with setting this query/report up?

Avatar of Rainer Jeschor
Rainer Jeschor
Flag of Germany image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of matrixnz

You can use the built in reports, or queries

For a report you can use: "Computers with a specific software registered in Add Remove Programs", you will need to run it for each software product that you want to true-up.  I generally would export this data into Excel and than remove any systems you don't want to include in the True-up.  This includes, proof of concept/testing systems, systems that have been decommissioned etc... This will give you your final count.

While you can get a basic count it's not really the best way as it means that you may be paying for licenses that are no longer required.

You can also do the same within a Query, I generally would setup a Query Folder named "Microsoft", I than created a query for each of my products, note you can include all products in one query but generally find that using one product for each of the queries allows me to export each individually.

A sample query for example for Microsoft Project (see below) again I would export this to Excel to refine the list.

Hope that helps

select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft%Project%Standard%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft%Project%Professional%"

Open in new window