Sirbendy Posted September 26, 2013 Posted September 26, 2013 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
sted Posted September 26, 2013 Posted September 26, 2013 how have you grabbed the screen info? other than that http://www.edugeek.net/forums/windows/92976-network-pc-inventory-script.html 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
sted Posted September 26, 2013 Posted September 26, 2013 (edited) bombs out for me on line 64 char 1 (testing on xp) the remote server machine does not exist or is unavaliablel 'getobject' code 800a01ce does same on 7 x64 as well and bombs unless you run as admin because uac dosent let you write to c:\ Edited September 26, 2013 by sted
Sirbendy Posted September 26, 2013 Author Posted September 26, 2013 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® Core 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.
sted Posted September 26, 2013 Posted September 26, 2013 right got it working (and made it easier to use lol) change strComputer = InputBox("Check Monitor info for what PC","PC Name?",strComputer) to strComputer = "." (assuming running locally) and i get back . fps-suite-16 OEGStone awrdacpi 301136-009 Intel® Pentium® D CPU 2.66GHz 2666 Ghz 00:16:76:7F:DC:61 M159A 6429 AMW Nov-05
edutech4schools Posted September 26, 2013 Posted September 26, 2013 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.
sted Posted September 26, 2013 Posted September 26, 2013 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. the links in post 2 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?
edutech4schools Posted September 26, 2013 Posted September 26, 2013 the links in post 2 been a long day...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now