Ad Widget

Collapse

Pulling Raw Data From Zabbix Database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mushero
    Senior Member
    • May 2010
    • 101

    #16
    Interesting and we'll look at testing that, though we change the metric all the time, and normally need to pull lots of different values - seems here we are limited to the few inventory fields, but still interesting (I assume we can change the mapping and update all the fields).

    But even if all are pulled into the inventory, how do I get a report on that field, especially for a group or with a LIKE, with sorts, etc. ? Seems SQL or some API call ?

    We just have a full reporting engine connected to Zabbix (we use Scriptcase which is great for this) to pull all this, dozens of queries, reports, etc. that would take 10X the work to use the API.

    Note we pull a lot more than this as we have custom GUIs, rule-based processing and ticketing engines, prediction engines on things like disk space, and more, too. Most of these are single host, which is more API friendly, though we've heard the API is slow, so we'll see.

    We also have lots of custom SQL update tools, such as proxy migration tools that auto move hundreds of machines in various countries to new proxies due to routing and delays - a few lines of SQL does this easily; probably possible in the API (though without SQL hard to retain the home proxy; I guess we could store it in a profile field, though we use those for many things).

    Comment

    • steveboyson
      Senior Member
      • Jul 2013
      • 582

      #17
      That's exactly the way we did it before except that we filtered on key_ or name of item.
      But now as there is no more "lastvalue" in the history_* tables we need to use previously mentioned procedure.

      Comment

      • mushero
        Senior Member
        • May 2010
        • 101

        #18
        Originally posted by steveboyson
        That's exactly the way we did it before except that we filtered on key_ or name of item.
        But now as there is no more "lastvalue" in the history_* tables we need to use previously mentioned procedure.
        https://www.zabbix.com/forum/showpos...74&postcount=4
        Yes but note my post above where we solved this easily by trigger to re-create those fields like the old systems for far easier data extraction with simple SQL. Super easy to then use for latest data across several data types and avoiding sorted queries on giant history tables.

        Comment

        • bulgare
          Junior Member
          • Feb 2020
          • 6

          #19
          Hi Guys
          Sorry for the nubie question, if it is.
          Our task requiring zabbix raw data is to compute the availability coefficient of the radio link for which radio (a link consists of two radios) we have the following snmp data collected by zabbix:
          icmploss
          uptime
          rssi

          Idea was to divide the 2 radios in each link into the "root" radio and "dependent" radio and compare icmploss for each pair within minimal uptime for both. Where there will be a difference between icmploss for each in a pair there is a good chance that the radio link was down, we need to summarize these "downtime" periods and compare them to uptime.
          We have several hundreds of such links.
          Is it possible to do this task within Zabbix?

          Comment

          • merle1379
            Junior Member
            • Mar 2020
            • 3

            #20
            Originally posted by bulgare
            Hi Guys
            Sorry for the nubie question, if it is.
            Our task requiring zabbix raw data is to compute the availability coefficient of the radio link for which radio (a link consists of two radios) we have the following snmp data collected by zabbix:
            icmploss
            uptime
            rssi

            Idea was to divide the 2 radios in each link into the "root" radio and "dependent" radio and compare icmploss for each pair within minimal uptime for both. Where there will be a difference between icmploss for each in a pair there is a good chance that the radio link was down, we need to summarize these "downtime" periods and compare them to uptime.
            We have several hundreds of such links.
            Is it possible to do this task within Zabbix?
            Sir we can do it on mail or google sheet if you are intrested then share one or two links here . after that we can decide what to do in future.
            will wait for your respoince

            thank you

            Comment

            Working...