troubleshooting Question

Script to use for Desktop and Monitor Hardware Asset Inventory

Avatar of IT_Support Private
IT_Support Private asked on
HardwareDesktopsPowershellDell* asset inventory
1 Comment1 Solution165 ViewsLast Modified:
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.

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;
ASKER CERTIFIED SOLUTION
Kostas Kostas
IT Administrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros