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

Queries and Reports

Hi All,

Any recommendations on best practices for running Queries and Reports in ePO? Most common Queries? How to not nest the SQL tables?


6 Replies

Re: Queries and Reports

Moved to ePO for faster response.




Re: Queries and Reports

Thanks Peter

Re: Queries and Reports


The Query and Reporting engine in ePO is vast. Is their anything in particular you want to query.

A starter list might be:

Unmanaged Devices - Boolean Pie Chart

Unprotected Devices - Boolean Pie Chart

Devices not communicated in a given period of time.

Threat events detected



Volunteer Moderator - Business Products

Certified McAfee Product Specialist - ePO

Re: Queries and Reports

Thanks for your input Richard - Dealing with a large database is a little bit hard when it comes to create dashboards. Most customers want to see the results in a short time and the spinning wheels are always make them unhappy. I'm currently working on creating a dashboard that shows how many servers ( Microsoft, Linux, etc ) are at 100% patches and how many that are under a 100%. also if patch is exist or not. Another reports shows the status of the patch for each system. Running both queries are taking a very long time and sometimes it doesn't give any results after waiting.

Thanks again,

Level 9
Report Inappropriate Content
Message 6 of 7

Re: Queries and Reports

One thing I've done (because I was somewhat frustrated with response time) is creating some server tasks to run queries at off hours and export the results to a csv. From there I have an excel workbook with those csv files feeding into pivot tables for easier reporting.

It's not immediately current data, but that isn't important for me in most cases.

Re: Queries and Reports

That's a great idea in regards to the slowness we experience when pulling the data. Thank you!

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

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