Script to use for Desktop and Monitor Hardware Asset Inventory

IT_Support Private
IT_Support Private used Ask the Experts™
on
Hi All,
I am in need of a Script (VB or preferably Powershell) to use for Desktop and Monitor Hardware Asset Inventory for approx. 120 workstations (Primarily DELL Desktops and Monitors though some TV's are connected and some have zero monitors connected. If amount of RAM (GB) could be added to the list, that would also be handy, but not essential.

Criteria:
I require the input to be via a TXT file list of Hostnames using get-content which I will run from a desktop machine while logged in as Administrator.
Not all machines will be turned on and not all devices will be connected so I need the script to skip to next device if issues connecting to one of them in the list.
I will be using WMI to obtain the details I think, unless anything better. Details are not available via AD I don't believe.
A previous example that I have tested parts of did seem to work, so possibly could use parts out of this script at: PreviousPostLink              

Output Requirements:
I require the Output to be either txt or csv file.
The Output is required to be in the below format and records:
[u][i]1st Line[/i][/u] > PC1 Hostname, PC1 Model, PC1 Serial Number, PC1 OS, Last/Most recent Logged in User, Monitor 1 Model, Monitor 1 Serial Number, Monitor 1 Date of Manufacture
[u][i]2nd Line[/i][/u] > PC1 Hostname, PC1 Model, PC1 Serial Number, PC1 OS, Last/Most recent Logged in User, Monitor 2 Model, Monitor 2 Serial Number, Monitor 2 Date of Manufacture
[u][i]3rd Line[/i][/u] > PC2 Hostname, PC2 Model, PC2 Serial Number, PC2 OS, Last/Most recent Logged in User, Monitor 1 Model, Monitor 1 Serial Number, Monitor 1 Date of Manufacture
and so on... Basically A New Line Per PC and Per Monitor.

Open in new window


Example:
SYDA####1, OptiPlex 750, SN:3334433992XAU, Win7 64bit, Bob user, U2400, SN:4433992200XAU, DOM: 09-2015;
SYDA####1, OptiPlex 750, SN:3334433992XAU, Win7 64bit, Bob user, U2400, SN:4433993300XAU, DOM: 08-2015;
SYDA####2, OptiPlex 740, SN:3335533662XAU, Win10 64bit, Amy user, U2400, SN:4432291200XAU, DOM: 04-2015;

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Administrator
Commented:
Ηι,

Go here https://www.experts-exchange.com/gigs/ and click create project

I will try for weekend but i can't quarantine that i will finish

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial