How do I automate saving query result to .csv file in PI SQL Commander Lite?

I have a Product Batch Event Frame configured and running in PI AF. Also, I am able to successfully query for the results in PI SQL Commander Lite, but I need to automatically run the Query in PI SQL Commander Lite and save the result of the queries in .csv format at 11:59:59 PM on daily basis.

Parents

0 Community User over 1 year ago

Hi Kelvino,
PI SQL Commander Lite is an utility provided with PI SQL Family products to test queries and connections. It does not have any scheduling capability or autonomy to run what at when. I'd suggest you to automate the task using a PowerShell script that uses PI SQL Client OLEDB or any of the variant drivers. One can also use a linked server and SQL Agent jobs to schedule a similar repeated tasks. More enterprise-wide approach may include using the PI Integrator for Business Analytics.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kelvino over 1 year ago in reply to Community User

Hi (Missing Content) , thanks a lot for your response. Well understood.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kelvino over 1 year ago in reply to Community User

Hi (Missing Content) , thanks a lot for your response. Well understood.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data