Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84248members
353348posts

Automated Report Generation

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
KylePaynter1
Ensign
Ensign
0 Likes
6
2273

Automated Report Generation

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 

Tags (1)

Accepted Solutions
Hardin4019
Lieutenant
Lieutenant
0 Likes
5
2265

Re: Automated Report Generation

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.

See Answer In Context

AndrewScott
Commander
Commander
0 Likes
0
2263

Re: Automated Report Generation

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.


Andrew Scott, Lead Engineer, AVEVA

See Answer In Context

6 Replies 6
Hardin4019
Lieutenant
Lieutenant
0 Likes
5
2266

Re: Automated Report Generation

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
Commander
Commander
0 Likes
0
2264

Re: Automated Report Generation

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.


Andrew Scott, Lead Engineer, AVEVA
Tdog
Crewman
Crewman
0 Likes
1
2218

Re: Automated Report Generation

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

 

I will look into this

 

Tdog

JChamberlain
Schneider Alumni (Retired)
Schneider Alumni (Retired)
0 Likes
0
2201

Re: Automated Report Generation

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
Ensign
Ensign
0 Likes
1
2000

Re: Automated Report Generation

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

Hardin4019
Lieutenant
Lieutenant
0 Likes
0
1975

Re: Automated Report Generation

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://tprojects.schneider-electric.com/telemetry/display/public/CS/Reporting