GNMIS

GNMIS

What?

GNMIS is a user interface to RRD collections.


Where?

Campus:
http://stats.net.wisc.edu/cgi-bin/gnmis.fcgi

UW System Network:
https://stats.uwsys.net/cgi-bin/gnmis.fcgi



Basic Searching





Verbose Searching

gnmis2


  Using the Search Boxes

  • By default, search terms will be executed as either MYSQL 'LIKE' matches or REGEXP; automatically determined.  Search online for how to use mysql search syntax.  There are other modes of search available.
    • You can negate a search by starting your parameter with '!'
    • You can specify an exact match like, use '=$MATCH' [example, '=this string'
    • You can specify a direct mysql call like so '==IS NULL'

Creating lists

  • After executing a search, you can add [or remove] RRDs from a list.  The list names are global, so exercise caution.
  • You can delete a list by removing all entries from the list
  • You can copy a list by selecting all and adding to a new list
  • Use the 'Lists:' drop down to restrict the gnmis database and search terms to a predefined RRD list.


Things to know

  • Hub mode is configurable and sets default search options per installation
  • Unless 'show old data' is checked, rrd files that have not been updated for a day are hidden
  • Stat Files means that all files will be stat'd to verify last update time; otherwise, the last time the database was updated will be used.  The database is updated hourly via CRON.
  • Unlimited rows: results are limited to 500 matches by default
  • RRD List; instead of returning a table, return a list of RRDs; useful as an API call
  • RRD Number; instead of returning a table, return the number of matching RRDs; useful as an API call
  • Based on configuration, some columns, such as subnet or IP searching, use different types of searches.
  • If the built in search tools are insufficient and you have access to the gnmis machine, you can also create custom graph links by either using dynamic GNMIS queries

    [m7h@m-csscplat-b380-7 custom_stats]$ pwd
    /usr/local/ns/custom_stats

    [m7h@m-csscplat-b380-7 custom_stats]$ cat test
    #dynamic=http://stats.net.wisc.edu/cgi-bin/gnmis.fcgi?device=r-peer&interface=sp-[0-9]-0-0-0&dataset==bytes&rrd_list_only=1
    #dynamic=http://stats.net.wisc.edu/cgi-bin/gnmis.fcgi?dataset==gMegaFlow-active-as&rrd_list_only=1

    or by specifying RRD filenames directly

    [m7h@m-csscplat-b380-7 custom_stats]$ cat /tmp/genstatspage_tmp/a0a11bc591ceff3f77040763fd8e3391
    #datatype=cpu|bytes&hostname=^fa-csscplat-b380-5-ban-pri7s$&interface=bas|Not
    /var/local/mrtg/ban/fa-csscplat-b380-5-ban-pri7s_bas_bytes.rrd
    /var/local/mrtg/ban/fa-csscplat-b380-5-ban-pri7s_cpu.rrd


    Results



  • Clicking a value in a column other than 'dataset' adds that key/value pairing to the search query
  • Click '+' next to a column header requires that column to be NOT NULL
  • Click '-' next to a column header requires that column to be NULL
  • Clicking the name of a column header changes the sort order.
  • Graph Everything will show a graph for every dataset returned
  • Stack/Plot/Total will combine corresponding datasets.  Not all of these combinations result in useful graphs.  Items can be grouped based on unique combinations discovered by GNMIS.
  • Individual items can be added/removed to lists.


Fun novelty searches

  • interface box: '(g|x)e-[0-9]-[0-9]-[0-9]' = Show all 1 and 10 gig juniper ports


How GNMIS updates itself

  • GNMIS uses cached info out of mysql
  • RRD filenames match one of two patterns; classic mode or dynamic mode
  • Classic mode; '_' is used as a deliminator to populate the 'device', 'interface', 'other_data' and 'dataset' fields.
  • Dynamic mode: '_,_' is used as a deliminator.  key/value pairs are separated by the '=' char
  • Columns and indexes are created as needed during update; there are several configuration options available to assist.
  • Interface description and bandwidth information is gleamed from FIDO.

There should be very few reasons to run gnmis_update by hand.  If you do, try to run as user 'net' and be cognizant of the two below options.  The two below options are 'slow' if you are updating the entire dataset [1,000,000+ files] but 'fast' if you are only updating a small directory or two.

Usage: /usr/local/gnmis/bin/gnmis_update.pl [options] [directories]
Options:
  -u, --update  Update rrdlast time in DB [slow]
  -v, --verify  Verify calculated columns [slow]







Keywords:gnmis rrd search   Doc ID:25536
Owner:Michael H.Group:Network Services
Created:2012-08-08 20:46 CDTUpdated:2015-04-08 10:34 CDT
Sites:Network Services, University of Wisconsin System Network, WiscNet
Feedback:  1   0