Get a list of Querys and Reports from ePO

[irodrig1]

Hello everybody.

I need to clean up some old querys and reports.

Is there a way to generate a list of the Querys and Reports that are on the ePO?

Thanks in advance.

[cdinet]

From the queries section, choose all for the queries on the left, then select them all, actions, export queries.  You can do the same for reports.  However, that exports the whole query or report and not just the name of it, if that is all you are looking for. 

If you just want the names of the queries or reports, run the following queries in sql 

select name from orionquerymt

select name from orionreportmt 

Verify table names, as depending on your version of epo, they may or may not end in MT.

[irodrig1]

Exelent. Thanks.

Another question, is there a way to get which querys a report uses? Or do I have to look at each report an write them down individualy?

[cdinet]

Exporting the reports would show that, but it might help to write them down too just in case.