Find username with vbscript using server session's for query
Posted on 2009-05-06
In the computer management window of a fileserver, under "shares", you can rightclick on "sessions" and export a list of the current sessions. These include the username and IP/computername that are currently connected along with some other useful data.
I would like to make use of this information without have to go onto the server and check all the time.
The script should first off give an input box where servername is typed.
I would then like the script to make this export command for the sessions on server specified, but export the list to the desktop on the machine from where the script is executed.
When this list is exported it should be in a format so that "text to colums" is performed.
it should as a final stage open this file for review.
If the script is executed a second time, it should overwrite the cvs or xls file with new information so that it only contains current data.
Thanks in advance /Dabosa