Dashboard Toolbox - Improving Dashboard Performance through Query Formatting

Document created by DMFezzaReed Employee on Jul 13, 2018Last modified by DMFezzaReed Employee on Jul 17, 2018
Version 4Show Document
  • View in full screen mode

Welcome to Dashboard Toolbox - Improving Dashboard Performance through Query Formatting

 

 Here we will begin to collaboratively and constructively collect a list of query format choices that will help to improve the performance of your dashboard(s).  As new recommendations arise, they will be added to this page and to the scope of the technical publications when the dashboards move to GA.

dashboard_toolbox  dashboard_howto  vmdb_beta

 

Recommended Query Formatting for Performance

 

RecommendationInstead of this...Try this...
Try to reduce the use of range query, where possiblevulnerabilities.vulnerability.severity:[3..5]vulnerabilities.vulnerability.severity:[3,4,5]
Try to reduce, or eliminate, the use of the NOT within the querynot vulnerability.typeDetected:Informationvulnerability.typeDetected:[Confirmed,Potential]
Query for Operating System using the Asset token vs. the Vulnerability Token

vulnerabilities.hostOS:

operatingSystem:

 

Please feel free to comment, ask questions, and make suggestions for content below.  DMFezzaReed will review and acknowledge both a minimum of once each week.

 

Back to Dashboarding and Reporting 

Attachments

    Outcomes