Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Looking for a PowerShell query to help satisfy a Microsoft software SAM audit

Posted on 2016-07-29
4
Medium Priority
?
69 Views
Last Modified: 2016-08-30
Hello Experts!

I'm a newer admin at a relatively small (75 computers, 4 physical servers) manufacturing firm, and I'm being 'asked' by Microsoft to work with them on a SAM audit of my MS software.

We didn't have an administrator before me (the controller and owner were handling all things IT), so I'm a bit nervous about finding all the supporting documentation, but I'll cross that bridge when I come to it.

What I'm looking for right now is to see how other admins on a 'tight' IT budget (I don't have much in the way of inventory tools) have done the internal querying to find the installed software on each computer and server.

The admin in me thinks that a request like this screams 'PowerShell!'  Unfortunately, while I can write rudimentary scripts at this point, my PowerShell skill isn't such that I can dump in a list of workstations and output a list of only the Microsoft Products, their versions, and license information.

Has anyone devised a PowerShell script to do such a thing?  If so, would you be willing to share it?

I'm assuming that all SAM audits are the same, but in case they aren't, MS is looking for the version and edition for each of the following products:

Workstation Operating System, Office, Project, Visio, Visual Studio/MSDN, SQL Server Developer, Server Operating System (and CALS), SQL Server (and CALS), SBS (we don't have one), Exchange Server (we don't have one), Sharepoint Server (we use Sharepoint Foundation, which I don't believe is part of the audit), Dynamics CRM (we don't use it), and Remote Desktop (and CALS).

If anyone has such a script 'tucked away', I'd really appreciate your help!

Thanks,

Scott
0
Comment
Question by:Scott Milner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 42

Accepted Solution

by:
Adam Brown earned 2000 total points (awarded by participants)
ID: 41735237
You could utilize WMI queries in powershell (Get-wmiobject) to determine product licenses, but you would probably be better of using the Volume Activation Management Tool (VAMT). It's capable of going through all the systems in your environment to determine activation status, what Microsoft Software is installed, and it will let you install licenses remotely if needed. http://www.terminalworks.com/blog/post/2015/12/13/volume-activation-management-tool-3-1-implementing-and-activating has information on installing version 3.1 of VAMT.
0
 

Author Comment

by:Scott Milner
ID: 41735238
Thanks Adam... I'll take a look at it and get back to you!
0
 
LVL 42

Expert Comment

by:Adam Brown
ID: 41760711
No response, but VAMT is designed for this purpose.
0
 

Author Comment

by:Scott Milner
ID: 41776499
Sorry Adam... I got tied up with things and forgot to get back to you.

I was able to install VAMT and get it configured to poll my network.  It pulled some good information, but ultimately didn't get me everything I needed.  I suspect part of the problem was the fact that so many of our Office installations are done with box-copy products rather than volume licenses, however it may have been user error on my part.  I'm going to continue to work with the tool as I move forward--it may be that I can make it more useful with experience.

Ultimately I ended up using a combination of VAMT, WMI polling, and touching each machine to build my spreadsheet.  It took more time that I wished, but I now have detailed documentation that I can build on.

Thanks for your response, and sorry again for my late feedback.

Scott
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows 10 came with  a lot of built in applications, Some organisations leave them there, some will control them using GPO's. This Article is useful for those who do not want to have any applications in their image (example:me).
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

670 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