cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

User console reports - local storage location

Is there a possibility in the Data Platform to display the query of a created report?

At best, are the user reports stored locally?

(1) Solution

@Thomas7 

You can request the Publish database schema through Flexera Support if you want to run SQL queries directly against it. You can obviously also use SQL Profiler to trace SQL queries and as such try to reverse engineer the queries executed when running reports...

You can export/import reports from command line, please refer to https://docs.flexera.com/dataplatform/UserConsoleGuide/Content/Command_Line.htm 

Thanks,

View solution in original post

(1) Reply

@Thomas7 

You can request the Publish database schema through Flexera Support if you want to run SQL queries directly against it. You can obviously also use SQL Profiler to trace SQL queries and as such try to reverse engineer the queries executed when running reports...

You can export/import reports from command line, please refer to https://docs.flexera.com/dataplatform/UserConsoleGuide/Content/Command_Line.htm 

Thanks,