Avatar of ndalmolin_13
ndalmolin_13
Flag 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?

Regards,
Nick
Microsoft Applications

Avatar of undefined
Last Comment
matrixnz

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rainer Jeschor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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

Your help has saved me hundreds of hours of internet surfing.
fblack61