There are several types of properties in dbWatch.

  • Predefined properties are always present. For example, instances have properties called name and host.
  • Metadata properties are are manually assigned to particular objects in dbWatch (like instances or tasks).
  • Dynamic properties are properties that are dynamically defined for objects of a particular type.

Dynamic properties

Dynamic properties are defined in xml files located in the [dbWatch Server]/server/resources/properties/ catalog.

You cannot add files to this catalogue manually, but import them by placing them in the [dbWatch Server]/server/resources/import_area catalog.

Examples of property definitions:

<property>
  <key>version</key>	
  <compatability>instance[databasetype='oracle']</compatability>
  <value engine="sql">select VERSION from v$instance</value>
  <valid-for>24h</valid-for>
</property>	
<property>
  <key>active_session_count</key>
  <compatability>instance[databasetype='oracle']</compatability>
  <value engine="sql">select count(*) from v$session where status = 'ACTIVE' and username is not null</value>
  <valid-for>5m</valid-for>
</property>

The fields are:

  • key : The name that identifies this property (used in dbwql queries).
  • compatability : DBWQL query that defines the database instances that this property is compatible with.
  • value : An query that defines the property value.
  • valid-for : How long this property can be cached. Format xh/xm/xs, examples “24h”, “15m”, “60s”. (hours/minutes/seconds cannot be combined, so “1m 30s” is not allowed and must be written as “90s”).

The value tag has an engine tag that specifies the type of the contained code. Legal values are currently: sql, dbwql, ssh, javascript.
There can be several value tags, they form a sequence of steps that are executed when resolving the property.

Accessing properties

All properties can be queried using DBWQL, for example:

← Groups Configuration / SQL Worksheet →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment