'; Configuring Monitored Parameters for a Database | Incognito Help 
Array
(
    [0] => Array
        (
            [version] => 4.3
            [language] => en
        )

)
Rel: acs/tutorials/acs/dita/configuring_parameters_for_database
URI: acs/tutorials/configuring_parameters_for_database
=== Tags ===
Array
(
    [1006] => configuring monitored parameters
)

=== Related ===
Array
(
)
  1. Auto Configuration Server
  2. Tutorials

Configuring Monitored Parameters for a Database

The service can write parameters (defined within a service class) to an SQL database for trend analysis over time or to the messaging bus for real-time monitoring.

This tutorial describes how to configure monitored parameters to write to a database. Supported databases are: MySQL, PostgreSQL, or Oracle.

Prerequisite

Complete the tutorial Provisioning Devices 1: Basic Setup.

Enable Parameter Monitoring Using ACS CLI

Log into the ACS CLI and set values for the following parameters.

Parameters

$ acscli -c MONITORED_PARAMETER_ENABLED=true
$ acscli -c MONITORED_PARAMETER_WRITE_TO_DB=true
$ acscli -c MONITORED_PARAMETER_WRITE_TO_MESSAGE_BUS=false
$ acscli -c MONITORED_PARAMETER_DATABASE_VENDOR=<database-type>
$ acscli -c MONITORED_PARAMETER_DATA_SOURCE=<username>/<password>@<ip-address>:<port>/<database-name>

Where:

<database-type> is one of: MySQL, PostgreSQL, or Oracle

<database-name> is the name of the database used to store the monitored parameters

Note: For information about using the CLI, refer to the ACS CLI reference.
Back to top

Create a Device Group for Monitoring

Create a device group and add the devices on which you want to monitor parameters to it.

  1. From the ACS Hub, go to Device Groups.

  2. In the action bar, click Create.
  3. Type a name for the device group. From the Type dropdown, choose “Device”. Optionally, type a description.

  4. In the action bar, click Save.

    A screen with the device group details appears.

  5. Click Add Devices, and in the action bar, click Add.

    The Associated Devices screen appears.

  6. In the action bar, click Add.

    The Associated Devices screen appears.

  7. Select the devices on which you want to monitor parameters, and in the action bar, click Add.
  8. In the action bar, click Confirm to save the device group.
Back to top

Create a Service Class with Monitored Parameters

Create a service class that includes monitored parameters.

  1. From the ACS Hub, go to Service Classes.

  2. In the action bar, click Create.
  3. Type a name for the service class. Optionally, type a description and a unique priority number.
    Note: If you do not specify a priority, a default (unique) priority is automatically assigned to the service class.
  4. In the action bar, click Save.

    A screen with the service class details appears.

  5. Click Add Monitored Parameters.

    The Associated Monitored Parameters screen appears.
  6. In the action bar, click Add.
    The Select Parameters screen appears.
  7. Select monitored parameters for the service class.

    To filter attributes in the list, click the search symbol (), type part or all of an parameter string in the query field, and press Enter.

  8. In the action bar, click Add.

    The Associated Parameters screen appears and displays the parameters you added.

  9. For each parameter, type the value specified for this tutorial. (Leave the notification and access list at the defaults).

    To enter parameter values, first choose “Not Set” from the Value dropdown, then erase “Not Set” and type a value.

  10. In the action bar, click Confirm to save the monitored parameter settings.
  11. Click Add Device Groups.

    The Associated Device Groups screen appears.
  12. In the action bar, click Add.

    The Add Device Groups screen appears.

  13. Select the device group created earlier in this tutorial, and in the action bar, click Add.
  14. In the action bar, click Confirm to save the device group settings.
  15. From the Schedule type dropdown, choose a monitoring schedule. The choices are: Immediate, Next Contact, or Window.

    If you choose Window, you also need to set a date, start time, and end time for the window, and optionally, enable ACS to contact the device.
  16. In the action bar, click Confirm to save the service class.
On every periodic inform from the device, the parameters are fetched and values are written to the database.
Back to top
Version
Top