I would limit the query to output only one field and not several :-)
dirk On Wed, 11 Dec 2013 15:00:34 +0100, Lau Daniels wrote: > Dirk, > > It would be great if i could do sql query directly from within a > SA-test and evaluate the response. > For example: > A test with: > "select status, DATABASE_STATUS, active_state from gv$instance where > INSTANCE_NAME='rac-node1';" and then test for the string "active". > Or > select tablespace_name,used_percent from > dba_tablespace_usage_metrics; and evaluate the percentage returned. > > Now I'm running a script every hour but integrated in SA would be > great. Nice proposition ;-) > > Lau > > > -----Original Message----- > From: Servers Alive Discussion List [mailto:[email protected]] On > Behalf Of Dirk Bulinckx > Sent: woensdag 11 december 2013 11:01 > To: Servers Alive Discussion List > Subject: [SA-list] Database check changes > > Currently in SA there are several ways to check a database > * in SA via the SQL checker (using the old DMO libs) > * in SA via the Oracle checker (using the Oracle Windows libs) > * external COM check for SQL (2005/2008) using the current SMO libs > * external COM check for ODBC > * external COM mySQL > > We are thinking about converting this to 1 type of db check that is > based on the "native" client (for Oracle - SQL - Sybase - DB2 - > Interbase - SQLBase - mySQL - SQLite - Postgress or ODBC). This > would > require that you changing your existing db checks (the COM ones would > still work, the internal not) and that instead of "just" checking if > a > database is online (like the current SQL and Oracle check do) we > would > do execute a SQL statement just as we do in the ODBC checker. > The idea is to remove the current MS-SQL and Oracle check from SA and > replace it by the above check, other option would be to leave the old > checks in it and create a new check (internal or as COM check) > > I would like some reactions/feedback on this idea.... > > > > -- > Dirk Bulinckx > Servers Alive - http://www.woodstone.nu > DNS Hosting on StellarDNS - http://www.stellardns.com > > To unsubscribe send a message with UNSUBSCRIBE in the subject line to > [email protected] If you use auto-responders (like > out-of-the-office > messages), make sure that they are not sent to the list nor to > individual members. Doing so will cause you to be automatically > removed from the list. > > > ************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please > notify > the sender. > Any views or opinions presented in this email are solely those of the > author and do not necessarily represent those of the company. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses but we cannot accept > responsibility for any loss or damage arising from the use of this > email and/or attachment(s). > > To unsubscribe send a message with UNSUBSCRIBE in the subject line to > [email protected] > If you use auto-responders (like out-of-the-office messages), make > sure that they are not sent to the list nor to individual members. > Doing so will cause you to be automatically removed from the list. -- Dirk Bulinckx Servers Alive - http://www.woodstone.nu DNS Hosting on StellarDNS - http://www.stellardns.com To unsubscribe send a message with UNSUBSCRIBE in the subject line to [email protected] If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.
