Collector for Number Ranges

The technical name of the Collector for Number Ranges is /DVD/MON_CL_COL_NUM_RANGE.

This collector runs once per day and monitors changes in number ranges across clients. You can set up custom thresholds for change reporting to measure the difference (how many IDs were assigned from the number range) and speed (the estimated number of IDs assigned per day).

NOTE If you do not define content for the input table /DVD/MON_NR, all number ranges are monitored by default, and thresholds (especially percentage thresholds) are pulled from the table TNRO – Number Range Object Info. Some number range records available in the table TNRO might have reversed thresholds. For example, the value 99.9% means that the collector will report this particular number range record in the detail table as soon as 0.01% of the numbers are used. As a result, the number range can exceed the percentage threshold and be reported in CrystalBridge® Monitoring, even in the case that 100% of it is free.

Default KPIs Delivered with This Collector

The following default KPIs are delivered with this collector:

KPI name	Description	Unit	Detail table
NR_OVER_THR	Number of number ranges that are over the threshold	Count	Yes
NR_MAX_DIFF	Maximum incremental difference of all number ranges	Count	Yes
NR_TOTAL_DIFF	Sum of all incremental differences of number ranges	Count	Yes
NR_MAX_SPEED	Maximum incremental speed* of number ranges	Value/day	Yes
NR_TOTAL_SPEED	Sum of all speeds of monitored number ranges	Value/day	Yes

*Speed: This value represents how many IDs are assigned to each number range per day. The collector is supposed to run once per day by default. However, if you manually stop the collector and start it one hour later, during which time a number range assigned 5 IDs, the collector will assume that this value applies to 24 hours and provide a result of 120 IDs. Therefore, this metric is an estimation.

Input Table

The collector uses the input table /DVD/MON_NR, where you can specify what details will be extracted into the detail table /DVD/MON_S_NR_INFO.

NOTE Wildcards are supported for the detail table /DVD/MON_NR. In addition, input table thresholds override thresholds from collector parameters.

OBJECT	Name of the number range object
SUBOBJECT	Number range object subobject
NRRANGENR	Number range number
TOYEAR	To fiscal year
SPEED_THR	Speed threshold
DIFF_THR	Difference threshold
PERC_THR	Percentage threshold

Parameters

The following parameters are used for this collector:

Parameter name	Description
DIFFERENCE_THRESHOLD	Only number ranges that assign more IDs than this value will be monitored and reported to CrystalBridge® Monitoring and the detail table.
SPEED_THRESHOLD	Only number ranges that assign IDs per day faster than this value will be monitored.
PERCENTAGE_THRESHOLD	Number ranges that reach the percentage threshold will also be reported. For example, if a number range has a range of 1–100, is currently on 95, and you set the threshold to 10%, the number range will be reported.

Detail Table

The collector provides the detail table Number range info. The technical name of the detail table is /DVD/MON_S_NR_INFO.

The detail table Number range info reports all number ranges that have changed since the last run of the collector. It contains the following fields:

Technical name	Description
TIMESTAMP	Time when the records are saved to the detail table
SID	System ID
CLIENT	Client ID
OBJECT	Name of the number range object
SUBOBJECT	Number range object subobject
NRRANGENR	Number range number
TOYEAR	To fiscal year
EXTERNID	Internal <empty> or external X number range flag
NRLEVEL	Number range status
NRLEVEL_DIFF	Last number range level difference
NRLEVEL_SPEED	Incremental speed of the number range
NRLEVEL_PERC	Percentage threshold for this number range
REASON	Which threshold the number range reached. Possible values: DIFFERENCE SPEED PERCENTAGE
BUFFER_TYPE	Buffer type: X = main memory; L = local memory; etc.
BUFFER_SIZE	Buffer size: Amount of numbers that are held in the buffer