Client - Scoped, Global

The Client API provides methods to add data to the MetricBase database, to execute transforms on the MetricBase database, and to receive the results of the transforms.

You can use the Client class in both scoped and global server scripts. This class is part of the MetricBase application and must run within the sn_clotho namespace.

Client - Client()

Create an instance of the client class to access the MetricBase database.

Tableau 1. Parameters

Name	Type	Description
None

var client = new sn_clotho.Client();

Client - accumulate(GlideRecord now_GR, String metric)

Accumulates metric values at specified timestamp and saves the result to the database rather than overwriting the value.

Use this method to handle metrics that can be summed for an accumulation, such as kilowatt-hours (kWhs) of electricity. Accumulate makes a call for each metric at the provided timestamp. For example, collected kilowatts for a heater, electric kettle, and washing machine would result in three calls to accumulate.

Tableau 2. Parameters

Name	Type	Description
now_GR	GlideRecord	Name of the series GlideRecord from which to obtain the accumulated value. See also: getSeries()
default_value	Number	Optional. Default value for accumulation at a given timestamp. Used only during the first call to accumulate if a value is unavailable for a given timestamp. A use case could be accumulating a watts metric for a total_power. You want to accumulate watts for a router connected to an outlet without a power meter to measure it. If you know the consumption value and it is constant), you can use the constant value as a default value to accumulate total_power. For example, you would use 20 if the router is constantly plugged in and consumes 20 Watts. The timestamp value can be provided using the DataBuilder API. Default: 0

Tableau 3. Returns

Type	Description
None

The following example shows how to accumulate the total_power metric value in a record called building_a.

var time = new GlideDateTime();

// total_power is the name of a metric within building_a which stores accumulated values

var dataBuilder1 = new sn_clotho.DataBuilder(building_a, "total_power");
// values to be accumulated
dataBuilder1.add(time, 3.5);
new sn_clotho.Client().accumulate(dataBuilder1, 0);

var dataBuilder2 = new sn_clotho.DataBuilder(building_a, "total_power");
// values to be accumulated
dataBuilder2.add(time, 12);
new sn_clotho.Client().accumulate(dataBuilder2, 0);

var dataBuilder3 = new sn_clotho.DataBuilder(building_a, "total_power");
// values to be accumulated
dataBuilder3.add(time, 4.3);
new sn_clotho.Client().accumulate(dataBuilder3, 0);

// As a result, client saves value of 3.5+12+4.3+0(default value) at the timestamp 'time'

Client - deleteMetric(String tableName, String metricName)

Remove a specified metric from a specified table in the MetricBase database

Remarque :

This method deletes data from the MetricBase database. There is no recovery mechanism.

Tableau 4. Parameters

Name	Type	Description
tableName	String	The name of the table whose specified metric is to be deleted.
metricName	String	The name of the metric.

Tableau 5. Returns

Type	Description
None

The following example shows how to remove a metric from a table.

var client = new sn_clotho.Client();

// delete metric (Speed) from the Drones table
client.deleteMetric("mb_demo_drone", "mb_demo_mt_speed");

Client - deleteSeries(GlideRecord now_GR, String metric)

Remove the data in the MetricBase database associated with the specified metric in the specified GlideRecord. Use this method for removing test data.

Remarque :

This method deletes data from the MetricBase database. There is no recovery mechanism.

Tableau 6. Parameters

Name	Type	Description
now_GR	GlideRecord	The records whose time series data for the specified metric is to be deleted.
metric	String	The name of the metric.

Tableau 7. Returns

Type	Description
void

var client = new sn_clotho.Client();
//query drones of a specific model
var drones = new GlideRecord("mb_demo_drone");
drones.addQuery("model", "Kingfisher Phantom");
drones.query();

client.deleteSeries(drones, 'mb_demo_mt_speed');

Client - getSeries(GlideRecord now_GR, String metricName, GlideDateTime lastUpdateBefore)

Get all series from a specific dimension.

Tableau 8. Parameters

Name	Type	Description
now_GR	GlideRecord	The record from which to obtain the series.
metric	String	The name of the metric.
lastUpdateBefore	GlideDateTime	Optional. Date in the future representing the end of the period to be evaluated.

Tableau 9. Returns

Type	Description
Array	List of string sys_ids representing the series containing data for the specified metric. If the lastUpdateBefore parameter is provided, returns series that have no data more recent than the lastUpdateBefore date (non-inclusive).

The following example shows how to get the complete list of speed values listed in the Drones [mb_demo_drone] table.

var client = new sn_clotho.Client();

// query subject records
var grDrone = new GlideRecord('mb_demo_drone');
grDrone.query();

var series = client.getSeries(grDrone,'mb_demo_mt_speed');

Client - put(Object metricData)

Saves metric data to the MetricBase database.

Tableau 10. Parameters

Name	Type	Description
metricData	Object	One of the following: DataBuilder object containing metric data. Array of DataBuilder objects containing metric data.

Tableau 11. Returns

Type	Description
void

var time = new GlideDateTime();
​
// two different GlideRecord instances and metrics
var dataBuilder = new sn_clotho.DataBuilder(now_GR, 'cpu_percentage');
dataBuilder.add(time, 0.6);
​
var dataBuilder2 = new sn_clotho.DataBuilder(gr2, 'disk_free_percentage');
dataBuilder2.add(time, 0.2);
​
new sn_clotho.Client().put([dataBuilder,dataBuilder2]);