The most recent content from our members.
Anything available in SWQL that would approximate the REPLACE function in SQL? It's a long story, but this is the query I'm working with in SQL - basically a volume can fill up, but as long as all the same "opt<x>" volumes on a server don't fill up, it doesn't need to alert. The SQL works in a query and report, but I want…
Hi In UPD transformations we can use some table functions (ColumnAverage, ColumnMinimum, ColumnMaximum, ColumnSum). In my understanding these functions should return a single (scalar) value, but they return also a table. Docu says: Provides an average of the column values in a polled table Also see UDP with Tabular Results…
Hi all, As you know NPM have a syslog receiver engine which have better EPS than Kiwi Syslog so sometime we prefer to use NPM for syslog management. All features are cool but onlty rules section is weaker for NPM. only string matching or regex options are available but If you want to exclude something It is really hard to…
DESCRIPTION This script is a function named sql_text that is used within a couple other custom reports. Install this into the Oracle repository and the reports that need it can use it. SQL*PLUS SCRIPT CREATE OR REPLACE FUNCTION sql_text ( p_dbid IN NUMBER, p_hash_value IN NUMBER) RETURN VARCHAR2 AS sSQL VARCHAR2(500); TYPE…
I am attempting to construct a report that pulls all servers performing a certain function. This information is contained in a custom server description field. When I select the report filter and attempt to: Select records where [any] of the following apply: Records where [custom_property] contains [word defining function]…
It looks like you're new here. Sign in or register to get started.