Hi,

I am looking for way to find out how many of our computers in our company are using for example:

Windows OS, like 7,8,8.1

Office 2007/2010/2013 suites

Visio/Project suites

Visual Studio

SQL Servers

I would need a query which asks all of the computers in AD do they have a licenses, is it valid (not that important), and most important number of machines using specified products.

Ofcourse query can be only for one product and then I adjust it to my likinings.

Get-ADComputer -filter * | get-wmiobject -class softwarelicensingproduct - i got only this but this is begineers stuf so please help.

Thanks,

Hi Tonito,

you can check for presence of Operating Systems by using the Get-ADComputer with the parameter -Properties OperatingSystem.

You can check for installed applications with this command:

Get-WmiObject Win32_Product

I recommend using a WMI filter for the Product query, especially if you are running it against hundreds of machines.

Cheers,
Fred