Scripts Thread, Probably very badly done, but it works - PC and monitor audit script. in Coding and Web Development; I've managed to hack together a script (VBS) that prompts for a PC name, and then dumps to excel a ...
26th September 2013, 11:25 AM #1
Probably very badly done, but it works - PC and monitor audit script.
I've managed to hack together a script (VBS) that prompts for a PC name, and then dumps to excel a list of the tech info (Name, MAC, CPU, Speed, RAM, TFT Serial Number and make) for that machine. I've used others scripts to do it, but couldn't find one that combined the monitor AND PC data.
I'm no programmer - the script runs fine, and does what I need it to do - it's allowed me to audit this building in 30 minutes. However, the code may make people wince!
I've attached it to this post - hope someone finds it useful - I know I do!
audit - working.vbs
26th September 2013, 12:08 PM #2
how have you grabbed the screen info? other than that network pc inventory script is what i use to do inventory (ive slightly altered it since then but just cosmetically changed it so make model is now make-model for mdt reasons but thats just a single character change
26th September 2013, 12:18 PM #3
bombs out for me on line 64 char 1 (testing on xp)
the remote server machine does not exist or is unavaliablel 'getobject'
does same on 7 x64 as well and bombs unless you run as admin because uac dosent let you write to c:\
Last edited by sted; 26th September 2013 at 12:24 PM.
26th September 2013, 12:20 PM #4
Screen info script section uses the EDID VESA values - thus far, it seems accurate. In the case of our dells, it takes out some sections of the serial, but they're easy to add when we need to. More than enough accurate data is grabbed to enable us to inventory the screen though. Here's a sample:
VTC-XXX-X Dell Inc. precision t1650 XXX0YX1 Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz 3401 Ghz 90:B1:1C:A2:2E:A9 DELL P2212H V0VCM33A269U DEL Mar-13 - last 4 fields are the TFT info.
re: XP - ah. Doesn't surprise me. As I say, I'm no programmer - I just hacked it all together so that it runs nicely on our Win7 system here.
26th September 2013, 12:33 PM #5
right got it working (and made it easier to use lol)
strComputer = InputBox("Check Monitor info for what PC","PC Name?",strComputer)
strComputer = "."
(assuming running locally) and i get back
. fps-suite-16 OEGStone awrdacpi 301136-009 Intel(R) Pentium(R) D CPU 2.66GHz 2666 Ghz 00:16:76:7FC:61 M159A 6429 AMW Nov-05
26th September 2013, 12:45 PM #6
I think @sted created a script that uses AD to gather the same sort of info when anyone logs in on the domain it adds the info to the computer account in AD and also had an option to create a spreadsheet.
If I can find the forum I will add a link as it works very well.
26th September 2013, 12:55 PM #7
the links in post 2
Originally Posted by edutech4schools
im just looking seeing if i can easily add monitor info but it does seem to be incomplete last 4 digits of serial number are all it seems to get wondering if theres another way?
26th September 2013, 12:59 PM #8
been a long day...
Last Post: 9th February 2012, 03:43 PM
By darrenmcginnis in forum Windows
Last Post: 15th September 2011, 02:25 PM
By BackCat3 in forum Windows Server 2008 R2
Last Post: 22nd May 2011, 05:38 PM
By speckytecky in forum Internet Related/Filtering/Firewall
Last Post: 12th October 2010, 03:35 PM
By indiegirl in forum Windows
Last Post: 2nd February 2006, 10:49 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)