API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 8th, 2020
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.61 KB | None | 0 0
raw download clone embed print report
  1. /usr/sbin/mariadbd, Version: 10.5.8-MariaDB-log (MariaDB Server). started with:
  2. Tcp port: 0 Unix socket: (null)
  3. Time Id Command Argument
  4. # Time: 201208 12:35:38
  5. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  6. # Thread_id: 1670 Schema: librenms QC_hit: No
  7. # Query_time: 1.372032 Lock_time: 0.000054 Rows_sent: 1 Rows_examined: 347702
  8. # Rows_affected: 0 Bytes_sent: 96
  9. use librenms;
  10. SET timestamp=1607452538;
  11. SELECT COUNT(DISTINCT D.sysname, R.name) FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2;
  12.  
  13.  
  14. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  15. # Thread_id: 1671 Schema: librenms QC_hit: No
  16. # Query_time: 1.502697 Lock_time: 0.000036 Rows_sent: 1 Rows_examined: 347702
  17. # Rows_affected: 0 Bytes_sent: 96
  18. SET timestamp=1607452538;
  19. SELECT COUNT(DISTINCT D.sysname, R.name) FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2;
  20. # Time: 201208 12:35:39
  21.  
  22.  
  23. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  24. # Thread_id: 1422 Schema: librenms QC_hit: No
  25. # Query_time: 10.732554 Lock_time: 0.000019 Rows_sent: 50 Rows_examined: 973066
  26. # Rows_affected: 0 Bytes_sent: 28595
  27. SET timestamp=1607452539;
  28. SELECT R.severity, D.device_id,name AS alert,rule_id, state,time_logged,DATE_FORMAT(time_logged, '%Y-%m-%d %H:%i:%s') as humandate,details FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 ORDER BY time_logged DESC LIMIT 0,50;
  29.  
  30.  
  31. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  32. # Thread_id: 1423 Schema: librenms QC_hit: No
  33. # Query_time: 10.869310 Lock_time: 0.000022 Rows_sent: 50 Rows_examined: 973066
  34. # Rows_affected: 0 Bytes_sent: 28595
  35. SET timestamp=1607452539;
  36. SELECT R.severity, D.device_id,name AS alert,rule_id, state,time_logged,DATE_FORMAT(time_logged, '%Y-%m-%d %H:%i:%s') as humandate,details FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 ORDER BY time_logged DESC LIMIT 0,50;
  37. # Time: 201208 12:35:40
  38.  
  39.  
  40. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  41. # Thread_id: 1671 Schema: librenms QC_hit: No
  42. # Query_time: 1.589250 Lock_time: 0.000031 Rows_sent: 50 Rows_examined: 350450
  43. # Rows_affected: 0 Bytes_sent: 2513
  44. SET timestamp=1607452540;
  45. SELECT COUNT(*), D.device_id, R.name FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2 GROUP BY D.device_id, R.name ORDER BY COUNT(*) DESC LIMIT 0,50;
  46. # Time: 201208 12:36:34
  47.  
  48.  
  49. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  50. # Thread_id: 2741 Schema: librenms QC_hit: No
  51. # Query_time: 4.480392 Lock_time: 0.000021 Rows_sent: 50 Rows_examined: 973081
  52. # Rows_affected: 0 Bytes_sent: 29313
  53. SET timestamp=1607452594;
  54. SELECT R.severity, D.device_id,name AS alert,rule_id, state,time_logged,DATE_FORMAT(time_logged, '%Y-%m-%d %H:%i:%s') as humandate,details FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 ORDER BY time_logged DESC LIMIT 0,50;
  55.  
  56.  
  57. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  58. # Thread_id: 2742 Schema: librenms QC_hit: No
  59. # Query_time: 4.561109 Lock_time: 0.000019 Rows_sent: 50 Rows_examined: 973081
  60. # Rows_affected: 0 Bytes_sent: 29313
  61. SET timestamp=1607452594;
  62. SELECT R.severity, D.device_id,name AS alert,rule_id, state,time_logged,DATE_FORMAT(time_logged, '%Y-%m-%d %H:%i:%s') as humandate,details FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 ORDER BY time_logged DESC LIMIT 0,50;
  63. # Time: 201208 12:36:39
  64.  
  65.  
  66. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  67. # Thread_id: 2918 Schema: librenms QC_hit: No
  68. # Query_time: 1.201351 Lock_time: 0.000052 Rows_sent: 1 Rows_examined: 347707
  69. # Rows_affected: 0 Bytes_sent: 96
  70. SET timestamp=1607452599;
  71. SELECT COUNT(DISTINCT D.sysname, R.name) FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2;
  72.  
  73.  
  74. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  75. # Thread_id: 2917 Schema: librenms QC_hit: No
  76. # Query_time: 1.303842 Lock_time: 0.000032 Rows_sent: 1 Rows_examined: 347707
  77. # Rows_affected: 0 Bytes_sent: 96
  78. SET timestamp=1607452599;
  79. SELECT COUNT(DISTINCT D.sysname, R.name) FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2;
  80. # Time: 201208 12:36:40
  81.  
  82.  
  83. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  84. # Thread_id: 2917 Schema: librenms QC_hit: No
  85. # Query_time: 1.292119 Lock_time: 0.000028 Rows_sent: 50 Rows_examined: 350453
  86. # Rows_affected: 0 Bytes_sent: 2513
  87. SET timestamp=1607452600;
  88. SELECT COUNT(*), D.device_id, R.name FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2 GROUP BY D.device_id, R.name ORDER BY COUNT(*) DESC LIMIT 0,50;
  89.  
  90.  
  91. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  92. # Thread_id: 2918 Schema: librenms QC_hit: No
  93. # Query_time: 1.529899 Lock_time: 0.000041 Rows_sent: 50 Rows_examined: 350453
  94. # Rows_affected: 0 Bytes_sent: 2513
  95. SET timestamp=1607452600;
  96. SELECT COUNT(*), D.device_id, R.name FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2 GROUP BY D.device_id, R.name ORDER BY COUNT(*) DESC LIMIT 0,50;
  97. # Time: 201208 12:37:35
  98.  
  99.  
  100. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  101. # Thread_id: 3793 Schema: librenms QC_hit: No
  102. # Query_time: 4.813961 Lock_time: 0.000029 Rows_sent: 50 Rows_examined: 973090
  103. # Rows_affected: 0 Bytes_sent: 27738
  104. SET timestamp=1607452655;
  105. SELECT R.severity, D.device_id,name AS alert,rule_id, state,time_logged,DATE_FORMAT(time_logged, '%Y-%m-%d %H:%i:%s') as humandate,details FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 ORDER BY time_logged DESC LIMIT 0,50;
  106.  
  107.  
  108. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  109. # Thread_id: 3792 Schema: librenms QC_hit: No
  110. # Query_time: 4.837699 Lock_time: 0.000035 Rows_sent: 50 Rows_examined: 973090
  111. # Rows_affected: 0 Bytes_sent: 27738
  112. SET timestamp=1607452655;
  113. SELECT R.severity, D.device_id,name AS alert,rule_id, state,time_logged,DATE_FORMAT(time_logged, '%Y-%m-%d %H:%i:%s') as humandate,details FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 ORDER BY time_logged DESC LIMIT 0,50;
  114. # Time: 201208 12:37:40
  115.  
  116.  
  117. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  118. # Thread_id: 3936 Schema: librenms QC_hit: No
  119. # Query_time: 1.484519 Lock_time: 0.000033 Rows_sent: 1 Rows_examined: 347698
  120. # Rows_affected: 0 Bytes_sent: 96
  121. SET timestamp=1607452660;
  122. SELECT COUNT(DISTINCT D.sysname, R.name) FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2;
  123.  
  124.  
  125. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  126. # Thread_id: 3934 Schema: librenms QC_hit: No
  127. # Query_time: 1.690046 Lock_time: 0.000055 Rows_sent: 1 Rows_examined: 347698
  128. # Rows_affected: 0 Bytes_sent: 96
  129. SET timestamp=1607452660;
  130. SELECT COUNT(DISTINCT D.sysname, R.name) FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2;
  131. # Time: 201208 12:37:41
  132.  
  133.  
  134. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  135. # Thread_id: 3936 Schema: librenms QC_hit: No
  136. # Query_time: 1.009650 Lock_time: 0.000029 Rows_sent: 50 Rows_examined: 350443
  137. # Rows_affected: 0 Bytes_sent: 2513
  138. SET timestamp=1607452661;
  139. SELECT COUNT(*), D.device_id, R.name FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2 GROUP BY D.device_id, R.name ORDER BY COUNT(*) DESC LIMIT 0,50;
  140.  
  141.  
  142. # User@Host: librenms[librenms] @ [HIDDEN_IP_ADDRESS]
  143. # Thread_id: 3934 Schema: librenms QC_hit: No
  144. # Query_time: 1.080006 Lock_time: 0.000028 Rows_sent: 50 Rows_examined: 350443
  145. # Rows_affected: 0 Bytes_sent: 2513
  146. SET timestamp=1607452661;
  147. SELECT COUNT(*), D.device_id, R.name FROM `alert_log` AS E LEFT JOIN devices AS D ON E.device_id=D.device_id RIGHT JOIN alert_rules AS R ON E.rule_id=R.id WHERE 1 AND `E`.`state` = 1 AND E.`time_logged` > DATE_SUB(NOW(),INTERVAL '7' DAY) AND `R`.`severity` >= 2 GROUP BY D.device_id, R.name ORDER BY COUNT(*) DESC LIMIT 0,50;
  148.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!