Automated Report Generation

[KylePaynter1]

Hi Community 

I'm trying to determine how to automate a current and working Query that does diagnostic on our RTUs to daily generate and export that list at a particular time everyday.

Thanks for your assistance guys 

[Hardin4019 · Accepted solution]

In the DataBase Tree, right click, then Create New > Other > Schedule. 

Put your Query into a "SQL Export". Setup the Schedule to run Daily, weekly, or Monthly, etc, choose the time. Then drag and drop the SQL Export into the Object portion at the bottom of the Schedule window and choose "Export SQL Query Result" as the method.

[AndrewScott · Accepted solution]

An alternative to an "SQL Export" would be a Crystal Report. This gives you more choices over the generated file format, e.g. Word, Excel, PDF, rather than just CSV.

[Anonymous user]

Thank you very much for taking time and effort to respond.

I will look into this

Tdog

[Anonymous user]

I've marked Hardin4019's post as the solution, feel free to do so yourself if you are happy with an answer in future.

[bigdaz]

Hi Would anyone have an example script of how to do this?

[Hardin4019]

Not much of a need to use a script since most of what you would need to run a report can be accomplished with a schedule. But, I suppose if you wanted to, the biggest thing you would need to know is how declare and call a Method to Execute or Export a SQL Export or a Crystal Report. 

Here is a link that might have helpful info.  https://community.se.com/t5/Geo-SCADA-Knowledge-Base/SMS-Alarm-Redirection/ba-p/278225