cancel
Showing results for 
Search instead for 
Did you mean: 

Get a list of Querys and Reports from ePO

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.

Labels (1)
Tags (1)
3 Replies
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: Get a list of Querys and Reports from ePO

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.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Highlighted

Re: Get a list of Querys and Reports from ePO

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?

McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: Get a list of Querys and Reports from ePO

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

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

More McAfee Tools to Help You

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community