Other useful Marvis queries

Please see this page for more query examples: https://manage.mist.com/admin/vnadocs.html

Marvis Query Language

troubleshoot client john this week

  • Machine learning driven assessment on what is wrong with client

Troubleshoot site Office this week

  • Machine learning driven assessment on what is wrong with the site.

List clients

  • Show all clients in the organization

List events by dhcp

  • Shows all the DHCP servers at the office.  Easy to find any non-expected ones

List events by dns

  • Shows all the DNS servers at the office.  Easy to find any non-expected ones

List events by gateway

  • Shows all the gateways at use in the office.  Easy to find any non-expected ones

Rank clients by events

  • This is the money query.  This shows the worst performing clients at the site, in one easy query.

List events of type dhcp init failure last week

  • Shows DHCP failures due to non-responsive server.

Mist Query Language (MQL)

This mode has 100s of combinations of questions you can use.

To find the most troublesome clients failing authorization:

RANK Clients BY ClientEventCount WITH EventType Authorization-Failure