I am using check_mysql_query plugin in nagios to query database and get output. query is working fine but output which i am getting contain query. I want to remove query from output and give custom message which will be simple and understandable.
Can you help me here with any bash script or wrapper to use around to avoid query in output.
below is my query output.
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Hi all,
I have a bit of an issue, I am working on a bit of a CMDB for a friend, it's to do with real estate.
Anyway, this is my situation.
I have a table which contains all the properties (forsale, sold, etc) in the DB named "property".
Now, this is what I want to achieve, I wish to... (5 Replies)
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (0 Replies)
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (11 Replies)
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
LEARN ABOUT SUNOS
wsreg_query_set_location
wsreg_query_set_location(3WSREG) Product Install Registry Library Functions wsreg_query_set_location(3WSREG)NAME
wsreg_query_set_location, wsreg_query_get_location - set or get the location of a query
SYNOPSIS
cc [flag ...] file ...-lwsreg [library ...]
#include <wsreg.h>
int wsreg_query_set_location(Wsreg_query *query, const char *location);
char *wsreg_query_get_location(Wsreg_query *query);
DESCRIPTION
The wsreg_query_set_location() function sets the location specified by location in the query specified by query. If a location has already
been set in the specified query, the resources associated with the previously set location are released.
The wsreg_query_get_location() function gets the location string from the query specified by query.
RETURN VALUES
The wsreg_query_set_location() function returns a non-zero value if the location was set correctly; otherwise 0 is returned.
The wsreg_query_get_location() function returns the location from the specified query structure. The resulting location string is not a
copy, so it must not be released by the caller.
USAGE
The query identifies fields used to search for a specific component in the product install registry. By specifying the install location,
the component search is narrowed to all components in the product install registry that are installed in the same location.
Other fields can be specified in the same query to further narrow the search.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|MT-Level |Unsafe |
+-----------------------------+-----------------------------+
SEE ALSO wsreg_get(3WSREG), wsreg_initialize(3WSREG), wsreg_query_create(3WSREG), attributes(5)SunOS 5.10 22 Sep 2000 wsreg_query_set_location(3WSREG)