Ok, I finally put together a vbscript which collects the serial number from Windows servers using WMI and it is working.
Now I am trying to find what table or view in the database shows that information.
Any help would be appreciated......
I want to pull the available logical drives connected to a particular server. I need this information for more than 400 windows 2003 servers which are connected in the same domain.
The O/p should be in the bwlow mentioned format.
Server Name, Server IP Address, Disks Connected
Can some one help me to write a script for it? If anybody knows an sql query to execute it against the WMI pls let me now the query.
This can easily be done using Perl and WMI scripting as I am doing something similar. However I have not linked that data back into Orion. It is currently just going into a CSV file so it can be linked to Excel or Access.
I am in the process right now of modifying my scripts to grab the IP address. As soon as I can get that I will see what I can do for your request.
Thank you. Please let me know once it's done.
Are you willing to share the vbscript and/or SQL script that you used to accomplish this by uploading it to the Content Exchange?
To whom this question is directed?
If it's to me I won't mind posting the script here.
Either of you because my search under APM for anything that pulls a serial number resulted in no hits.
I am going to throw my had into this ring as well and say that would be quite usefull! I need to pull both that serial number and service pack through WMI. Could go the external scrip/spread sheet thing. Thanks, Cam
What sql table did you find the message data the script returned?
Message from windows/linux script result can be found in [APM_PortEvidence] view [ErrorMessage] column.
I just posted the APM template here - .
