Avatar of IT_Support Private
IT_Support Private
 asked on

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

PowershellDellHardwareDesktops* asset inventory

Avatar of undefined
Last Comment
Kostas Kostas

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kostas Kostas

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes