Nagios Support Forum

Posted: **Fri Mar 24, 2017 3:02 pm**

Hi ,

I am using the json query generator to export some nagios data to an external reporting system. Inserted is the output from a query, I am just wondering how to translate the state field? its not in the 0,1,2,3 or 4 that I was expecting. I'm assuming object_type of 2 is for service and state_type of 1 is for hard

{
"format_version": 0,
"result": {
"query_time": 1490384843000,
"cgi": "archivejson.cgi",
"user": "nagiosadmin",
"query": "statechangelist",
"query_status": "released",
"program_start": 1490375704000,
"last_data_update": 1488783193000,
"type_code": 0,
"type_text": "Success",
"message": ""
},
"data": {
"selectors": {
"starttime": 1488672000000,
"endtime": 1488758400000,
"hostname": "Service Availability",
"servicedescription": "ITSM",
"statetypes": 1
},
"statechangelist": [
{
"timestamp": 1488672000000,
"object_type": 2,
"host_name": "Service Availability",
"description": "ITSM",
"state_type": 1,
"state": 8,
"plugin_output": "Initial Service Pseudo-State"
},
{
"timestamp": 1488697200000,
"object_type": 2,
"host_name": "Service Availability",
"description": "ITSM",
"state_type": 1,
"state": 8,
"plugin_output": "OK - 2 plugins checked, 2 ok"
},
{
"timestamp": 1488740269000,
"object_type": 2,
"host_name": "Service Availability",
"description": "ITSM",
"state_type": 1,
"state": 32,
"plugin_output": "CRITICAL - 2 plugins checked, 1 critical (login_www_itsmprd_Service_Availability_-_itsm_selenium_login), 1 ok"
},
{
"timestamp": 1488740564000,
"object_type": 2,
"host_name": "Service Availability",
"description": "ITSM",
"state_type": 1,
"state": 8,
"plugin_output": "OK - 2 plugins checked, 2 ok"
}
]
}
}

Posted: **Fri Mar 24, 2017 3:08 pm**

You're asking about Core stuff on an XI forum

But I was perusing and thought I'd share:

In the core source, in include/archiveutils.h, you have the following:

Code: Select all

#define AU_STATE_NO_DATA			0
#define AU_STATE_HOST_UP			(1<<0)
#define AU_STATE_HOST_DOWN			(1<<1)
#define AU_STATE_HOST_UNREACHABLE	(1<<2)
#define AU_STATE_SERVICE_OK			(1<<3)
#define AU_STATE_SERVICE_WARNING	(1<<4)
#define AU_STATE_SERVICE_CRITICAL	(1<<5)
#define AU_STATE_SERVICE_UNKNOWN	(1<<6)

Where here, 8 would be service ok (1<<3).

Following all those bit shift operations: host up is 1, host down is 2, host unreachable is 4, service ok is 8, service warning is 16, service critical is 32, service unknown is 64.

The 0,1,2,3 you're expecting would likely be better coming from the XI API.

Hope this helps.

Posted: **Fri Mar 24, 2017 3:11 pm**

excellent thankyou for your help.

I will know for next time to post in core.

Posted: **Fri Mar 24, 2017 3:15 pm**

Hi Paul, were there any further questions or are we okay closing this thread?

Posted: **Fri Mar 24, 2017 3:19 pm**

That answered it thanks, yes please close

Nagios Support Forum

question about about output from jsonquery.html

question about about output from jsonquery.html

Re: question about about output from jsonquery.html

Re: question about about output from jsonquery.html

Re: question about about output from jsonquery.html

Re: question about about output from jsonquery.html