Inventory Your network

[witch]

no, I get nothing anywhere so I don't know what is going on

It may not even be running

[FN-GM]

what permissions are set the share and the folder?

 

Is there any spaces in the path?

 

Run the script manually and see if it makes one

[ddrcrook]

Nice tool, is there any way to replace the computer string with a list of computer names?

Regards, Doug

[FN-GM]

Nice tool, is there any way to replace the computer string with a list of computer names?

Regards, Doug

 

I dont understand.

 

You can always open your CSV file then cut and paste the computer name column into a spreadsheet.

[DrPerceptron]

arrComputers = Array("Computer1","Computer2","Computer3")
For Each strComputer In arrComputers

 

Somewhere around the top (line 84?) and then end with a

Next

around line 320 should do it.

 

Connecting to WMI on a Remote Computer (Windows)

 

I may be mistaken but ou could just deploy using group policy as a startup script and you wouldn't have to worry about names, whether the PC is on currently etc.

[ddrcrook]

Ok, I understand the array idea but I have about 150 workstations over 2 sites of a mixed variety that I want to generate an inventory on but do not want to wait until they have all been logged in to use a start-up script. There is also the issue of getting the clients IT department to implement such a change, could take weeks and life is too short for that.

I would like to pass the code the input from say a text list of workstations so that the programme just iterates through the list and that then means I can run it at my convenience.

Regards,

 

Doug

[FN-GM]

There is also the issue of getting the clients IT department to implement such a change, could take weeks and life is too short for that.

 

Really why? As soon as we put ours in group policy it just works

 

All our machines turn on automatically in the morning so took next to no time to do ours.

[mac_shinobi]

Really why? As soon as we put ours in group policy it just works

 

All our machines turn on automatically in the morning so took next to no time to do ours.

 

I was thinking that if you assign the script to relevant OU's then it should just ascertain the info without enumerating machines , right ?

[matte53]

Hi,

 

Thanks for the script, it seems to be just what I need, however I'm having a few teething problems, I've added it as a startup script and it doesn't appear to run. If I run the script manually it works fine, just not when it's set as a startup script. We currently have 2 other scripts running at startup and they are working fine.

 

Any ideas?

 

Matt

[FN-GM]

Hi,

 

Thanks for the script, it seems to be just what I need, however I'm having a few teething problems, I've added it as a startup script and it doesn't appear to run. If I run the script manually it works fine, just not when it's set as a startup script. We currently have 2 other scripts running at startup and they are working fine.

 

Any ideas?

 

Matt

 

What permissions have you set on the folder where the script and the CSV file live? You will need to set it so domain computers can read and write to the folder where the CSV file lives.

[matte53]

That's sorted it, thanks!

[mullet_man]

Cheers, just added this as a startup script, will it run as shutdown script ok?

 

Pretty sure our laptops don't always run startup scripts due not getting an IP address at startup, so running as a shutdown script would work fine.

 

Stevo.

[FN-GM]

Cheers, just added this as a startup script, will it run as shutdown script ok?

 

Pretty sure our laptops don't always run startup scripts due not getting an IP address at startup, so running as a shutdown script would work fine.

 

Stevo.

 

dont know actually, try it

[Killer_Bot]

Thanks for the script FN-GM, is there any way to add the module type to the script? I've ran the script off and it pulls alot of information off but not the one piece I really could do with, i.e. is it DDR, DDR-2 or DDR-3? I have no scripting knowledge and can't seem to find any way to add it myself. Would appreciate any advice you may have

[6Foot2]

Yes, I know and that is what I did - or at least I thought I had, but it didn't work which is why I am asking - given the info I have provided, what would you write in the script?

 

Hi,

 

I think the point you are looking for clarification on is this:

 

filepath = "\\Servername.ChildDomain.ParentDomain.Local\Inventory\inventorylog.csv"

 

If your network does not have a Parent Domain/Child Domain structure you would probably use:

 

filepath = "\\Servername.Local\Inventory\inventorylog.csv"

 

I have shared the 'Inventory' folder at the server and given Domain Computers permissions to the folder.

 

HTH.

[zatch910]

Anyone know how to make it pull the current user?

[jhartpr]

I was just going to ask the same question. I was trying to play with the code but it wasn't working for me to add the username to the script.

[unslog]

Is it possible to add last logged on user or current user to this script? This would greatly help ! : ) thanks

[kennysarmy]

I may be being dumb, but what happens when the script runs and the PC already has an entry in the CSV?

Does it not pull the information or does it overwrite the information or does it append another set of information?

 

Cheers

[FN-GM]

If its already in the CSV it will skip it, it wont change any information.

[zag]

Just found this, Sweet script!

 

I might write a PHP frontend for it to show the data.

 

EDIT: Ok that didn't take long Works well.

 

[ATTACH=CONFIG]20965[/ATTACH]

Edited October 16, 2013 by zag

[zag]

I released it in the Web Development Forums

 

http://www.edugeek.net/forums/web-development/125543-computer-inventory.html

[einjelhart]

This script will take a whole inventory of your machines and put it in a CSV file. Its VBS just add it to a stsrtup script.

 

It will also upload the dell service tag.

 

Coding is attached

Enjoy

 

z

 

Sir,

 

where i'm going to put this on my windows server 2012. in what exact location to putt his for me to run for the inventory purposes?

 

Thank you for the script.

[CamelMan]

I just came across this now - and it works great - thanks to all involved.

@einjelhart I put the script as a start up script as per the instructions in the file , when you click on the browse button within the policy Policies-->Scripts-->Startup-->Properties-->Add-->Browse, you can paste the script into that location, select it and hit open.

[einjelhart]

I just came across this now - and it works great - thanks to all involved.

@einjelhart I put the script as a start up script as per the instructions in the file , when you click on the browse button within the policy Policies-->Scripts-->Startup-->Properties-->Add-->Browse, you can paste the script into that location, select it and hit open.

 

you meant i should paste the script on the startup script, i just seen the other comment to put the script on \\servername\netlogon. is this correct? can you please help. also no need to edit the script right?