If you have System Center Configuration Manager then this task becomes easy.
- First copy the following text to (on the SCCM server)C:\Program Files (x86)\Microsoft Configuration Manager\inboxes\clifiles.src\hinv\sms_def.mof
(end of the file is a good place)
- If you do not have a deadline for submitting the inventory you can let SCCM run the hardware inventory on its on schedule, but if it is urgent that you get this done as soon as possible then you can force a hardware inventory.
- Still I suggest you run this overnight and the next day create a query with the following attributes.
Or use the following in Query Language
- Now you can export the list, open it in excel and make a presentable report by using pivot table.