Script to use for Desktop and Monitor Hardware Asset Inventory

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

IT_Support PrivateAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kostas KostasIT AdministratorCommented:
Ηι,

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
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.