Disk usage report in excel format from Nagios

[RIDS_I2MP]

Hi Team,

We want the utilization report of disk usage from Nagios for any particular server in excel sheet format.

kindly let me know if any plugin is available for it.

Thanks in advance.

[lmiltchev]

It is not very clear what info you need to see in this report. What time period would you like to use - last 24 hours, last week, month...?
In any case, this type of report doesn't exist in XI, so you will have to create something custom. It's possible to use a json query and somehow modify the output to fit your needs. I am not sure how difficult would be to convert the json to csv format though. You can access the JSON Query Generator here:

Code: Select all

http://<server ip>/nagios/jsonquery.html

An example query, run from the CLI would be:

Code: Select all

[root@testbox ~]# REQUEST_METHOD="GET" REMOTE_USER="nagiosadmin" QUERY_STRING="query=service&hostname=Windows7&servicedescription=Drive+C%3A+Disk+Usage" /usr/local/nagios/sbin/statusjson.cgi
Cache-Control: no-store
Pragma: no-cache
Last-Modified: Fri, 13 Nov 2015 18:42:10 GMT
Expires: Thu, 01 Jan 1970 00:00:00 GMT
Content-type: application/json; charset=utf-8

{
  "format_version": 0,
  "result": {
    "query_time": 1447440130000,
    "cgi": "statusjson.cgi",
    "user": "nagiosadmin",
    "query": "service",
    "query_status": "released",
    "program_start": 1447426280000,
    "last_data_update": 1447440120000,
    "type_code": 0,
    "type_text": "Success",
    "message": ""
  },
  "data": {
    "service": {
      "host_name": "Windows7",
      "description": "Drive C: Disk Usage",
      "host_name": "Windows7",
      "description": "Drive C: Disk Usage",
      "plugin_output": "C: - total: 452.96 Gb - used: 275.19 Gb (61%) - free 177.77 Gb (39%)",
      "long_plugin_output": "",
      "perf_data": "'C:\\ Used Space'=275.19Gb;362.37;430.31;0.00;452.96",
      "max_attempts": 5,
      "current_attempt": 1,
      "status": 2,
      "last_update": 1447440120000,
      "has_been_checked": true,
      "should_be_scheduled": true,
      "last_check": 1447439906000,
      "check_options": 0,
      "check_type": 0,
      "checks_enabled": true,
      "last_state_change": 1447159749000,
      "last_hard_state_change": 1447159749000,
      "last_hard_state": 0,
      "last_time_ok": 1447439906000,
      "last_time_warning": 1447097736000,
      "last_time_unknown": 0,
      "last_time_critical": 1447159749000,
      "state_type": 1,
      "last_notification": 0,
      "next_notification": 0,
      "next_check": 1447440206000,
      "no_more_notifications": false,
      "notifications_enabled": false,
      "problem_has_been_acknowledged": false,
      "acknowledgement_type": 0,
      "current_notification_number": 0,
      "accept_passive_checks": true,
      "event_handler_enabled": true,
      "flap_detection_enabled": true,
      "is_flapping": false,
      "percent_state_change": 0.00,
      "latency": 0.00,
      "execution_time": 0.01,
      "scheduled_downtime_depth": 0,
      "process_performance_data": true,
      "obsess": true
    }
  }
}

You can read more about JSON CGIs in Nagios Core here:

https://labs.nagios.com/2014/06/19/expl ... #more-1897

This at least can get you started. If this is not going to work for you, you can file a feature request to our public tracker here:

http://tracker.nagios.com/

or contact our sales team at [email protected] and request a quote for a custom development. Hope this helps.