• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 87
  • Last Modified:

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

0
IT_Support Private
Asked:
IT_Support Private
1 Solution
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improved Protection from Phishing Attacks

WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now