Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To extract data from a particular table in your environment, follow the steps below:

Log into the managed system and execute the /n/bnwvs/main transaction.

Table reader filter needs to be maintained in the Administrator->Metric filters->Table reader filter

...

Please define filter name (should be unique) and table on the header level:

...

New functionality was included in the PowerConnect 7.0 release to include the possibility to specify date and timestamps from the desired table for extraction in the “Date range Field Name”, the Time range Field Name”, and the “Time Stamp range Field Name”. If you specify the timestamp fields from the dataset, the PowerConnect application will extract delta records based on the timestamp. Example below for the EDIDS table, where the CREDAT and CRETIM timestamps are input to extract delta records based on the time.

In release 8.03, a new field/column, 'Time Zone', has been added to specify the time zone for the 'Date Range Field Name'. If set to UTC, it will function the same way as the UTC format field. Note that the UTC format field will be removed in future versions, and the 'Time Zone' field with a value of 'UTC' will replace it. If this field is left blank, it indicates that the Date Range Field uses the system's default time zone.

...

It is also possible to define more specific select conditions and list of field fields to be selected for each table using corresponding option on the left panel.

...

Select conditions “Options” field accepted values:

Operator

Description

EQ

Equal: True, if the content of operand1 matches the content of operand2.

NE

Not Equal: True, if the content of operand1 does not match the content of operand2.

LT

Lower Than: True, if the content of operand1 is smaller than the content of operand2.

GT

Greater Than: True, if the content of operand1 is greater than the content of operand2.

LE

Lower Equal: True, if the content of operand1 is lower than or equal to the content of operand2.

GE

Greater Equal: True, if the content of operand1 is greater than or equal to the content of operand2.

CP

Match a pattern

NP

Patter not matching

BT

Between

NB

Not between

If the aim is to extract delta data, appropriate where conditions should be added in the query itself. For these purposes following placeholders are foreseen:

Placeholder

Description

$now

extractor current execution time in system time zone

$today

extractor current execution date in system time zone

$yesterday

extractor day before execution date in system time zone

$timestamp

extractor current timestamp in UTC

$timestamp_st

extractor current timestamp in system time zone

$lastrun

extractor last execution timestamp in UTC

$lastrun_st

extractor last execution timestamp in system time zone

$lastrundate

extractor last execution date (system time zone)

$lastruntime

extractor last execution time (system time zone)

Field values to get sample:

...