Saving 'Scripts Executed' and 'Executed Against'

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Saving 'Scripts Executed' and 'Executed Against'

Postby ivopld » Fri Sep 18, 2009 2:35 pm

This is a great app, really simplyfies things.. but it would be very helpful if you could save the information displayed under the 'Scripts Executed' and 'Exectued Against' fields.

The 'Save Results' features
SQL Multi Script does not automatically save results if you exit the application. To save your results, click Save, located above the Messages tab in the Results window. You can save your results as a .csv or .txt file that can then be opened and used in other applications.

doesn't really help as it doesn't specify exactly what script was run on what database and when.

Is there are some type of patch that can be dowloaded, which would allow for this data to be saved in a similar way the 'Messages' are saved?
ivopld
 
Posts: 3
Joined: Fri Sep 18, 2009 2:29 pm

Postby Colin Millerchip » Tue Sep 22, 2009 2:53 pm

Hi ivopld,

Thanks for the post. Could you provide a bit more details regarding what you're trying to do, and why you'd want to save this information, please? Is it as a way of recording changes, eg, for audit needs?

Thanks,


Colin.
Colin Millerchip
 
Posts: 66
Joined: Wed Oct 31, 2007 5:31 pm
Location: Cambridge, UK

Postby ivopld » Wed Sep 23, 2009 4:34 pm

Hi Colin,

In a way it is for "audit" purposes.. it would be helpful for our organization to track issues related to 'missing scripts' or scripts that haven't been run on particular databases.

So a way to log the execution history of scripts on databases, would be very helpful.
ivopld
 
Posts: 3
Joined: Fri Sep 18, 2009 2:29 pm

Postby ivopld » Wed Sep 23, 2009 4:38 pm

Or, if there's a button to export the contents of the 'Scripts Executed' and 'Exectued Against' fields into some type of external file.. that would also be very useful.
ivopld
 
Posts: 3
Joined: Fri Sep 18, 2009 2:29 pm

Postby Colin Millerchip » Wed Sep 23, 2009 5:43 pm

Hi ivopld,

Thanks for the further information. It isn't something that SQL Multi Script does at the moment, but I'll add this as a request for consideration for a future release.

Best regards,


Colin.
Colin Millerchip
 
Posts: 66
Joined: Wed Oct 31, 2007 5:31 pm
Location: Cambridge, UK


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests