Hello there people.
Everyone's ok? Hope so!
I got a very specific need and I've been doing some research with -until now- not much of a sucess, also I hope the answer help future colleagues.
The environment I'm working with contain more than a hundred servers, so doing it manually would be kinda of insane, we have Server 2008 R2 and 2012, also 2012 R2 servers, Physical and Virtual.
I need a hardware inventory from every server, but, the problem is that we're not needing usual Get-WMIObject inventory details (not as long as I've checked), we need to obtain the following, from (first) one server, picture this:
1 - Server name (easy, I can obtain this through basic Powershell)
2 - Motherboard name / model
3 - Server model (this makes possible to understand if that's physical or virtual, imho).
4 - Motherboard's total network card "compatible" slots (PCI, PCI-E and details like PCI-E x1 / x16, etc), used and available.
5 - Motherboard's Network installed cards.
The most detailed as possible, ex:
"From this obtained NIC: How many ports are used"
"From this obtained NIC: Is there any network free port on the NIC? How many ports?"
"From this obtained NIC: Which network it's connected to", etc)"
This is the kind of information we need to obtain, also, the script will (on its final implementation I guess) be capable of querying each server, one by one, then extract these informations and provide a excel file, I will export the results to a CSV and
use good old import from CSV to Excel, but that's the last and not least, right? I'm also doing a research about VBscript.
Any guidance will be appreciated.
Hoping to hear from you guys, best regards.


