I need to log on to 50 UNIX servers via SSH, run a command on the server, grab the output of the command, parse it and load it into QV as a part of the load script. What is the best way to do this? Is there a third party tool designed for this that I can call from the load script?
Create a batch file that logs in on the server and executes a script that runs the command and logs the info you need on that server. Then use a tool like wget or curl to retrieve the files from the servers. If you need the data on regular intervals then schedule the tasks on the servers with cron and only use wget (or similar) to retrieve the files. You could also have the unix servers push the data files to one location so QV can load the files directly from that location.