Looking for a PowerShell query to help satisfy a Microsoft software SAM audit
Posted on 2016-07-29
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!