Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

This article provides information on Livestatus queries.

Status
colourGreentitleLAST TESTED ON CHECKMK 2.0.0P1Blue
titleApplicable to all Checkmk versions


Panel
borderColorblack
bgColor#f8f8f8
titleTable of Contents

Table of Contents

Livestatus queries over network

...

Code Block
languagebash
themeRDark
OMD[mysite]~# ssh -t root@host ''su -site' "lq 'GET hosts\nColumns: name'"


For TLS connectionconnection 

Code Block
languagebash
themeRDark
OMD[mysite]~# echo -e "GET hosts\nColumns: name\n"| openssl s_client -connect localhost:6999"ipaddress:port number" -ign_eof -quiet 


Note

Replace "ipaddress:port number" with a valid IP address and port number 

e.g., 10.0.0.10:6999

.

For TLS connection with certificate verification

Code Block
languagebash
themeRDark
OMD[mysite]~# echo -e "GET hosts\nColumns: name\n\n" | openssl s_client  -CAfile /tmp/s1.pem -verify 3 -quiet -verify_hostname s1 -verify_return_error -connect localhost:6560"ipaddress:port number" 2>/dev/null


Note

...

Replace /tmp/s1.pem with the site name and s1 with the name of the site

.

For Plain text

Code Block
themeRDark
OMD[mysite]~# echo -e  "GET hosts\nColumns: name\n" | nc -q1 127.0.0.1 6999  "ip address" "port number"

OMD[mysite]~# telnet 127.0.0.1 6999 "ip address" "port number"

Filter by label (Content by label)
showLabelsfalse
max5
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "lql" , "lql_queries" , "livestatus" , "troubleshooting" ) and type = "page" and space = "KB"
labelslivestatus lql lql_queries

...