path: root/templates/cloud/azure_http/template_cloud_azure_http.yaml

zabbix_export:
  version: '6.4'
  date: '2022-11-08T08:52:11Z'
  template_groups:
    -
      uuid: c2c162144c2d4c5491c8801193af4945
      name: Templates/Cloud
  host_groups:
    -
      uuid: 748ad4d098d447d492bb935c907f652f
      name: Databases
    -
      uuid: 137f19e6e2dc4219b33553b812627bc2
      name: 'Virtual machines'
  templates:
    -
      uuid: fa58228fee8a4e34a7c6503950d1c615
      template: 'Azure by HTTP'
      name: 'Azure by HTTP'
      description: |
        This template is designed to monitor Microsoft Azure by HTTP.
        It works without any external scripts and uses the script item.
        Currently the template supports discovery of virtual machines (VMs), MySQL and PosgtreSQL servers.
        
        Setup:
          1. Create an Azure service principal via the Azure command-line interface (Azure CLI) for your subscription.
            `az ad sp create-for-rbac --name zabbix --role reader --scope /subscriptions/<subscription_id>`
            See https://docs.microsoft.com/en-us/cli/azure/create-an-azure-service-principal-azure-cli for more details.
          2. Link the template to a host.
          3. Configure macros {$AZURE.APP_ID}, {$AZURE.PASSWORD}, {$AZURE.TENANT_ID}, and {$AZURE.SUBSCRIPTION_ID}.
        
        You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/
        
        Template tooling version used: 0.42
      groups:
        -
          name: Templates/Cloud
      items:
        -
          uuid: 7b2fe9a7ee164718933eb456b0068fea
          name: 'Azure: Get errors'
          type: DEPENDENT
          key: azure.get.errors
          delay: '0'
          history: 7d
          trends: '0'
          value_type: TEXT
          description: 'A list of errors from API requests.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.errors
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.get.resources
          tags:
            -
              tag: component
              value: raw
          triggers:
            -
              uuid: 502cb582546046a29267715763c46bff
              expression: 'length(last(/Azure by HTTP/azure.get.errors))>0'
              name: 'Azure: There are errors in requests to API'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Zabbix has received errors in response to API requests.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: fb6abf3631b240b08357ea9ce9ba89a4
          name: 'Azure: Get resources'
          type: SCRIPT
          key: azure.get.resources
          delay: 10m
          history: 0d
          trends: '0'
          value_type: TEXT
          params: |
            var Azure = {
                params: {},
                token: null,
            
                setParams: function (params) {
                    ['app_id', 'password', 'tenant_id', 'subscription_id'].forEach(function (field) {
                        if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
                            throw 'Required param is not set: ' + field + '.';
                        }
                    });
            
                    Azure.params = params;
                },
            
                request: function (url, data) {
                    if (typeof data === 'undefined' || data === null) {
                        data = '';
                    }
            
                    var response, request = new HttpRequest();
                    if (Azure.token) {
                        request.addHeader('Accept: application/json');
                        request.addHeader('Authorization: Bearer ' + Azure.token);
                    }
            
                    Zabbix.log(4, '[ Azure ] Sending request: ' + url);
            
                    if (data !== '') {
                        request.addHeader('Content-Type: application/x-www-form-urlencoded');
                        response = request.post(url, data);
                    }
                    else {
                        response = request.get(url);
                    }
            
                    Zabbix.log(4, '[ Azure ] Received response with status code ' + request.getStatus() + ': ' + response);
            
                    if (request.getStatus() !== 200 || response === null) {
                        throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
                    }
            
                    try {
                        return JSON.parse(response);
                    }
                    catch (error) {
                        throw 'Failed to parse response received from API.';
                    }
                }
            };
            
            var result,
                data = {},
                types = [
                    {"method": "Microsoft.Compute/virtualMachines", "version": "2022-03-01"}, 
                    {"method": "Microsoft.DBforMySQL/flexibleServers", "version": "2021-05-01"}, 
                    {"method": "Microsoft.DBforMySQL/servers", "version": "2017-12-01"},
                    {"method": "Microsoft.DBforPostgreSQL/flexibleServers", "version": "2021-06-01"},
                    {"method": "Microsoft.DBforPostgreSQL/servers", "version": "2017-12-01"}
                ];
                data['errors'] = {},
                data['resources'] = {};
                data.resources.value = [];
            
            try {
                Azure.setParams(JSON.parse(value));
            
                try {
                    result = Azure.request(
                            'https://login.microsoftonline.com/' + encodeURIComponent(Azure.params.tenant_id) +'/oauth2/token',
                            'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(Azure.params.app_id) + '&client_secret=' + encodeURIComponent(Azure.params.password)
                    );
            
                    if ('access_token' in result) {
                        Azure.token = result['access_token'];
                    } else {
                        throw 'Auth response does not contain access token.';
                    }
                }
                catch (error) {
                    data.errors.auth = error.toString();
                }
            
                if (!('auth' in data.errors)) {
                    try {
                        for (var i in types) {
                            raw_data = Azure.request('https://management.azure.com/subscriptions/' + encodeURIComponent(Azure.params.subscription_id) + '/providers/' + types[i].method + '?api-version=' + types[i].version);
                        
                            if ('nextLink' in raw_data) {
                                next_data = raw_data;
                                while ('nextLink' in next_data) {
                                    next_data = Azure.request(next_data.nextLink);
                                    next_data.value.forEach(function (value) {
                                        raw_data.value.push(value);
                                    });
                                }
                            }
                        
                            raw_data.value.forEach(function (value) {
                                value.resourceGroup = value.id.split("/")[4];
                                data.resources.value.push(value);
                            });
                        }
                    }
                    catch (error) {
                        data.errors.resources = error.toString();
                    }
                }
            }
            catch (error) {
                data.errors.params = error.toString();
            }
            
            if (Object.keys(data.errors).length !== 0) {
                errors = 'Failed to receive data:';
                for (var error in data.errors) {
                    errors += '\n' + error + ' : ' + data.errors[error];
                }
                data.errors = errors;
            }
            else {
                data.errors = '';
            }
            
            return JSON.stringify(data);
          description: 'The result of API requests is expressed in the JSON.'
          timeout: '{$AZURE.DATA.TIMEOUT}'
          parameters:
            -
              name: app_id
              value: '{$AZURE.APP_ID}'
            -
              name: password
              value: '{$AZURE.PASSWORD}'
            -
              name: tenant_id
              value: '{$AZURE.TENANT_ID}'
            -
              name: subscription_id
              value: '{$AZURE.SUBSCRIPTION_ID}'
          tags:
            -
              tag: component
              value: raw
      discovery_rules:
        -
          uuid: 7fafbef68f8b46d083eb43da7cd1e2cc
          name: 'MySQL servers discovery'
          type: DEPENDENT
          key: azure.mysql.servers.discovery
          delay: '0'
          filter:
            evaltype: AND
            conditions:
              -
                macro: '{#TYPE}'
                value: ^Microsoft.DBforMySQL
                formulaid: G
              -
                macro: '{#NAME}'
                value: '{$AZURE.MYSQL.DB.NAME.MATCHES}'
                formulaid: E
              -
                macro: '{#NAME}'
                value: '{$AZURE.MYSQL.DB.NAME.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: F
              -
                macro: '{#LOCATION}'
                value: '{$AZURE.MYSQL.DB.LOCATION.MATCHES}'
                formulaid: C
              -
                macro: '{#LOCATION}'
                value: '{$AZURE.MYSQL.DB.LOCATION.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: D
              -
                macro: '{#GROUP}'
                value: '{$AZURE.RESOURCE_GROUP.MATCHES}'
                formulaid: B
              -
                macro: '{#GROUP}'
                value: '{$AZURE.RESOURCE_GROUP.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: A
          description: 'The list of the MySQL servers is provided by the subscription.'
          host_prototypes:
            -
              uuid: 55b87078c14c4561b53e64af5ed77d61
              host: 'Azure MySQL server {#NAME}'
              name: 'Azure MySQL server {#NAME}'
              group_links:
                -
                  group:
                    name: Databases
              macros:
                -
                  macro: '{$AZURE.RESOURCE_ID}'
                  value: '{#ID}'
              tags:
                -
                  tag: location
                  value: '{#LOCATION}'
                -
                  tag: resource-group
                  value: '{#GROUP}'
                -
                  tag: size
                  value: '{#SIZE}'
                -
                  tag: version
                  value: '{#VERSION}'
          master_item:
            key: azure.get.resources
          lld_macro_paths:
            -
              lld_macro: '{#GROUP}'
              path: $.resourceGroup
            -
              lld_macro: '{#ID}'
              path: $.id
            -
              lld_macro: '{#LOCATION}'
              path: $.location
            -
              lld_macro: '{#NAME}'
              path: $.name
            -
              lld_macro: '{#SIZE}'
              path: $.sku.name
            -
              lld_macro: '{#TYPE}'
              path: $.type
            -
              lld_macro: '{#VERSION}'
              path: $.properties.version
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.resources.value
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          overrides:
            -
              name: 'Flexible server'
              step: '1'
              filter:
                conditions:
                  -
                    macro: '{#TYPE}'
                    value: Microsoft.DBforMySQL/flexibleServers
                    formulaid: A
              operations:
                -
                  operationobject: HOST_PROTOTYPE
                  operator: REGEXP
                  templates:
                    -
                      name: 'Azure MySQL flexible server by HTTP'
            -
              name: 'Single server'
              step: '2'
              filter:
                conditions:
                  -
                    macro: '{#TYPE}'
                    value: Microsoft.DBforMySQL/servers
                    formulaid: A
              operations:
                -
                  operationobject: HOST_PROTOTYPE
                  operator: REGEXP
                  templates:
                    -
                      name: 'Azure MySQL single server by HTTP'
        -
          uuid: a4b35b5fe8c04b52a9640f2f41013230
          name: 'PostgreSQL servers discovery'
          type: DEPENDENT
          key: azure.pgsql.servers.discovery
          delay: '0'
          filter:
            evaltype: AND
            conditions:
              -
                macro: '{#TYPE}'
                value: ^Microsoft.DBforPostgreSQL
                formulaid: G
              -
                macro: '{#NAME}'
                value: '{$AZURE.PGSQL.DB.NAME.MATCHES}'
                formulaid: E
              -
                macro: '{#NAME}'
                value: '{$AZURE.PGSQL.DB.NAME.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: F
              -
                macro: '{#LOCATION}'
                value: '{$AZURE.PGSQL.DB.LOCATION.MATCHES}'
                formulaid: C
              -
                macro: '{#LOCATION}'
                value: '{$AZURE.PGSQL.DB.LOCATION.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: D
              -
                macro: '{#GROUP}'
                value: '{$AZURE.RESOURCE_GROUP.MATCHES}'
                formulaid: B
              -
                macro: '{#GROUP}'
                value: '{$AZURE.RESOURCE_GROUP.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: A
          description: 'The list of the PostgreSQL servers is provided by the subscription.'
          host_prototypes:
            -
              uuid: 54f0e0ec288f4feb9a2dc58a8726bd1d
              host: 'Azure PostgreSQL server {#NAME}'
              name: 'Azure PostgreSQL server {#NAME}'
              group_links:
                -
                  group:
                    name: Databases
              macros:
                -
                  macro: '{$AZURE.RESOURCE_ID}'
                  value: '{#ID}'
              tags:
                -
                  tag: location
                  value: '{#LOCATION}'
                -
                  tag: resource-group
                  value: '{#GROUP}'
                -
                  tag: size
                  value: '{#SIZE}'
                -
                  tag: version
                  value: '{#VERSION}'
          master_item:
            key: azure.get.resources
          lld_macro_paths:
            -
              lld_macro: '{#GROUP}'
              path: $.resourceGroup
            -
              lld_macro: '{#ID}'
              path: $.id
            -
              lld_macro: '{#LOCATION}'
              path: $.location
            -
              lld_macro: '{#NAME}'
              path: $.name
            -
              lld_macro: '{#SIZE}'
              path: $.sku.name
            -
              lld_macro: '{#TYPE}'
              path: $.type
            -
              lld_macro: '{#VERSION}'
              path: $.properties.version
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.resources.value
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
          overrides:
            -
              name: 'Flexible server'
              step: '1'
              filter:
                conditions:
                  -
                    macro: '{#TYPE}'
                    value: Microsoft.DBforPostgreSQL/flexibleServers
                    formulaid: A
              operations:
                -
                  operationobject: HOST_PROTOTYPE
                  operator: REGEXP
                  templates:
                    -
                      name: 'Azure PostgreSQL flexible server by HTTP'
            -
              name: 'Single server'
              step: '2'
              filter:
                conditions:
                  -
                    macro: '{#TYPE}'
                    value: Microsoft.DBforPostgreSQL/servers
                    formulaid: A
              operations:
                -
                  operationobject: HOST_PROTOTYPE
                  operator: REGEXP
                  templates:
                    -
                      name: 'Azure PostgreSQL single server by HTTP'
        -
          uuid: f9386233186648ce828f406c52972ce5
          name: 'Virtual machines discovery'
          type: DEPENDENT
          key: azure.vm.discovery
          delay: '0'
          filter:
            evaltype: AND
            conditions:
              -
                macro: '{#TYPE}'
                value: ^Microsoft.Compute/virtualMachines$
                formulaid: G
              -
                macro: '{#NAME}'
                value: '{$AZURE.VM.NAME.MATCHES}'
                formulaid: E
              -
                macro: '{#NAME}'
                value: '{$AZURE.VM.NAME.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: F
              -
                macro: '{#LOCATION}'
                value: '{$AZURE.VM.LOCATION.MATCHES}'
                formulaid: C
              -
                macro: '{#LOCATION}'
                value: '{$AZURE.VM.LOCATION.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: D
              -
                macro: '{#GROUP}'
                value: '{$AZURE.RESOURCE_GROUP.MATCHES}'
                formulaid: B
              -
                macro: '{#GROUP}'
                value: '{$AZURE.RESOURCE_GROUP.NOT_MATCHES}'
                operator: NOT_MATCHES_REGEX
                formulaid: A
          description: 'The list of the virtual machines is provided by the subscription.'
          host_prototypes:
            -
              uuid: d08c0ee33c924b28bf1fed571da6c7f4
              host: 'Azure virtual machine {#NAME}'
              name: 'Azure virtual machine {#NAME}'
              group_links:
                -
                  group:
                    name: 'Virtual machines'
              templates:
                -
                  name: 'Azure virtual machine by HTTP'
              macros:
                -
                  macro: '{$AZURE.RESOURCE_ID}'
                  value: '{#ID}'
              tags:
                -
                  tag: location
                  value: '{#LOCATION}'
                -
                  tag: os
                  value: '{#OS}'
                -
                  tag: resource-group
                  value: '{#GROUP}'
                -
                  tag: size
                  value: '{#SIZE}'
          master_item:
            key: azure.get.resources
          lld_macro_paths:
            -
              lld_macro: '{#GROUP}'
              path: $.resourceGroup
            -
              lld_macro: '{#ID}'
              path: $.id
            -
              lld_macro: '{#LOCATION}'
              path: $.location
            -
              lld_macro: '{#NAME}'
              path: $.name
            -
              lld_macro: '{#OS}'
              path: $.properties.storageProfile.osDisk.osType
            -
              lld_macro: '{#SIZE}'
              path: $.properties.hardwareProfile.vmSize
            -
              lld_macro: '{#TYPE}'
              path: $.type
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.resources.value
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 6h
      tags:
        -
          tag: class
          value: software
        -
          tag: target
          value: azure
      macros:
        -
          macro: '{$AZURE.APP_ID}'
          description: 'Microsoft Azure app ID.'
        -
          macro: '{$AZURE.DATA.TIMEOUT}'
          value: 15s
          description: 'A response timeout for API.'
        -
          macro: '{$AZURE.MYSQL.DB.LOCATION.MATCHES}'
          value: '.*'
          description: 'This macro is used in MySQL servers discovery rule.'
        -
          macro: '{$AZURE.MYSQL.DB.LOCATION.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in MySQL servers discovery rule.'
        -
          macro: '{$AZURE.MYSQL.DB.NAME.MATCHES}'
          value: '.*'
          description: 'This macro is used in MySQL servers discovery rule.'
        -
          macro: '{$AZURE.MYSQL.DB.NAME.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in MySQL servers discovery rule.'
        -
          macro: '{$AZURE.PASSWORD}'
          type: SECRET_TEXT
          description: 'Microsoft Azure password.'
        -
          macro: '{$AZURE.PGSQL.DB.LOCATION.MATCHES}'
          value: '.*'
          description: 'This macro is used in PostgreSQL servers discovery rule.'
        -
          macro: '{$AZURE.PGSQL.DB.LOCATION.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in PostgreSQL servers discovery rule.'
        -
          macro: '{$AZURE.PGSQL.DB.NAME.MATCHES}'
          value: '.*'
          description: 'This macro is used in PostgreSQL servers discovery rule.'
        -
          macro: '{$AZURE.PGSQL.DB.NAME.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in PostgreSQL servers discovery rule.'
        -
          macro: '{$AZURE.RESOURCE_GROUP.MATCHES}'
          value: '.*'
          description: 'This macro is used in discovery rules.'
        -
          macro: '{$AZURE.RESOURCE_GROUP.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in discovery rules.'
        -
          macro: '{$AZURE.SUBSCRIPTION_ID}'
          description: 'Microsoft Azure subscription ID.'
        -
          macro: '{$AZURE.TENANT_ID}'
          description: 'Microsoft Azure tenant ID.'
        -
          macro: '{$AZURE.VM.LOCATION.MATCHES}'
          value: '.*'
          description: 'This macro is used in virtual machines discovery rule.'
        -
          macro: '{$AZURE.VM.LOCATION.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in virtual machines discovery rule.'
        -
          macro: '{$AZURE.VM.NAME.MATCHES}'
          value: '.*'
          description: 'This macro is used in virtual machines discovery rule.'
        -
          macro: '{$AZURE.VM.NAME.NOT_MATCHES}'
          value: CHANGE_IF_NEEDED
          description: 'This macro is used in virtual machines discovery rule.'
    -
      uuid: ec92c7b0b1d14946b6ac61de89357199
      template: 'Azure MySQL flexible server by HTTP'
      name: 'Azure MySQL flexible server by HTTP'
      description: |
        This template is designed to monitor Microsoft Azure MySQL flexible servers by HTTP.
        It works without any external scripts and uses the script item.
        
        Setup:
          1. Create an Azure service principal via the Azure command-line interface (Azure CLI) for your subscription.
            `az ad sp create-for-rbac --name zabbix --role reader --scope /subscriptions/<subscription_id>`
            See https://docs.microsoft.com/en-us/cli/azure/create-an-azure-service-principal-azure-cli for more details.
          2. Link the template to a host.
          3. Configure macros {$AZURE.APP_ID}, {$AZURE.PASSWORD}, {$AZURE.TENANT_ID}, {$AZURE.SUBSCRIPTION_ID}, and {$AZURE.RESOURCE_ID}.
        
        You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/
        
        Template tooling version used: 0.42
      groups:
        -
          name: Templates/Cloud
      items:
        -
          uuid: 9c87cde45e984ce282d8ba9fbe184f9b
          name: 'Azure MySQL: Availability status detailed'
          type: DEPENDENT
          key: azure.db.mysql.availability.details
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The summary description of the availability status.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.summary
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: health
        -
          uuid: 7f2d8e8d94ae4c87ba0480a2d9518f65
          name: 'Azure MySQL: Availability state'
          type: DEPENDENT
          key: azure.db.mysql.availability.state
          delay: '0'
          history: 7d
          description: 'The availability status of the resource.'
          valuemap:
            name: 'Azure resource health state'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.availabilityState
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: STR_REPLACE
              parameters:
                - Available
                - '0'
            -
              type: STR_REPLACE
              parameters:
                - Degraded
                - '1'
            -
              type: STR_REPLACE
              parameters:
                - Unavailable
                - '2'
            -
              type: STR_REPLACE
              parameters:
                - Unknown
                - '3'
            -
              type: IN_RANGE
              parameters:
                - '0'
                - '3'
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: health
          triggers:
            -
              uuid: e822fd2214fb41db9b57cdb8eec0444a
              expression: 'last(/Azure MySQL flexible server by HTTP/azure.db.mysql.availability.state)=1'
              name: 'Azure MySQL: MySQL server is degraded'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The resource is in degraded state.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: ebb35037a5b646a0bd2c6be44bb1f3c6
              expression: 'last(/Azure MySQL flexible server by HTTP/azure.db.mysql.availability.state)=3'
              name: 'Azure MySQL: MySQL server is in unknown state'
              opdata: '{ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'The resource state is unknown.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: 240b861c09a94e209036782b6c7496fa
              expression: 'last(/Azure MySQL flexible server by HTTP/azure.db.mysql.availability.state)=2'
              name: 'Azure MySQL: MySQL server is unavailable'
              opdata: '{ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The resource state is unavailable.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: cab6ac822f2c4e118b030e49cc15eaa2
          name: 'Azure MySQL: Connections aborted'
          type: DEPENDENT
          key: azure.db.mysql.connections.aborted
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of aborted connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.aborted_connections.total
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
          triggers:
            -
              uuid: 3346ea2331c14fa18658eb33e461ec7c
              expression: 'min(/Azure MySQL flexible server by HTTP/azure.db.mysql.connections.aborted,5m)>{$AZURE.DB.ABORTED_CONN.MAX.WARN}'
              name: 'Azure MySQL: Server has aborted connections'
              opdata: 'Current value: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The number of failed attempts to connect to the MySQL server is more than {$AZURE.DB.ABORTED_CONN.MAX.WARN}.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: 71b33f0a5d37498dbb57d185ac0f2741
          name: 'Azure MySQL: Connections active'
          type: DEPENDENT
          key: azure.db.mysql.connections.active
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.active_connections.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 1993ae276fe44db6a89451291749f703
          name: 'Azure MySQL: Connections total'
          type: DEPENDENT
          key: azure.db.mysql.connections.total
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of total connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.total_connections.total
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: b235666b98954555ae5e75e757bba707
          name: 'Azure MySQL: CPU credits consumed'
          type: DEPENDENT
          key: azure.db.mysql.cpu.credits.consumed
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Consumed CPU credits.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_credits_consumed.maximum
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: cpu
        -
          uuid: 4f591346d3d34d49b37cfff2a169f57e
          name: 'Azure MySQL: CPU credits remaining'
          type: DEPENDENT
          key: azure.db.mysql.cpu.credits.remaining
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Remaining CPU credits.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_credits_remaining.maximum
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: cpu
        -
          uuid: afe4d11c2f474428acc00d153ad2a6e5
          name: 'Azure MySQL: Percentage CPU'
          type: DEPENDENT
          key: azure.db.mysql.cpu.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The CPU percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_percent.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: cpu
          triggers:
            -
              uuid: 5af82cc95239479c86c7ab3dabcfb592
              expression: 'min(/Azure MySQL flexible server by HTTP/azure.db.mysql.cpu.percentage,5m)>{$AZURE.DB.CPU.UTIL.CRIT}'
              name: 'Azure MySQL: High CPU utilization'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The CPU utilization is too high. The system might be slow to respond.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: f960e7667571497c96454b5c4b7b69ff
          name: 'Azure MySQL: Get errors'
          type: DEPENDENT
          key: azure.db.mysql.data.errors
          delay: '0'
          history: 7d
          trends: '0'
          value_type: TEXT
          description: 'A list of errors from API requests.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.errors
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: raw
          triggers:
            -
              uuid: 98c1b86b79e9469cac2870fb2ba42949
              expression: 'length(last(/Azure MySQL flexible server by HTTP/azure.db.mysql.data.errors))>0'
              name: 'Azure MySQL: There are errors in requests to API'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Zabbix has received errors in response to API requests.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: de712334db1440309fa68f9252d4f9bc
          name: 'Azure MySQL: Get data'
          type: SCRIPT
          key: azure.db.mysql.data.get
          history: 0d
          trends: '0'
          value_type: TEXT
          params: |
            var AzureDB = {
                params: {},
                token: null,
            
                setParams: function (params) {
                    ['app_id', 'password', 'tenant_id', 'subscription_id', 'resource_id'].forEach(function (field) {
                        if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
                            throw 'Required param is not set: ' + field + '.';
                        }
                    });
            
                    AzureDB.params = params;
                },
            
            
                request: function (url, data) {
                    if (typeof data === 'undefined' || data === null) {
                        data = '';
                    }
            
                    var response, request = new HttpRequest();
                        if (AzureDB.token) {
                            request.addHeader('Accept: application/json');
                            request.addHeader('Authorization: Bearer ' + AzureDB.token);
                        }
                
                    Zabbix.log(4, '[ Azure ] Sending request: ' + url);
            
                    if (data !== '') {
                        request.addHeader('Content-Type: application/x-www-form-urlencoded');
                        response = request.post(url, data);
                    }
                    else {
                        response = request.get(url);
                    }
            
                    Zabbix.log(4, '[ Azure ] Received response with status code ' + request.getStatus() + ': ' + response);
            
                    if (request.getStatus() !== 200 || response === null) {
                        throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
                    }
            
                    try {
                        return JSON.parse(response);
                    }
                    catch (error) {
                        throw 'Failed to parse response received from API.';
                    }
            }
            
            };
            
            var metrics = [
                'cpu_percent',
                'memory_percent',
                'network_bytes_egress',
                'network_bytes_ingress',
                'active_connections',
                'total_connections',
                'aborted_connections',
                'Queries',
                'io_consumption_percent',
                'storage_percent',
                'storage_used',
                'storage_limit',
                'backup_storage_used',
                'replication_lag',
                'cpu_credits_remaining',
                'cpu_credits_consumed'
            ],
                prepared_metrics = [],
                data = {};
                data['errors'] = {};
                data['metrics'] = {};
            
            try {
                AzureDB.setParams(JSON.parse(value));
            
                try {
                    result = AzureDB.request(
                            'https://login.microsoftonline.com/' + encodeURIComponent(AzureDB.params.tenant_id) + '/oauth2/token',
                            'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(AzureDB.params.app_id) + '&client_secret=' + encodeURIComponent(AzureDB.params.password)
                    );
            
                    if ('access_token' in result) {
                        AzureDB.token = result['access_token'];
                    } else {
                        throw 'Auth response does not contain access token.';
                    }
                }
                catch (error) {
                    data.errors.auth = error.toString();
                }
            
                if (!('auth' in data.errors)) {
                    try {
                        health = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.ResourceHealth/availabilityStatuses?api-version=2020-05-01');
                        data.health = health.value[0].properties;
                    }
                    catch (error) {
                        data.errors.health = error.toString();
                    }
            
                    for (var i = 0; i < metrics.length; i += 20) {
                        var chunk = metrics.slice(i, i + 20);
            
                        prepared_metrics.push(
                            chunk.map(function(element) {
                                return encodeURIComponent(element);
                            }).join(',')
                        );
                    }
            
                    start_date = new Date((new Date().getTime()) - 300000).toISOString().replace(/\.\d+/, '');
                    end_date = new Date().toISOString().replace(/\.\d+/, '');
                    
                    for (var j in prepared_metrics) {
                        try {
                            metrics_data = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.Insights/metrics?metricnames=' + prepared_metrics[j] + '&timespan=' + encodeURIComponent(start_date) + '/' + encodeURIComponent(end_date) + '&api-version=2021-05-01');
                            for (k in metrics_data.value) {
                                data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 1];
                            }
                        }
                        catch (error) {
                            data.errors[prepared_metrics[j]] = error.toString();
                        }
                    } 
                }
            }
            catch (error) {
                data.errors.params = error.toString();
            }
            
            if (Object.keys(data.errors).length !== 0) {
                errors = 'Failed to receive data:';
                for (var error in data.errors) {
                    errors += '\n' + error + ' : ' + data.errors[error];
                }
                data.errors = errors;
            }
            else {
                data.errors = '';
            }
            
            return JSON.stringify(data);
          description: 'The result of API requests is expressed in the JSON.'
          timeout: '{$AZURE.DATA.TIMEOUT}'
          parameters:
            -
              name: app_id
              value: '{$AZURE.APP_ID}'
            -
              name: password
              value: '{$AZURE.PASSWORD}'
            -
              name: tenant_id
              value: '{$AZURE.TENANT_ID}'
            -
              name: subscription_id
              value: '{$AZURE.SUBSCRIPTION_ID}'
            -
              name: resource_id
              value: '{$AZURE.RESOURCE_ID}'
          tags:
            -
              tag: component
              value: raw
        -
          uuid: b4a6363aac734b6c8d043718ca667c09
          name: 'Azure MySQL: IO consumption percent'
          type: DEPENDENT
          key: azure.db.mysql.io.consumption.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The IO percent.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.io_consumption_percent.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: operations
        -
          uuid: f0f56a67942a40509d6835f3da9eb7e2
          name: 'Azure MySQL: Memory utilization'
          type: DEPENDENT
          key: azure.db.mysql.memory.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The memory percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.memory_percent.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: memory
        -
          uuid: 84f3d2b152784993944a2d4c3fad1a59
          name: 'Azure MySQL: Network out'
          type: DEPENDENT
          key: azure.db.mysql.network.egress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network egress of a host in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_egress.total
            -
              type: MULTIPLIER
              parameters:
                - '0.0088'
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 5f38b6b4e3a849d09022bd34c4347088
          name: 'Azure MySQL: Network in'
          type: DEPENDENT
          key: azure.db.mysql.network.ingress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network ingress of a host in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_ingress.total
            -
              type: MULTIPLIER
              parameters:
                - '0.0088'
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 05329dcdb2e14080a43d1bf7553037f6
          name: 'Azure MySQL: Queries'
          type: DEPENDENT
          key: azure.db.mysql.queries
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of queries.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.Queries.total
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: queries
        -
          uuid: 80a05247fec04e39a99ccafaefbd0441
          name: 'Azure MySQL: Replication lag'
          type: DEPENDENT
          key: azure.db.mysql.replication.lag
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: s
          description: 'The replication lag expressed in seconds.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.replication_lag.maximum
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: replication
        -
          uuid: 8d5cd0d3cd0744a5a260a8a0485f6735
          name: 'Azure MySQL: Backup storage used'
          type: DEPENDENT
          key: azure.db.mysql.storage.backup.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used backup storage expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.backup_storage_used.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 78f3e03b5caf4f85a3c61513cf242f76
          name: 'Azure MySQL: Storage limit'
          type: DEPENDENT
          key: azure.db.mysql.storage.limit
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage limit expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_limit.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: ced51184b59643adaa51bef90710166b
          name: 'Azure MySQL: Storage percent'
          type: DEPENDENT
          key: azure.db.mysql.storage.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The storage utilization expressed in %.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_percent.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
          triggers:
            -
              uuid: 1703edc1553644e5aa25d35928c5eafd
              expression: 'last(/Azure MySQL flexible server by HTTP/azure.db.mysql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.CRIT}'
              name: 'Azure MySQL: Storage space is critically low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Critical utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
            -
              uuid: a2ec23a5e77c40aa9e45d214f4e06ca1
              expression: 'last(/Azure MySQL flexible server by HTTP/azure.db.mysql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.WARN}'
              name: 'Azure MySQL: Storage space is low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'High utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
        -
          uuid: 9f96e947eee646f890742676e9f9a22a
          name: 'Azure MySQL: Storage used'
          type: DEPENDENT
          key: azure.db.mysql.storage.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used storage space expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_used.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
      tags:
        -
          tag: class
          value: software
        -
          tag: target
          value: azure
      macros:
        -
          macro: '{$AZURE.APP_ID}'
          description: 'Microsoft Azure app ID.'
        -
          macro: '{$AZURE.DATA.TIMEOUT}'
          value: 60s
          description: 'A response timeout for API.'
        -
          macro: '{$AZURE.DB.ABORTED_CONN.MAX.WARN}'
          value: '25'
          description: 'The number of failed attempts to connect to the MySQL server for trigger expression.'
        -
          macro: '{$AZURE.DB.CPU.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the CPU utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.CRIT}'
          value: '90'
          description: 'The critical threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.WARN}'
          value: '80'
          description: 'The warning threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.PASSWORD}'
          type: SECRET_TEXT
          description: 'Microsoft Azure password.'
        -
          macro: '{$AZURE.RESOURCE_ID}'
          description: 'Microsoft Azure virtual machine ID.'
        -
          macro: '{$AZURE.SUBSCRIPTION_ID}'
          description: 'Microsoft Azure subscription ID.'
        -
          macro: '{$AZURE.TENANT_ID}'
          description: 'Microsoft Azure tenant ID.'
      valuemaps:
        -
          uuid: 4eec167b4d69441398b96b8e375d6825
          name: 'Azure resource health state'
          mappings:
            -
              value: '0'
              newvalue: Available
            -
              value: '1'
              newvalue: Degraded
            -
              value: '2'
              newvalue: Unavailable
            -
              value: '3'
              newvalue: Unknown
    -
      uuid: c1396bf1e8cf46f6a407e88ddceef0b8
      template: 'Azure MySQL single server by HTTP'
      name: 'Azure MySQL single server by HTTP'
      description: |
        This template is designed to monitor Microsoft Azure MySQL single servers by HTTP.
        It works without any external scripts and uses the script item.
        
        Setup:
          1. Create an Azure service principal via the Azure command-line interface (Azure CLI) for your subscription.
            `az ad sp create-for-rbac --name zabbix --role reader --scope /subscriptions/<subscription_id>`
            See https://docs.microsoft.com/en-us/cli/azure/create-an-azure-service-principal-azure-cli for more details.
          2. Link the template to a host.
          3. Configure macros {$AZURE.APP_ID}, {$AZURE.PASSWORD}, {$AZURE.TENANT_ID}, {$AZURE.SUBSCRIPTION_ID}, and {$AZURE.RESOURCE_ID}.
        
        You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/
        
        Template tooling version used: 0.42
      groups:
        -
          name: Templates/Cloud
      items:
        -
          uuid: c7771aa67d3c424490d8de2d6c2d609a
          name: 'Azure MySQL: Availability status detailed'
          type: DEPENDENT
          key: azure.db.mysql.availability.details
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The summary description of the availability status.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.summary
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: health
        -
          uuid: c325b977b26e4e00acc3ea8703895f05
          name: 'Azure MySQL: Availability state'
          type: DEPENDENT
          key: azure.db.mysql.availability.state
          delay: '0'
          history: 7d
          description: 'The availability status of the resource.'
          valuemap:
            name: 'Azure resource health state'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.availabilityState
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: STR_REPLACE
              parameters:
                - Available
                - '0'
            -
              type: STR_REPLACE
              parameters:
                - Degraded
                - '1'
            -
              type: STR_REPLACE
              parameters:
                - Unavailable
                - '2'
            -
              type: STR_REPLACE
              parameters:
                - Unknown
                - '3'
            -
              type: IN_RANGE
              parameters:
                - '0'
                - '3'
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: health
          triggers:
            -
              uuid: 91a32645266547d78df3a70b44c7782b
              expression: 'last(/Azure MySQL single server by HTTP/azure.db.mysql.availability.state)=1'
              name: 'Azure MySQL: MySQL server is degraded'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The resource is in degraded state.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: 852aba88476a40aeb2170b933726b7d8
              expression: 'last(/Azure MySQL single server by HTTP/azure.db.mysql.availability.state)=3'
              name: 'Azure MySQL: MySQL server is in unknown state'
              opdata: '{ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'The resource state is unknown.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: 5f2d2254dfc24f5481207585bed0d933
              expression: 'last(/Azure MySQL single server by HTTP/azure.db.mysql.availability.state)=2'
              name: 'Azure MySQL: MySQL server is unavailable'
              opdata: '{ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The resource state is unavailable.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: 69aba8caa6874c9d9423926a2ee78e99
          name: 'Azure MySQL: Connections active'
          type: DEPENDENT
          key: azure.db.mysql.connections.active
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.active_connections.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: e185b56984914507bc40c07c55153967
          name: 'Azure MySQL: Connections failed'
          type: DEPENDENT
          key: azure.db.mysql.connections.failed
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of failed connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.connections_failed.total
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
          triggers:
            -
              uuid: 5b3a09ca04704e6a9972ee4865d358cd
              expression: 'min(/Azure MySQL single server by HTTP/azure.db.mysql.connections.failed,5m)>{$AZURE.DB.FAILED_CONN.MAX.WARN}'
              name: 'Azure MySQL: Server has failed connections'
              opdata: 'Current value: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The number of failed attempts to connect to the MySQL server is more than {$AZURE.DB.FAILED_CONN.MAX.WARN}.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: d0b5864a56094166b76fbc58a5e05c7c
          name: 'Azure MySQL: Percentage CPU'
          type: DEPENDENT
          key: azure.db.mysql.cpu.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The CPU percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_percent.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: cpu
          triggers:
            -
              uuid: 7115fb320e2b4cc1ad1739c8a6cee155
              expression: 'min(/Azure MySQL single server by HTTP/azure.db.mysql.cpu.percentage,5m)>{$AZURE.DB.CPU.UTIL.CRIT}'
              name: 'Azure MySQL: High CPU utilization'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The CPU utilization is too high. The system might be slow to respond.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: 2fc253a20100478d91cac13590a64bfc
          name: 'Azure MySQL: Get errors'
          type: DEPENDENT
          key: azure.db.mysql.data.errors
          delay: '0'
          history: 7d
          trends: '0'
          value_type: TEXT
          description: 'A list of errors from API requests.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.errors
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: raw
          triggers:
            -
              uuid: df5fa33f8c13413bb9d61ea4470b9b2d
              expression: 'length(last(/Azure MySQL single server by HTTP/azure.db.mysql.data.errors))>0'
              name: 'Azure MySQL: There are errors in requests to API'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Zabbix has received errors in response to API requests.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: cd62d92ef0384ea9acf0cae71c88ebc6
          name: 'Azure MySQL: Get data'
          type: SCRIPT
          key: azure.db.mysql.data.get
          history: 0d
          trends: '0'
          value_type: TEXT
          params: |
            var AzureDB = {
                params: {},
                token: null,
            
                setParams: function (params) {
                    ['app_id', 'password', 'tenant_id', 'subscription_id', 'resource_id'].forEach(function (field) {
                        if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
                            throw 'Required param is not set: ' + field + '.';
                        }
                    });
            
                    AzureDB.params = params;
                },
            
            
                request: function (url, data) {
                    if (typeof data === 'undefined' || data === null) {
                        data = '';
                    }
            
                    var response, request = new HttpRequest();
                        if (AzureDB.token) {
                            request.addHeader('Accept: application/json');
                            request.addHeader('Authorization: Bearer ' + AzureDB.token);
                        }
                
                    Zabbix.log(4, '[ Azure ] Sending request: ' + url);
            
                    if (data !== '') {
                        request.addHeader('Content-Type: application/x-www-form-urlencoded');
                        response = request.post(url, data);
                    }
                    else {
                        response = request.get(url);
                    }
            
                    Zabbix.log(4, '[ Azure ] Received response with status code ' + request.getStatus() + ': ' + response);
            
                    if (request.getStatus() !== 200 || response === null) {
                        throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
                    }
            
                    try {
                        return JSON.parse(response);
                    }
                    catch (error) {
                        throw 'Failed to parse response received from API.';
                    }
            }
            
            };
            
            var metrics = [
                'cpu_percent',
                'memory_percent',
                'io_consumption_percent',
                'storage_percent',
                'storage_used',
                'storage_limit',
                'serverlog_storage_percent',
                'serverlog_storage_usage',
                'serverlog_storage_limit',
                'active_connections',
                'connections_failed',
                'seconds_behind_master',
                'backup_storage_used',
                'network_bytes_egress',
                'network_bytes_ingress'
            ],
                prepared_metrics = [],
                data = {};
                data['errors'] = {};
                data['metrics'] = {};
            
            try {
                AzureDB.setParams(JSON.parse(value));
            
                try {
                    result = AzureDB.request(
                            'https://login.microsoftonline.com/' + encodeURIComponent(AzureDB.params.tenant_id) + '/oauth2/token',
                            'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(AzureDB.params.app_id) + '&client_secret=' + encodeURIComponent(AzureDB.params.password)
                    );
            
                    if ('access_token' in result) {
                        AzureDB.token = result['access_token'];
                    } else {
                        throw 'Auth response does not contain access token.';
                    }
                }
                catch (error) {
                    data.errors.auth = error.toString();
                }
            
                if (!('auth' in data.errors)) {
                    try {
                        health = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.ResourceHealth/availabilityStatuses?api-version=2020-05-01');
                        data.health = health.value[0].properties;
                    }
                    catch (error) {
                        data.errors.health = error.toString();
                    }
            
                    for (var i = 0; i < metrics.length; i += 20) {
                        var chunk = metrics.slice(i, i + 20);
            
                        prepared_metrics.push(
                            chunk.map(function(element) {
                                return encodeURIComponent(element);
                            }).join(',')
                        );
                    }
            
                    start_date = new Date((new Date().getTime()) - 300000).toISOString().replace(/\.\d+/, '');
                    end_date = new Date().toISOString().replace(/\.\d+/, '');
                    
                    for (var j in prepared_metrics) {
                        try {
                            metrics_data = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.Insights/metrics?metricnames=' + prepared_metrics[j] + '&timespan=' + encodeURIComponent(start_date) + '/' + encodeURIComponent(end_date) + '&api-version=2021-05-01');
                            for (k in metrics_data.value) {
                                data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 1];
                            }
                        }
                        catch (error) {
                            data.errors[prepared_metrics[j]] = error.toString();
                        }
                    } 
                }
            }
            catch (error) {
                data.errors.params = error.toString();
            }
            
            if (Object.keys(data.errors).length !== 0) {
                errors = 'Failed to receive data:';
                for (var error in data.errors) {
                    errors += '\n' + error + ' : ' + data.errors[error];
                }
                data.errors = errors;
            }
            else {
                data.errors = '';
            }
            
            return JSON.stringify(data);
          description: 'The result of API requests is expressed in the JSON.'
          timeout: '{$AZURE.DATA.TIMEOUT}'
          parameters:
            -
              name: app_id
              value: '{$AZURE.APP_ID}'
            -
              name: password
              value: '{$AZURE.PASSWORD}'
            -
              name: tenant_id
              value: '{$AZURE.TENANT_ID}'
            -
              name: subscription_id
              value: '{$AZURE.SUBSCRIPTION_ID}'
            -
              name: resource_id
              value: '{$AZURE.RESOURCE_ID}'
          tags:
            -
              tag: component
              value: raw
        -
          uuid: a17c365253eb4821841ec82ac8f61106
          name: 'Azure MySQL: IO consumption percent'
          type: DEPENDENT
          key: azure.db.mysql.io.consumption.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The IO percent.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.io_consumption_percent.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: operations
        -
          uuid: 5c19c08912634993b1f96fb11e5d1ae2
          name: 'Azure MySQL: Memory utilization'
          type: DEPENDENT
          key: azure.db.mysql.memory.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The memory percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.memory_percent.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: memory
          triggers:
            -
              uuid: a67b35f1ac674d6692b0b2bcd6f89bd8
              expression: 'min(/Azure MySQL single server by HTTP/azure.db.mysql.memory.percentage,5m)>{$AZURE.DB.MEMORY.UTIL.CRIT}'
              name: 'Azure MySQL: High memory utilization'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The system is running out of free memory.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: fe1b9846a634412aaa6a76fc05dbe46a
          name: 'Azure MySQL: Network out'
          type: DEPENDENT
          key: azure.db.mysql.network.egress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network outbound traffic across the active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_egress.total
              error_handler: DISCARD_VALUE
            -
              type: MULTIPLIER
              parameters:
                - '0.0088'
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 1cc97817bda5470887e3d5d9f2d78650
          name: 'Azure MySQL: Network in'
          type: DEPENDENT
          key: azure.db.mysql.network.ingress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network inbound traffic across the active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_ingress.total
              error_handler: DISCARD_VALUE
            -
              type: MULTIPLIER
              parameters:
                - '0.0088'
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 8e60794282ea42c7bad1573811b2e498
          name: 'Azure MySQL: Replication lag'
          type: DEPENDENT
          key: azure.db.mysql.replication.lag
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: s
          description: 'The replication lag expressed in seconds.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.seconds_behind_master.maximum
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: replication
        -
          uuid: 1303a659d17a4e4fa9fa03cef35fef5a
          name: 'Azure MySQL: Backup storage used'
          type: DEPENDENT
          key: azure.db.mysql.storage.backup.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used backup storage expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.backup_storage_used.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 4aed6d0c01d1458fbd1f7c7ea5386303
          name: 'Azure MySQL: Storage limit'
          type: DEPENDENT
          key: azure.db.mysql.storage.limit
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage limit expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_limit.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 5b1b350be6f0409fb7ab842571c3f086
          name: 'Azure MySQL: Storage percent'
          type: DEPENDENT
          key: azure.db.mysql.storage.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The storage utilization expressed in %.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_percent.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
          triggers:
            -
              uuid: 3afcb840e8004822a2dada2a89971f69
              expression: 'last(/Azure MySQL single server by HTTP/azure.db.mysql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.CRIT}'
              name: 'Azure MySQL: Storage space is critically low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Critical utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
            -
              uuid: 2e605f906b284f769e7c880d4e642b43
              expression: 'last(/Azure MySQL single server by HTTP/azure.db.mysql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.WARN}'
              name: 'Azure MySQL: Storage space is low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'High utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
        -
          uuid: 7f553d8a0898477b87a2828e51efcfcc
          name: 'Azure MySQL: Server log storage limit'
          type: DEPENDENT
          key: azure.db.mysql.storage.server.log.limit
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage limit of a server log expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.serverlog_storage_limit.maximum
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: cf5a77306c554a24b3741ef065b6d27a
          name: 'Azure MySQL: Server log storage percent'
          type: DEPENDENT
          key: azure.db.mysql.storage.server.log.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The storage utilization by a server log expressed in %.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.serverlog_storage_percent.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 8ed99a951e264185b1e0f343d7ea0aec
          name: 'Azure MySQL: Server log storage used'
          type: DEPENDENT
          key: azure.db.mysql.storage.server.log.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage space used by a server log expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.serverlog_storage_usage.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 0c9a5496d9884c8e9a434fb232b3208f
          name: 'Azure MySQL: Storage used'
          type: DEPENDENT
          key: azure.db.mysql.storage.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used storage space expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_used.average
          master_item:
            key: azure.db.mysql.data.get
          tags:
            -
              tag: component
              value: storage
      tags:
        -
          tag: class
          value: software
        -
          tag: target
          value: azure
      macros:
        -
          macro: '{$AZURE.APP_ID}'
          description: 'Microsoft Azure app ID.'
        -
          macro: '{$AZURE.DATA.TIMEOUT}'
          value: 60s
          description: 'A response timeout for API.'
        -
          macro: '{$AZURE.DB.CPU.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the CPU utilization expressed in %.'
        -
          macro: '{$AZURE.DB.FAILED_CONN.MAX.WARN}'
          value: '25'
          description: 'The number of failed attempts to connect to the MySQL server for trigger expression.'
        -
          macro: '{$AZURE.DB.MEMORY.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the memory utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.CRIT}'
          value: '90'
          description: 'The critical threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.WARN}'
          value: '80'
          description: 'The warning threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.PASSWORD}'
          type: SECRET_TEXT
          description: 'Microsoft Azure password.'
        -
          macro: '{$AZURE.RESOURCE_ID}'
          description: 'Microsoft Azure virtual machine ID.'
        -
          macro: '{$AZURE.SUBSCRIPTION_ID}'
          description: 'Microsoft Azure subscription ID.'
        -
          macro: '{$AZURE.TENANT_ID}'
          description: 'Microsoft Azure tenant ID.'
      valuemaps:
        -
          uuid: 323a5259fb854724891515767f341540
          name: 'Azure resource health state'
          mappings:
            -
              value: '0'
              newvalue: Available
            -
              value: '1'
              newvalue: Degraded
            -
              value: '2'
              newvalue: Unavailable
            -
              value: '3'
              newvalue: Unknown
    -
      uuid: 35ef29f24158444097272d2ea7fa6044
      template: 'Azure PostgreSQL flexible server by HTTP'
      name: 'Azure PostgreSQL flexible server by HTTP'
      description: |
        This template is designed to monitor Microsoft Azure PostgreSQL flexible servers by HTTP.
        It works without any external scripts and uses the script item.
        
        Setup:
          1. Create an Azure service principal via the Azure command-line interface (Azure CLI) for your subscription.
            `az ad sp create-for-rbac --name zabbix --role reader --scope /subscriptions/<subscription_id>`
            See https://docs.microsoft.com/en-us/cli/azure/create-an-azure-service-principal-azure-cli for more details.
          2. Link the template to a host.
          3. Configure macros {$AZURE.APP_ID}, {$AZURE.PASSWORD}, {$AZURE.TENANT_ID}, {$AZURE.SUBSCRIPTION_ID}, and {$AZURE.RESOURCE_ID}.
        
        You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/
        
        Template tooling version used: 0.42
      groups:
        -
          name: Templates/Cloud
      items:
        -
          uuid: 7f7deae517e54cf582ae758a6988037b
          name: 'Azure PostgreSQL: Availability status detailed'
          type: DEPENDENT
          key: azure.db.pgsql.availability.details
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The summary description of the availability status.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.summary
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: health
        -
          uuid: cd9072a3895c42dab794707f3bcaf743
          name: 'Azure PostgreSQL: Availability state'
          type: DEPENDENT
          key: azure.db.pgsql.availability.state
          delay: '0'
          history: 7d
          description: 'The availability status of the resource.'
          valuemap:
            name: 'Azure resource health state'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.availabilityState
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: STR_REPLACE
              parameters:
                - Available
                - '0'
            -
              type: STR_REPLACE
              parameters:
                - Degraded
                - '1'
            -
              type: STR_REPLACE
              parameters:
                - Unavailable
                - '2'
            -
              type: STR_REPLACE
              parameters:
                - Unknown
                - '3'
            -
              type: IN_RANGE
              parameters:
                - '0'
                - '3'
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: health
          triggers:
            -
              uuid: 65b5c39b48e248c4866c511bbba91e1b
              expression: 'last(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.availability.state)=1'
              name: 'Azure PostgreSQL: PostgreSQL server is degraded'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The resource is in degraded state.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: d8ce86c853064cba80c9883052ed1403
              expression: 'last(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.availability.state)=3'
              name: 'Azure PostgreSQL: PostgreSQL server is in unknown state'
              opdata: '{ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'The resource state is unknown.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: 9572c9e56a6b44368bcf2d8a17a220d8
              expression: 'last(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.availability.state)=2'
              name: 'Azure PostgreSQL: PostgreSQL server is unavailable'
              opdata: '{ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The resource state is unavailable.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: 05ada75c666e45269c3c36159f9902cc
          name: 'Azure PostgreSQL: Connections active'
          type: DEPENDENT
          key: azure.db.pgsql.connections.active
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.active_connections.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 00d1116141874dbfb204ebfe96c203f1
          name: 'Azure PostgreSQL: Connections failed'
          type: DEPENDENT
          key: azure.db.pgsql.connections.failed
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of failed connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.connections_failed.total
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: f422f01bf1c9484e880581f31f70e120
          name: 'Azure PostgreSQL: Connections succeeded'
          type: DEPENDENT
          key: azure.db.pgsql.connections.succeeded
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of succeeded connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.connections_succeeded.total
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 1f1270c6981b4d08864572410fdeccde
          name: 'Azure PostgreSQL: CPU credits consumed'
          type: DEPENDENT
          key: azure.db.pgsql.cpu.credits.consumed
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The total number of credits consumed by the database server.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_credits_consumed.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: cpu
        -
          uuid: e55082c4a278435286335cebd2ae1cac
          name: 'Azure PostgreSQL: CPU credits remaining'
          type: DEPENDENT
          key: azure.db.pgsql.cpu.credits.remaining
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The total number of credits available to burst.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_credits_remaining.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: cpu
        -
          uuid: 8d85c5c73c894cdda6324832a703fea2
          name: 'Azure PostgreSQL: Percentage CPU'
          type: DEPENDENT
          key: azure.db.pgsql.cpu.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The CPU percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: cpu
          triggers:
            -
              uuid: f8672e4488b740a9a17395689c3d853c
              expression: 'min(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.cpu.percentage,5m)>{$AZURE.DB.CPU.UTIL.CRIT}'
              name: 'Azure PostgreSQL: High CPU utilization'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The CPU utilization is too high. The system might be slow to respond.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: 06c4226667ec4c4489e6d3ad31c3135f
          name: 'Azure PostgreSQL: Get errors'
          type: DEPENDENT
          key: azure.db.pgsql.data.errors
          delay: '0'
          history: 7d
          trends: '0'
          value_type: TEXT
          description: 'A list of errors from API requests.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.errors
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: raw
          triggers:
            -
              uuid: 55962f0d8a4c44c9a6b09da705e94c59
              expression: 'length(last(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.data.errors))>0'
              name: 'Azure PostgreSQL: There are errors in requests to API'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Zabbix has received errors in response to API requests.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: 1792c0566e8a438dad5e299d8f5b9094
          name: 'Azure PostgreSQL: Get data'
          type: SCRIPT
          key: azure.db.pgsql.data.get
          history: 0d
          trends: '0'
          value_type: TEXT
          params: |
            var AzureDB = {
                params: {},
                token: null,
            
                setParams: function (params) {
                    ['app_id', 'password', 'tenant_id', 'subscription_id', 'resource_id'].forEach(function (field) {
                        if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
                            throw 'Required param is not set: ' + field + '.';
                        }
                    });
            
                    AzureDB.params = params;
                },
            
            
                request: function (url, data) {
                    if (typeof data === 'undefined' || data === null) {
                        data = '';
                    }
            
                    var response, request = new HttpRequest();
                        if (AzureDB.token) {
                            request.addHeader('Accept: application/json');
                            request.addHeader('Authorization: Bearer ' + AzureDB.token);
                        }
                
                    Zabbix.log(4, '[ Azure ] Sending request: ' + url);
            
                    if (data !== '') {
                        request.addHeader('Content-Type: application/x-www-form-urlencoded');
                        response = request.post(url, data);
                    }
                    else {
                        response = request.get(url);
                    }
            
                    Zabbix.log(4, '[ Azure ] Received response with status code ' + request.getStatus() + ': ' + response);
            
                    if (request.getStatus() !== 200 || response === null) {
                        throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
                    }
            
                    try {
                        return JSON.parse(response);
                    }
                    catch (error) {
                        throw 'Failed to parse response received from API.';
                    }
            }
            
            };
            
            var metrics = [
                'cpu_percent',
                'memory_percent',
                'iops',
                'disk_queue_depth',
                'read_throughput',
                'write_throughput',
                'read_iops',
                'write_iops',
                'network_bytes_egress',
                'network_bytes_ingress',
                'active_connections',
                'connections_failed',
                'connections_succeeded',
                'storage_percent',
                'storage_used',
                'storage_free',
                'txlogs_storage_used',
                'backup_storage_used',
                'maximum_used_transactionIDs',
                'cpu_credits_remaining',
                'cpu_credits_consumed'
            ],
                prepared_metrics = [],
                data = {};
                data['errors'] = {};
                data['metrics'] = {};
            
            try {
                AzureDB.setParams(JSON.parse(value));
            
                try {
                    result = AzureDB.request(
                            'https://login.microsoftonline.com/' + encodeURIComponent(AzureDB.params.tenant_id) + '/oauth2/token',
                            'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(AzureDB.params.app_id) + '&client_secret=' + encodeURIComponent(AzureDB.params.password)
                    );
            
                    if ('access_token' in result) {
                        AzureDB.token = result['access_token'];
                    } else {
                        throw 'Auth response does not contain access token.';
                    }
                }
                catch (error) {
                    data.errors.auth = error.toString();
                }
            
                if (!('auth' in data.errors)) {
                    try {
                        health = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.ResourceHealth/availabilityStatuses?api-version=2020-05-01');
                        data.health = health.value[0].properties;
                    }
                    catch (error) {
                        data.errors.health = error.toString();
                    }
            
                    for (var i = 0; i < metrics.length; i += 20) {
                        var chunk = metrics.slice(i, i + 20);
            
                        prepared_metrics.push(
                            chunk.map(function(element) {
                                return encodeURIComponent(element);
                            }).join(',')
                        );
                    }
            
                    start_date = new Date((new Date().getTime()) - 600000).toISOString().replace(/\.\d+/, '');
                    end_date = new Date().toISOString().replace(/\.\d+/, '');
                    
                    for (var j in prepared_metrics) {
                        try {
                            metrics_data = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.Insights/metrics?metricnames=' + prepared_metrics[j] + '&timespan=' + encodeURIComponent(start_date) + '/' + encodeURIComponent(end_date) + '&api-version=2021-05-01');
                            for (k in metrics_data.value) {
                                if (metrics_data.value[k].name.value === 'disk_queue_depth' ||
                                    metrics_data.value[k].name.value === 'read_throughput' ||
                                    metrics_data.value[k].name.value === 'write_throughput' ||
                                    metrics_data.value[k].name.value === 'read_iops' ||
                                    metrics_data.value[k].name.value === 'write_iops') {
                                        data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 6];
                                } else {
                                    data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 1];
                                }
                            }
                        }
                        catch (error) {
                            data.errors[prepared_metrics[j]] = error.toString();
                        }
                    } 
                }
            }
            catch (error) {
                data.errors.params = error.toString();
            }
            
            if (Object.keys(data.errors).length !== 0) {
                errors = 'Failed to receive data:';
                for (var error in data.errors) {
                    errors += '\n' + error + ' : ' + data.errors[error];
                }
                data.errors = errors;
            }
            else {
                data.errors = '';
            }
            
            return JSON.stringify(data);
          description: 'The result of API requests is expressed in the JSON.'
          timeout: '{$AZURE.DATA.TIMEOUT}'
          parameters:
            -
              name: app_id
              value: '{$AZURE.APP_ID}'
            -
              name: password
              value: '{$AZURE.PASSWORD}'
            -
              name: tenant_id
              value: '{$AZURE.TENANT_ID}'
            -
              name: subscription_id
              value: '{$AZURE.SUBSCRIPTION_ID}'
            -
              name: resource_id
              value: '{$AZURE.RESOURCE_ID}'
          tags:
            -
              tag: component
              value: raw
        -
          uuid: 9fc7a458995d4ac8a4c1d8550177471d
          name: 'Azure PostgreSQL: Data disk read Bps'
          type: DEPENDENT
          key: azure.db.pgsql.disk.bps.read
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes read per second from the data disk during the monitoring period.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.read_throughput.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 46c500b44164430c952be3a1b2008fb8
          name: 'Azure PostgreSQL: Data disk write Bps'
          type: DEPENDENT
          key: azure.db.pgsql.disk.bps.write
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes written per second to the data disk during the monitoring period.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.write_throughput.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: b8812461d49a4ff5a2177c2990969c38
          name: 'Azure PostgreSQL: Data disk queue depth'
          type: DEPENDENT
          key: azure.db.pgsql.disk.queue.depth
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The number of outstanding I/O operations to the data disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.disk_queue_depth.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 10dd8ed658d8442ca39ac1decf9bc2f8
          name: 'Azure PostgreSQL: Data disk IOPS'
          type: DEPENDENT
          key: azure.db.pgsql.iops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!ops'
          description: 'I/O Operations per second.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.iops.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: dee65b110a4842ccba8e74eefc097304
          name: 'Azure PostgreSQL: Data disk read IOPS'
          type: DEPENDENT
          key: azure.db.pgsql.iops.read
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!ops'
          description: 'The number of the data disk I/O read operations per second.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.read_iops.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 805dfa040c0a4700acac4b5b1f8a4d11
          name: 'Azure PostgreSQL: Data disk write IOPS'
          type: DEPENDENT
          key: azure.db.pgsql.iops.write
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!ops'
          description: 'The number of the data disk I/O write operations per second.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.write_iops.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: d1d909c2dd0d42649094ec8339e08881
          name: 'Azure PostgreSQL: Memory utilization'
          type: DEPENDENT
          key: azure.db.pgsql.memory.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The memory percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.memory_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: memory
          triggers:
            -
              uuid: aac52a89709044ed987a365a1d5af17b
              expression: 'min(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.memory.percentage,5m)>{$AZURE.DB.MEMORY.UTIL.CRIT}'
              name: 'Azure PostgreSQL: High memory utilization'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The system is running out of free memory.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: 040898e15a26455a9992c603ca2d45df
          name: 'Azure PostgreSQL: Network out'
          type: DEPENDENT
          key: azure.db.pgsql.network.egress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network outbound traffic across the active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_egress.total
            -
              type: MULTIPLIER
              parameters:
                - '0.1333'
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 8e398d8b33444a148760ec33622755a6
          name: 'Azure PostgreSQL: Network in'
          type: DEPENDENT
          key: azure.db.pgsql.network.ingress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network inbound traffic across the active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_ingress.total
            -
              type: MULTIPLIER
              parameters:
                - '0.1333'
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: ebebf8b3a2884576abb250fdc2385c6f
          name: 'Azure PostgreSQL: Backup storage used'
          type: DEPENDENT
          key: azure.db.pgsql.storage.backup.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used backup storage expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.backup_storage_used.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 9bbfba89a1834798b71260536fedab55
          name: 'Azure PostgreSQL: Storage free'
          type: DEPENDENT
          key: azure.db.pgsql.storage.free
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Free storage space expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_free.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: d9d97e728d1741568fce925c0fca33a8
          name: 'Azure PostgreSQL: Storage percent'
          type: DEPENDENT
          key: azure.db.pgsql.storage.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The storage utilization expressed in %.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
          triggers:
            -
              uuid: de3142bed28340d9abe518cd3967b024
              expression: 'last(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.CRIT}'
              name: 'Azure PostgreSQL: Storage space is critically low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Critical utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
            -
              uuid: e948600affaa4ff4a0ab4e50f4858c0a
              expression: 'last(/Azure PostgreSQL flexible server by HTTP/azure.db.pgsql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.WARN}'
              name: 'Azure PostgreSQL: Storage space is low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'High utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
        -
          uuid: 4dae6c2c1dbf4492a73fd1834cae6aad
          name: 'Azure PostgreSQL: Transaction log storage used'
          type: DEPENDENT
          key: azure.db.pgsql.storage.txlogs.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage space used by a transaction log expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.txlogs_storage_used.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 7a85b5223ec44ff8bc996c9df1673611
          name: 'Azure PostgreSQL: Storage used'
          type: DEPENDENT
          key: azure.db.pgsql.storage.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used storage space expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_used.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 6df77ed1d4614ca793df56dbc70d821c
          name: 'Azure PostgreSQL: Maximum used transaction IDs'
          type: DEPENDENT
          key: azure.db.pgsql.txid.used.max
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The maximum number of used transaction IDs.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.maximum_used_transactionIDs.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
      tags:
        -
          tag: class
          value: software
        -
          tag: target
          value: azure
      macros:
        -
          macro: '{$AZURE.APP_ID}'
          description: 'Microsoft Azure app ID.'
        -
          macro: '{$AZURE.DATA.TIMEOUT}'
          value: 60s
          description: 'A response timeout for API.'
        -
          macro: '{$AZURE.DB.CPU.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the CPU utilization expressed in %.'
        -
          macro: '{$AZURE.DB.MEMORY.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the memory utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.CRIT}'
          value: '90'
          description: 'The critical threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.WARN}'
          value: '80'
          description: 'The warning threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.PASSWORD}'
          type: SECRET_TEXT
          description: 'Microsoft Azure password.'
        -
          macro: '{$AZURE.RESOURCE_ID}'
          description: 'Microsoft Azure virtual machine ID.'
        -
          macro: '{$AZURE.SUBSCRIPTION_ID}'
          description: 'Microsoft Azure subscription ID.'
        -
          macro: '{$AZURE.TENANT_ID}'
          description: 'Microsoft Azure tenant ID.'
      valuemaps:
        -
          uuid: f208cf6141c44659a2c6904ec4cd7ac3
          name: 'Azure resource health state'
          mappings:
            -
              value: '0'
              newvalue: Available
            -
              value: '1'
              newvalue: Degraded
            -
              value: '2'
              newvalue: Unavailable
            -
              value: '3'
              newvalue: Unknown
    -
      uuid: d023e2cd326c486f908e3e361d1fe157
      template: 'Azure PostgreSQL single server by HTTP'
      name: 'Azure PostgreSQL single server by HTTP'
      description: |
        This template is designed to monitor Microsoft Azure PostgreSQL servers by HTTP.
        It works without any external scripts and uses the script item.
        
        Setup:
          1. Create an Azure service principal via the Azure command-line interface (Azure CLI) for your subscription.
            `az ad sp create-for-rbac --name zabbix --role reader --scope /subscriptions/<subscription_id>`
            See https://docs.microsoft.com/en-us/cli/azure/create-an-azure-service-principal-azure-cli for more details.
          2. Link the template to a host.
          3. Configure macros {$AZURE.APP_ID}, {$AZURE.PASSWORD}, {$AZURE.TENANT_ID}, {$AZURE.SUBSCRIPTION_ID}, and {$AZURE.RESOURCE_ID}.
        
        You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/
        
        Template tooling version used: 0.42
      groups:
        -
          name: Templates/Cloud
      items:
        -
          uuid: 9eb43a5ffb0d4e07be8d1fccfdecd2aa
          name: 'Azure PostgreSQL: Availability status detailed'
          type: DEPENDENT
          key: azure.db.pgsql.availability.details
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The summary description of the availability status.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.summary
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: health
        -
          uuid: df4c66646f864f79b5f5e9f71dbefe82
          name: 'Azure PostgreSQL: Availability state'
          type: DEPENDENT
          key: azure.db.pgsql.availability.state
          delay: '0'
          history: 7d
          description: 'The availability status of the resource.'
          valuemap:
            name: 'Azure resource health state'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.availabilityState
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: STR_REPLACE
              parameters:
                - Available
                - '0'
            -
              type: STR_REPLACE
              parameters:
                - Degraded
                - '1'
            -
              type: STR_REPLACE
              parameters:
                - Unavailable
                - '2'
            -
              type: STR_REPLACE
              parameters:
                - Unknown
                - '3'
            -
              type: IN_RANGE
              parameters:
                - '0'
                - '3'
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: health
          triggers:
            -
              uuid: 699ca12c916746b1bf1e121261771cc3
              expression: 'last(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.availability.state)=1'
              name: 'Azure PostgreSQL: PostgreSQL server is degraded'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The resource is in degraded state.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: 14e45ba0bc26409a89d92edfda152947
              expression: 'last(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.availability.state)=3'
              name: 'Azure PostgreSQL: PostgreSQL server is in unknown state'
              opdata: '{ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'The resource state is unknown.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: 4dc9113f8a914ac098d8736dba5aed4a
              expression: 'last(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.availability.state)=2'
              name: 'Azure PostgreSQL: PostgreSQL server is unavailable'
              opdata: '{ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The resource state is unavailable.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: 3d0d3e1fe77740e4bd7b720368707214
          name: 'Azure PostgreSQL: Connections active'
          type: DEPENDENT
          key: azure.db.pgsql.connections.active
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.active_connections.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 353a6ba543a84b32b16a5809ae63b4e1
          name: 'Azure PostgreSQL: Connections failed'
          type: DEPENDENT
          key: azure.db.pgsql.connections.failed
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The count of failed connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.connections_failed.total
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 537330b2372b434ebcea8a77a809c2f3
          name: 'Azure PostgreSQL: Percentage CPU'
          type: DEPENDENT
          key: azure.db.pgsql.cpu.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The CPU percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.cpu_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: cpu
          triggers:
            -
              uuid: 33bd2ef88ad3468b9f0b2b1358cc7448
              expression: 'min(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.cpu.percentage,5m)>{$AZURE.DB.CPU.UTIL.CRIT}'
              name: 'Azure PostgreSQL: High CPU utilization'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The CPU utilization is too high. The system might be slow to respond.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: 5b132ff050c94daa92b252529a52c535
          name: 'Azure PostgreSQL: Get errors'
          type: DEPENDENT
          key: azure.db.pgsql.data.errors
          delay: '0'
          history: 7d
          trends: '0'
          value_type: TEXT
          description: 'A list of errors from API requests.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.errors
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: raw
          triggers:
            -
              uuid: dd3d0be997204f8b9968ef5839fb7a9b
              expression: 'length(last(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.data.errors))>0'
              name: 'Azure PostgreSQL: There are errors in requests to API'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Zabbix has received errors in response to API requests.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: e47d863822e64e6292bfa3e684bc2839
          name: 'Azure PostgreSQL: Get data'
          type: SCRIPT
          key: azure.db.pgsql.data.get
          history: 0d
          trends: '0'
          value_type: TEXT
          params: |
            var AzureDB = {
                params: {},
                token: null,
            
                setParams: function (params) {
                    ['app_id', 'password', 'tenant_id', 'subscription_id', 'resource_id'].forEach(function (field) {
                        if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
                            throw 'Required param is not set: ' + field + '.';
                        }
                    });
            
                    AzureDB.params = params;
                },
            
            
                request: function (url, data) {
                    if (typeof data === 'undefined' || data === null) {
                        data = '';
                    }
            
                    var response, request = new HttpRequest();
                        if (AzureDB.token) {
                            request.addHeader('Accept: application/json');
                            request.addHeader('Authorization: Bearer ' + AzureDB.token);
                        }
                
                    Zabbix.log(4, '[ Azure ] Sending request: ' + url);
            
                    if (data !== '') {
                        request.addHeader('Content-Type: application/x-www-form-urlencoded');
                        response = request.post(url, data);
                    }
                    else {
                        response = request.get(url);
                    }
            
                    Zabbix.log(4, '[ Azure ] Received response with status code ' + request.getStatus() + ': ' + response);
            
                    if (request.getStatus() !== 200 || response === null) {
                        throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
                    }
            
                    try {
                        return JSON.parse(response);
                    }
                    catch (error) {
                        throw 'Failed to parse response received from API.';
                    }
            }
            
            };
            
            var metrics = [
                'cpu_percent',
                'memory_percent',
                'io_consumption_percent',
                'storage_percent',
                'storage_used',
                'storage_limit',
                'serverlog_storage_percent',
                'serverlog_storage_usage',
                'serverlog_storage_limit',
                'active_connections',
                'connections_failed',
                'backup_storage_used',
                'network_bytes_egress',
                'network_bytes_ingress',
                'pg_replica_log_delay_in_seconds',
                'pg_replica_log_delay_in_bytes'
            ],
                prepared_metrics = [],
                data = {};
                data['errors'] = {};
                data['metrics'] = {};
            
            try {
                AzureDB.setParams(JSON.parse(value));
            
                try {
                    result = AzureDB.request(
                            'https://login.microsoftonline.com/' + encodeURIComponent(AzureDB.params.tenant_id) + '/oauth2/token',
                            'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(AzureDB.params.app_id) + '&client_secret=' + encodeURIComponent(AzureDB.params.password)
                    );
            
                    if ('access_token' in result) {
                        AzureDB.token = result['access_token'];
                    } else {
                        throw 'Auth response does not contain access token.';
                    }
                }
                catch (error) {
                    data.errors.auth = error.toString();
                }
            
                if (!('auth' in data.errors)) {
                    try {
                        health = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.ResourceHealth/availabilityStatuses?api-version=2020-05-01');
                        data.health = health.value[0].properties;
                    }
                    catch (error) {
                        data.errors.health = error.toString();
                    }
            
                    for (var i = 0; i < metrics.length; i += 20) {
                        var chunk = metrics.slice(i, i + 20);
            
                        prepared_metrics.push(
                            chunk.map(function(element) {
                                return encodeURIComponent(element);
                            }).join(',')
                        );
                    }
            
                    start_date = new Date((new Date().getTime()) - 300000).toISOString().replace(/\.\d+/, '');
                    end_date = new Date().toISOString().replace(/\.\d+/, '');
                    
                    for (var j in prepared_metrics) {
                        try {
                            metrics_data = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.Insights/metrics?metricnames=' + prepared_metrics[j] + '&timespan=' + encodeURIComponent(start_date) + '/' + encodeURIComponent(end_date) + '&api-version=2021-05-01');
                            for (k in metrics_data.value) {
                                data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 1];
                            }
                        }
                        catch (error) {
                            data.errors[prepared_metrics[j]] = error.toString();
                        }
                    } 
                }
            }
            catch (error) {
                data.errors.params = error.toString();
            }
            
            if (Object.keys(data.errors).length !== 0) {
                errors = 'Failed to receive data:';
                for (var error in data.errors) {
                    errors += '\n' + error + ' : ' + data.errors[error];
                }
                data.errors = errors;
            }
            else {
                data.errors = '';
            }
            
            return JSON.stringify(data);
          description: 'The result of API requests is expressed in the JSON.'
          timeout: '{$AZURE.DATA.TIMEOUT}'
          parameters:
            -
              name: app_id
              value: '{$AZURE.APP_ID}'
            -
              name: password
              value: '{$AZURE.PASSWORD}'
            -
              name: tenant_id
              value: '{$AZURE.TENANT_ID}'
            -
              name: subscription_id
              value: '{$AZURE.SUBSCRIPTION_ID}'
            -
              name: resource_id
              value: '{$AZURE.RESOURCE_ID}'
          tags:
            -
              tag: component
              value: raw
        -
          uuid: 9eade85c49bc462aab33b03e37581d87
          name: 'Azure PostgreSQL: IO consumption percent'
          type: DEPENDENT
          key: azure.db.pgsql.io.consumption.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The IO Percent.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.io_consumption_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: operations
        -
          uuid: e2ee4882b08f45788e6abb698265810e
          name: 'Azure PsotgreSQL: Memory utilization'
          type: DEPENDENT
          key: azure.db.pgsql.memory.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The memory percent of a host.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.memory_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: memory
          triggers:
            -
              uuid: 3119f21167a546369c05d31cda2e0147
              expression: 'min(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.memory.percentage,5m)>{$AZURE.DB.MEMORY.UTIL.CRIT}'
              name: 'Azure PsotgreSQL: High memory utilization'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The system is running out of free memory.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: f81eeb98d5e942f296c360ff71e8bf8d
          name: 'Azure PostgreSQL: Network out'
          type: DEPENDENT
          key: azure.db.pgsql.network.egress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network outbound traffic across the active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_egress.total
              error_handler: DISCARD_VALUE
            -
              type: MULTIPLIER
              parameters:
                - '0.1333'
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 51f7e35042d04ddb88c7703d1b015d3b
          name: 'Azure PosgtreSQL: Network in'
          type: DEPENDENT
          key: azure.db.pgsql.network.ingress
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'Network inbound traffic across the active connections.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.network_bytes_ingress.total
              error_handler: DISCARD_VALUE
            -
              type: MULTIPLIER
              parameters:
                - '0.1333'
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 1db9e470b527476fae1d26d4b67f855b
          name: 'Azure PostgreSQL: Replication lag'
          type: DEPENDENT
          key: azure.db.pgsql.replica.log.delay
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: s
          description: 'The replication lag expressed in seconds.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.pg_replica_log_delay_in_seconds.maximum
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: replication
        -
          uuid: 6cdfda8f9e6640f8a8536f88729d75d6
          name: 'Azure PostgreSQL: Max lag across replicas in bytes'
          type: DEPENDENT
          key: azure.db.pgsql.replica.log.delay.bytes
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Lag expressed in bytes for the most lagging replica.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.pg_replica_log_delay_in_bytes.maximum
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: replication
        -
          uuid: 6b06fb0e008640839dc3cda5bcc3f91a
          name: 'Azure PostgreSQL: Backup storage used'
          type: DEPENDENT
          key: azure.db.pgsql.storage.backup.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used backup storage expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.backup_storage_used.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: b8d5ac0b049a4d73b2f35f59c7e7609c
          name: 'Azure PostgreSQL: Storage limit'
          type: DEPENDENT
          key: azure.db.pgsql.storage.limit
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage limit expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_limit.maximum
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 750b4d3438614cc992694136d309c3cb
          name: 'Azure PostgreSQL: Storage percent'
          type: DEPENDENT
          key: azure.db.pgsql.storage.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The storage utilization expressed in %.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
          triggers:
            -
              uuid: 6538d2c8ed774feb951204308f1458ce
              expression: 'last(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.CRIT}'
              name: 'Azure PostgreSQL: Storage space is critically low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Critical utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
            -
              uuid: 7f7a004cfc2a492092dd74c475888e8b
              expression: 'last(/Azure PostgreSQL single server by HTTP/azure.db.pgsql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.WARN}'
              name: 'Azure PostgreSQL: Storage space is low'
              opdata: 'Current utilization: {ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'High utilization of the storage space.'
              tags:
                -
                  tag: scope
                  value: capacity
        -
          uuid: 399ef67426494a5cb7a820d056dfd4d5
          name: 'Azure PostgreSQL: Server log storage limit'
          type: DEPENDENT
          key: azure.db.pgsql.storage.server.log.limit
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage limit of a server log expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.serverlog_storage_limit.maximum
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: ef6890330ebe4fe09f46b0d2f6d3f827
          name: 'Azure PostgreSQL: Server log storage percent'
          type: DEPENDENT
          key: azure.db.pgsql.storage.server.log.percent
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The storage utilization by a server log expressed in %.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.serverlog_storage_percent.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 36bd10a959964083ae47349dd83ec695
          name: 'Azure PostgreSQL: Server log storage used'
          type: DEPENDENT
          key: azure.db.pgsql.storage.server.log.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'The storage space used by a server log expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.serverlog_storage_usage.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: dcbb87d442a04938b23e68f739f1e36f
          name: 'Azure PostgreSQL: Storage used'
          type: DEPENDENT
          key: azure.db.pgsql.storage.used
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: B
          description: 'Used storage space expressed in bytes.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.storage_used.average
          master_item:
            key: azure.db.pgsql.data.get
          tags:
            -
              tag: component
              value: storage
      tags:
        -
          tag: class
          value: software
        -
          tag: target
          value: azure
      macros:
        -
          macro: '{$AZURE.APP_ID}'
          description: 'Microsoft Azure app ID.'
        -
          macro: '{$AZURE.DATA.TIMEOUT}'
          value: 60s
          description: 'A response timeout for API.'
        -
          macro: '{$AZURE.DB.CPU.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the CPU utilization expressed in %.'
        -
          macro: '{$AZURE.DB.MEMORY.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the memory utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.CRIT}'
          value: '90'
          description: 'The critical threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.DB.STORAGE.PUSED.WARN}'
          value: '80'
          description: 'The warning threshold of the storage utilization expressed in %.'
        -
          macro: '{$AZURE.PASSWORD}'
          type: SECRET_TEXT
          description: 'Microsoft Azure password.'
        -
          macro: '{$AZURE.RESOURCE_ID}'
          description: 'Microsoft Azure virtual machine ID.'
        -
          macro: '{$AZURE.SUBSCRIPTION_ID}'
          description: 'Microsoft Azure subscription ID.'
        -
          macro: '{$AZURE.TENANT_ID}'
          description: 'Microsoft Azure tenant ID.'
      valuemaps:
        -
          uuid: 61fc206aaae04abda4012e031f0e27ac
          name: 'Azure resource health state'
          mappings:
            -
              value: '0'
              newvalue: Available
            -
              value: '1'
              newvalue: Degraded
            -
              value: '2'
              newvalue: Unavailable
            -
              value: '3'
              newvalue: Unknown
    -
      uuid: 820fa4a1565c43e4aac07a691a5bface
      template: 'Azure virtual machine by HTTP'
      name: 'Azure virtual machine by HTTP'
      description: |
        This template is designed to monitor Microsoft Azure virtual machines by HTTP.
        It works without any external scripts and uses the script item.
        
        Setup:
          1. Create an Azure service principal via the Azure command-line interface (Azure CLI) for your subscription.
            `az ad sp create-for-rbac --name zabbix --role reader --scope /subscriptions/<subscription_id>`
            See https://docs.microsoft.com/en-us/cli/azure/create-an-azure-service-principal-azure-cli for more details.
          2. Link the template to a host.
          3. Configure macros {$AZURE.APP_ID}, {$AZURE.PASSWORD}, {$AZURE.TENANT_ID}, {$AZURE.SUBSCRIPTION_ID}, and {$AZURE.RESOURCE_ID}.
        
        You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/
        
        Template tooling version used: 0.42
      groups:
        -
          name: Templates/Cloud
      items:
        -
          uuid: c299999d69904340acd44fead6c7672c
          name: 'Azure: Availability status detailed'
          type: DEPENDENT
          key: azure.vm.availability.details
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          description: 'The summary description of the availability status.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.summary
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: health
        -
          uuid: 25e2af44bfbf4e9083ce493d85232088
          name: 'Azure: Availability state'
          type: DEPENDENT
          key: azure.vm.availability.state
          delay: '0'
          history: 7d
          description: 'The availability status of the resource.'
          valuemap:
            name: 'Azure resource health state'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.health.availabilityState
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: STR_REPLACE
              parameters:
                - Available
                - '0'
            -
              type: STR_REPLACE
              parameters:
                - Degraded
                - '1'
            -
              type: STR_REPLACE
              parameters:
                - Unavailable
                - '2'
            -
              type: STR_REPLACE
              parameters:
                - Unknown
                - '3'
            -
              type: IN_RANGE
              parameters:
                - '0'
                - '3'
              error_handler: CUSTOM_VALUE
              error_handler_params: '3'
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: health
          triggers:
            -
              uuid: c0170d8a09ae460da923fe773b2b0bd0
              expression: 'last(/Azure virtual machine by HTTP/azure.vm.availability.state)=1'
              name: 'Azure: Virtual machine is degraded'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'The resource is in degraded state.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: e1b85765b83445ebbf15f02d782b9858
              expression: 'last(/Azure virtual machine by HTTP/azure.vm.availability.state)=3'
              name: 'Azure: Virtual machine is in unknown state'
              opdata: '{ITEM.LASTVALUE1}'
              priority: WARNING
              description: 'The resource state is unknown.'
              tags:
                -
                  tag: scope
                  value: availability
            -
              uuid: b3d764ff735e44f8806cc4d29090719e
              expression: 'last(/Azure virtual machine by HTTP/azure.vm.availability.state)=2'
              name: 'Azure: Virtual machine is unavailable'
              opdata: '{ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The resource state is unavailable.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: a93308573303437487d151de340fcaed
          name: 'Azure: VM cached bandwidth consumed percentage'
          type: DEPENDENT
          key: azure.vm.cached.bandwidth.consumed.percentage
          delay: '0'
          history: 7d
          units: '%'
          description: 'Percentage of cached disk bandwidth consumed by the VM.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.VMCachedBandwidthConsumedPercentage.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 989dec26d97d44b6bd4a84fdbd37dec5
          name: 'Azure: VM cached IOPS consumed percentage'
          type: DEPENDENT
          key: azure.vm.cached.iops.consumed.percentage
          delay: '0'
          history: 7d
          units: '%'
          description: 'Percentage of cached disk IOPS consumed by the VM.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.VMCachedIOPSConsumedPercentage.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: fb0641ca8f104cf1bebdced63cd6af16
          name: 'Azure: CPU credits consumed'
          type: DEPENDENT
          key: azure.vm.cpu.credits.consumed
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The total number of credits consumed by the Virtual Machine. Only available on B-series burstable VMs.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.CPUCreditsConsumed.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: cpu
        -
          uuid: 963752cbaba046cab1f05b0cbcff3137
          name: 'Azure: CPU credits remaining'
          type: DEPENDENT
          key: azure.vm.cpu.credits.remaining
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The total number of credits available to burst. Only available on B-series burstable VMs.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.CPUCreditsRemaining.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: cpu
        -
          uuid: 492edacf92544a95a5aa7b034efa7931
          name: 'Azure: Percentage CPU'
          type: DEPENDENT
          key: azure.vm.cpu.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of allocated compute units that are currently in use by the Virtual Machine(s).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.PercentageCPU.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: cpu
          triggers:
            -
              uuid: 9e6d9394570641418b4291befb1e38e5
              expression: 'min(/Azure virtual machine by HTTP/azure.vm.cpu.percentage,5m)>{$AZURE.VM.CPU.UTIL.CRIT}'
              name: 'Azure: High CPU utilization'
              opdata: '{ITEM.LASTVALUE1}'
              priority: HIGH
              description: 'The CPU utilization is too high. The system might be slow to respond.'
              tags:
                -
                  tag: scope
                  value: performance
        -
          uuid: 47cda13c203e4f1e9918eb73fd8afa20
          name: 'Azure: Data disk bandwidth consumed percentage'
          type: DEPENDENT
          key: azure.vm.data.disk.bandwidth.consumed.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of the Data Disk bandwidth consumed per minute.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskBandwidthConsumedPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 3121980d3319431691ed9e98d176430b
          name: 'Azure: Data disk IOPS consumed percentage'
          type: DEPENDENT
          key: azure.vm.data.disk.iops.consumed.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of the Data Disk I/Os consumed per minute.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskIOPSConsumedPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: d0fb23206d564e1da746bff3369056c1
          name: 'Azure: Data disk max burst bandwidth'
          type: DEPENDENT
          key: azure.vm.data.disk.max.bandwidth
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Maximum bytes per second throughput Data Disk can achieve with bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskMaxBurstBandwidth.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 6afcbb02c53243faa341670f155678e4
          name: 'Azure: Data disk max burst IOPS'
          type: DEPENDENT
          key: azure.vm.data.disk.max.iops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'Maximum IOPS Data Disk can achieve with bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskMaxBurstIOPS.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: b81f304bbc2a42df9b0550ecdc1ec6b7
          name: 'Azure: Data disk queue depth'
          type: DEPENDENT
          key: azure.vm.data.disk.queue.depth
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The queue depth (or queue length) of the Data Disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskQueueDepth.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 021d92f3075544319191d6f85a701222
          name: 'Azure: Data disk read rate'
          type: DEPENDENT
          key: azure.vm.data.disk.read.bps
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes/Sec read from a single disk during the monitoring period.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskReadBytessec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: cc31283ab96548b7bdcc88e89dfae53c
          name: 'Azure: Data disk read operations/sec'
          type: DEPENDENT
          key: azure.vm.data.disk.read.ops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'The read IOPS from a single disk during the monitoring period.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskReadOperationsSec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: c61ad4af97c243cca75bbece40eea795
          name: 'Azure: Data disk target bandwidth'
          type: DEPENDENT
          key: azure.vm.data.disk.target.bandwidth
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Baseline bytes per second throughput Data Disk can achieve without bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskTargetBandwidth.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 9370988456e74b889700ea5798d17092
          name: 'Azure: Data disk target IOPS'
          type: DEPENDENT
          key: azure.vm.data.disk.target.iops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'Baseline IOPS Data Disk can achieve without bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskTargetIOPS.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 68c730e4904f402cb12fb71b45fede02
          name: 'Azure: Data disk used burst BPS credits percentage'
          type: DEPENDENT
          key: azure.vm.data.disk.used.burst.bandwidth
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of the Data Disk burst bandwidth credits used so far.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskUsedBurstBPSCreditsPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 731a82833bdd42c59c453adf8625e3b4
          name: 'Azure: Data disk used burst IO credits percentage'
          type: DEPENDENT
          key: azure.vm.data.disk.used.burst.iops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of the Data Disk burst I/O credits used so far.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskUsedBurstIOCreditsPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: b8712f8fd60a43f6b099d9eafed19945
          name: 'Azure: Data disk write rate'
          type: DEPENDENT
          key: azure.vm.data.disk.write.bps
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes/Sec written to a single disk during the monitoring period.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskWriteBytessec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 87794f5a502b4e2db91f820483e38fb3
          name: 'Azure: Data disk write operations/sec'
          type: DEPENDENT
          key: azure.vm.data.disk.write.ops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'The write IOPS from a single disk during the monitoring period.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DataDiskWriteOperationsSec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: e253c2a908944be1a033fc3df550d979
          name: 'Azure: Get errors'
          type: DEPENDENT
          key: azure.vm.data.errors
          delay: '0'
          history: 7d
          trends: '0'
          value_type: TEXT
          description: 'A list of errors from API requests.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.errors
            -
              type: DISCARD_UNCHANGED_HEARTBEAT
              parameters:
                - 1h
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: raw
          triggers:
            -
              uuid: 87236c99652643ba800601a461d66d94
              expression: 'length(last(/Azure virtual machine by HTTP/azure.vm.data.errors))>0'
              name: 'Azure: There are errors in requests to API'
              opdata: '{ITEM.LASTVALUE1}'
              priority: AVERAGE
              description: 'Zabbix has received errors in response to API requests.'
              tags:
                -
                  tag: scope
                  value: availability
        -
          uuid: cff54514d795495da8bc1152e02631aa
          name: 'Azure: Get data'
          type: SCRIPT
          key: azure.vm.data.get
          history: 0d
          trends: '0'
          value_type: TEXT
          params: |
            var AzureVM = {
                params: {},
                token: null,
            
                setParams: function (params) {
                    ['app_id', 'password', 'tenant_id', 'subscription_id', 'resource_id'].forEach(function (field) {
                        if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
                            throw 'Required param is not set: ' + field + '.';
                        }
                    });
            
                    AzureVM.params = params;
                },
            
            
                request: function (url, data) {
                    if (typeof data === 'undefined' || data === null) {
                        data = '';
                    }
            
                    var response, request = new HttpRequest();
                        if (AzureVM.token) {
                            request.addHeader('Accept: application/json');
                            request.addHeader('Authorization: Bearer ' + AzureVM.token);
                        }
                
                    Zabbix.log(4, '[ Azure ] Sending request: ' + url);
            
                    if (data !== '') {
                        request.addHeader('Content-Type: application/x-www-form-urlencoded');
                        response = request.post(url, data);
                    }
                    else {
                        response = request.get(url);
                    }
            
                    Zabbix.log(4, '[ Azure ] Received response with status code ' + request.getStatus() + ': ' + response);
            
                    if (request.getStatus() !== 200 || response === null) {
                        throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
                    }
            
                    try {
                        return JSON.parse(response);
                    }
                    catch (error) {
                        throw 'Failed to parse response received from API.';
                    }
            }
            
            };
            
            var metrics = [
                'Percentage CPU',
                'Network In',
                'Network Out',
                'Disk Read Bytes',
                'Disk Write Bytes',
                'Disk Read Operations/Sec',
                'Disk Write Operations/Sec',
                'CPU Credits Remaining',
                'CPU Credits Consumed',
                'Data Disk Read Bytes/sec',
                'Data Disk Write Bytes/sec',
                'Data Disk Read Operations/Sec',
                'Data Disk Write Operations/Sec',
                'Data Disk Queue Depth',
                'Data Disk Bandwidth Consumed Percentage',
                'Data Disk IOPS Consumed Percentage',
                'Data Disk Target Bandwidth',
                'Data Disk Target IOPS',
                'Data Disk Max Burst Bandwidth',
                'Data Disk Max Burst IOPS',
                'Data Disk Used Burst BPS Credits Percentage',
                'Data Disk Used Burst IO Credits Percentage',
                'OS Disk Read Bytes/sec',
                'OS Disk Write Bytes/sec',
                'OS Disk Read Operations/Sec',
                'OS Disk Write Operations/Sec',
                'OS Disk Queue Depth',
                'OS Disk Bandwidth Consumed Percentage',
                'OS Disk IOPS Consumed Percentage',
                'OS Disk Target Bandwidth',
                'OS Disk Target IOPS',
                'OS Disk Max Burst Bandwidth',
                'OS Disk Max Burst IOPS',
                'OS Disk Used Burst BPS Credits Percentage',
                'OS Disk Used Burst IO Credits Percentage',
                'Inbound Flows',
                'Outbound Flows',
                'Inbound Flows Maximum Creation Rate',
                'Outbound Flows Maximum Creation Rate',
                'Premium Data Disk Cache Read Hit',
                'Premium Data Disk Cache Read Miss',
                'Premium OS Disk Cache Read Hit',
                'Premium OS Disk Cache Read Miss',
                'VM Cached Bandwidth Consumed Percentage',
                'VM Cached IOPS Consumed Percentage',
                'VM Uncached Bandwidth Consumed Percentage',
                'VM Uncached IOPS Consumed Percentage',
                'Network In Total',
                'Network Out Total',
                'Available Memory Bytes'
            ],
                prepared_metrics = [],
                data = {};
                data['errors'] = {};
                data['metrics'] = {};
            
            try {
                AzureVM.setParams(JSON.parse(value));
            
                try {
                    result = AzureVM.request(
                            'https://login.microsoftonline.com/' + encodeURIComponent(AzureVM.params.tenant_id) +'/oauth2/token',
                            'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(AzureVM.params.app_id) + '&client_secret=' + encodeURIComponent(AzureVM.params.password)
                    );
            
                    if ('access_token' in result) {
                        AzureVM.token = result['access_token'];
                    } else {
                        throw 'Auth response does not contain access token.';
                    }
                }
                catch (error) {
                    data.errors.auth = error.toString();
                }
            
                if (!('auth' in data.errors)) {
                    try {
                        health = AzureVM.request('https://management.azure.com' + AzureVM.params.resource_id + '/providers/Microsoft.ResourceHealth/availabilityStatuses?api-version=2020-05-01');
                        data.health = health.value[0].properties;
                    }
                    catch (error) {
                        data.errors.health = error.toString();
                    }
            
                    for (var i = 0; i < metrics.length; i += 20) {
                        var chunk = metrics.slice(i, i + 20);
            
                        prepared_metrics.push(
                            chunk.map(function(element) {
                                return encodeURIComponent(element);
                            }).join(',')
                        );
                    }
            
                    start_date = new Date((new Date().getTime()) - 300000).toISOString().replace(/\.\d+/, '');
                    end_date = new Date().toISOString().replace(/\.\d+/, '');
                    
                    for (var j in prepared_metrics) {
                        try {
                            metrics_data = AzureVM.request('https://management.azure.com' + AzureVM.params.resource_id + '/providers/Microsoft.Insights/metrics?metricnames=' + prepared_metrics[j] + '&timespan=' + encodeURIComponent(start_date) + '/' + encodeURIComponent(end_date) + '&api-version=2021-05-01');
                            for (k in metrics_data.value) {
                                data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 3];
                            }
                        }
                        catch (error) {
                            data.errors[prepared_metrics[j]] = error.toString();
                        }
                    } 
                }
            }
            catch (error) {
                data.errors.params = error.toString();
            }
            
            if (Object.keys(data.errors).length !== 0) {
                errors = 'Failed to receive data:';
                for (var error in data.errors) {
                    errors += '\n' + error + ' : ' + data.errors[error];
                }
                data.errors = errors;
            }
            else {
                data.errors = '';
            }
            
            return JSON.stringify(data);
          description: 'The result of API requests is expressed in the JSON.'
          timeout: '{$AZURE.DATA.TIMEOUT}'
          parameters:
            -
              name: app_id
              value: '{$AZURE.APP_ID}'
            -
              name: password
              value: '{$AZURE.PASSWORD}'
            -
              name: tenant_id
              value: '{$AZURE.TENANT_ID}'
            -
              name: subscription_id
              value: '{$AZURE.SUBSCRIPTION_ID}'
            -
              name: resource_id
              value: '{$AZURE.RESOURCE_ID}'
          tags:
            -
              tag: component
              value: raw
        -
          uuid: 1dc9f8d45b6f48a38f701f089cbcb279
          name: 'Azure: Disk read rate'
          type: DEPENDENT
          key: azure.vm.disk.read.bytes
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes read from the disk during the monitoring period (1 minute).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DiskReadBytes.total
            -
              type: MULTIPLIER
              parameters:
                - '0.0167'
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: cd3240d31a4f42a89b5c9817ea288b5a
          name: 'Azure: Disk read Operations/Sec'
          type: DEPENDENT
          key: azure.vm.disk.read.ops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'The count of read operations from the disk per second.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DiskReadOperationsSec.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: b5e2070bde1444ea809ba4e0a29b05d9
          name: 'Azure: Disk write rate'
          type: DEPENDENT
          key: azure.vm.disk.write.bytes
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes written to the disk during the monitoring period (1 minute).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DiskWriteBytes.total
            -
              type: MULTIPLIER
              parameters:
                - '0.0167'
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 0d93d1b510614c1f83418bd481f1e7cb
          name: 'Azure: Disk write Operations/Sec'
          type: DEPENDENT
          key: azure.vm.disk.write.ops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'The count of write operations to the disk per second.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.DiskWriteOperationsSec.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 3a30a59aabd54c8b8feb1f4a8ba06db5
          name: 'Azure: Inbound flows'
          type: DEPENDENT
          key: azure.vm.flows.inbound
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Inbound Flows are number of the current flows in the inbound direction (traffic going into the VM).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.InboundFlows.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 3964ffbb7ea949f69863edcf91f5c555
          name: 'Azure: Inbound flows max creation rate'
          type: DEPENDENT
          key: azure.vm.flows.inbound.max
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The maximum creation rate of the inbound flows (traffic going into the VM).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.InboundFlowsMaximumCreationRate.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 2084cb1d010a4ab494c0826c458d922a
          name: 'Azure: Outbound flows'
          type: DEPENDENT
          key: azure.vm.flows.outbound
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'Outbound Flows are number of the current flows in the outbound direction (traffic going out of the VM).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OutboundFlows.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: eac3e6b53d394e3289fc03bf5772799c
          name: 'Azure: Outbound flows max creation rate'
          type: DEPENDENT
          key: azure.vm.flows.outbound.max
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The maximum creation rate of the outbound flows (traffic going out of the VM).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OutboundFlowsMaximumCreationRate.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 0a354c9b104b468d9749adfd28d1373e
          name: 'Azure: Available memory'
          type: DEPENDENT
          key: azure.vm.memory.available
          delay: '0'
          history: 7d
          units: B
          description: 'The amount of physical memory, in bytes, immediately available for allocation to a process or for system use in the Virtual Machine.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.AvailableMemoryBytes.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: memory
        -
          uuid: 411c5f6fcb374c4c90e2951a546c0c08
          name: 'Azure: Network in total'
          type: DEPENDENT
          key: azure.vm.network.in.total
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'The number of bytes received on all network interfaces by the Virtual Machine(s) (Incoming Traffic).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.NetworkInTotal.total
              error_handler: DISCARD_VALUE
            -
              type: MULTIPLIER
              parameters:
                - '0.1333'
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: ee2ef1d1e2844ae8be2a5f04c86631ba
          name: 'Azure: Network out total'
          type: DEPENDENT
          key: azure.vm.network.out.total
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: bps
          description: 'The number of bytes out on all network interfaces by the Virtual Machine(s) (Outgoing Traffic).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.NetworkOutTotal.total
              error_handler: DISCARD_VALUE
            -
              type: MULTIPLIER
              parameters:
                - '0.1333'
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: network
        -
          uuid: 24c58e473c5c4b8388a0e78ae38378fc
          name: 'Azure: OS disk bandwidth consumed percentage'
          type: DEPENDENT
          key: azure.vm.os.disk.bandwidth.consumed.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of the operating system disk bandwidth consumed per minute.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskBandwidthConsumedPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 33a7fff9758046e3be07dad6c0a710ca
          name: 'Azure: OS disk IOPS consumed percentage'
          type: DEPENDENT
          key: azure.vm.os.disk.iops.consumed.percentage
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of the operating system disk I/Os consumed per minute.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskIOPSConsumedPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 7d0ca132bc264ac08e3c55809bdc40d1
          name: 'Azure: OS disk max burst bandwidth'
          type: DEPENDENT
          key: azure.vm.os.disk.max.bandwidth
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Maximum bytes per second throughput OS Disk can achieve with bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskMaxBurstBandwidth.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 8374282688dc4fabb770c07eb335c666
          name: 'Azure: OS disk max burst IOPS'
          type: DEPENDENT
          key: azure.vm.os.disk.max.iops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'Maximum IOPS OS Disk can achieve with bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskMaxBurstIOPS.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: ca8fe9d0ea58482c9bb8b83a716362a2
          name: 'Azure: OS disk queue depth'
          type: DEPENDENT
          key: azure.vm.os.disk.queue.depth
          delay: '0'
          history: 7d
          value_type: FLOAT
          description: 'The OS disk queue depth (or queue length).'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskQueueDepth.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 30265aac759d45769769eae081f570ac
          name: 'Azure: OS disk read rate'
          type: DEPENDENT
          key: azure.vm.os.disk.read.bps
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes/Sec read from a single disk during the monitoring period for OS disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskReadBytessec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: f11fcbbd63234993a9c301dc8bac3e80
          name: 'Azure: OS disk read operations/sec'
          type: DEPENDENT
          key: azure.vm.os.disk.read.ops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'The read IOPS from a single disk during the monitoring period for OS disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskReadOperationsSec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 5cc422b7da3145fa885a88bb6165e3b9
          name: 'Azure: OS disk target bandwidth'
          type: DEPENDENT
          key: azure.vm.os.disk.target.bandwidth
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Baseline bytes per second throughput OS Disk can achieve without bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskTargetBandwidth.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 556941b1df5d470f8de628230b085623
          name: 'Azure: OS disk target IOPS'
          type: DEPENDENT
          key: azure.vm.os.disk.target.iops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'Baseline IOPS OS Disk can achieve without bursting.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskTargetIOPS.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 9d42609950864c899a0d63b94f1d2235
          name: 'Azure: OS disk used burst BPS credits percentage'
          type: DEPENDENT
          key: azure.vm.os.disk.used.burst.bandwidth
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'The percentage of the OS Disk burst bandwidth credits used so far.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskUsedBurstBPSCreditsPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: c08f45df2e594e1fab01ba63df7da05b
          name: 'Azure: OS disk used burst IO credits percentage'
          type: DEPENDENT
          key: azure.vm.os.disk.used.burst.iops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '%'
          description: 'Percentage of OS Disk burst I/O credits used so far.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskUsedBurstIOCreditsPercentage.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 7645519a786b42908f1ec693128899c2
          name: 'Azure: OS disk write rate'
          type: DEPENDENT
          key: azure.vm.os.disk.write.bps
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: Bps
          description: 'Bytes/Sec written to a single disk during the monitoring period for OS disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskWriteBytessec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 1e9392bc0c934e7d93f743c86e36e23e
          name: 'Azure: OS disk write operations/sec'
          type: DEPENDENT
          key: azure.vm.os.disk.write.ops
          delay: '0'
          history: 7d
          value_type: FLOAT
          units: '!iops'
          description: 'The write IOPS from a single disk during the monitoring period for OS disk.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.OSDiskWriteOperationsSec.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: d6fcff826cfa486d945f33708be2f630
          name: 'Azure: Premium data disk cache read hit'
          type: DEPENDENT
          key: azure.vm.premium.data.disk.cache.read.hit
          delay: '0'
          history: 7d
          units: '%'
          description: 'Premium Data Disk cache read hit.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.PremiumDataDiskCacheReadHit.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 288853ee5d08442fa43f8df1dfcc7823
          name: 'Azure: Premium data disk cache read miss'
          type: DEPENDENT
          key: azure.vm.premium.data.disk.cache.read.miss
          delay: '0'
          history: 7d
          units: '%'
          description: 'Premium Data Disk cache read miss.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.PremiumDataDiskCacheReadMiss.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 66b629ae3d7e4abeaf0282414c91876f
          name: 'Azure: Premium OS disk cache read hit'
          type: DEPENDENT
          key: azure.vm.premium.os.disk.cache.read.hit
          delay: '0'
          history: 7d
          units: '%'
          description: 'Premium OS disk cache read hit.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.PremiumOSDiskCacheReadHit.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 3927f34d5d0649d7ac29703f64054dbf
          name: 'Azure: Premium OS disk cache read miss'
          type: DEPENDENT
          key: azure.vm.premium.os.disk.cache.read.miss
          delay: '0'
          history: 7d
          units: '%'
          description: 'Premium OS disk cache read miss.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.PremiumOSDiskCacheReadMiss.average
              error_handler: DISCARD_VALUE
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: d6e85395e34b4288988a5287d287f182
          name: 'Azure: VM uncached bandwidth consumed percentage'
          type: DEPENDENT
          key: azure.vm.uncached.bandwidth.consumed.percentage
          delay: '0'
          history: 7d
          units: '%'
          description: 'The percentage of the uncached disk bandwidth consumed by the VM.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.VMUncachedBandwidthConsumedPercentage.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
        -
          uuid: 124203560922429bb32b76c45f24b2b9
          name: 'Azure: VM uncached IOPS consumed percentage'
          type: DEPENDENT
          key: azure.vm.uncached.iops.consumed.percentage
          delay: '0'
          history: 7d
          units: '%'
          description: 'The percentage of the uncached disk IOPS consumed by the VM.'
          preprocessing:
            -
              type: JSONPATH
              parameters:
                - $.metrics.VMUncachedIOPSConsumedPercentage.average
          master_item:
            key: azure.vm.data.get
          tags:
            -
              tag: component
              value: storage
      tags:
        -
          tag: class
          value: software
        -
          tag: target
          value: azure
      macros:
        -
          macro: '{$AZURE.APP_ID}'
          description: 'Microsoft Azure app ID.'
        -
          macro: '{$AZURE.DATA.TIMEOUT}'
          value: 60s
          description: 'A response timeout for API.'
        -
          macro: '{$AZURE.PASSWORD}'
          type: SECRET_TEXT
          description: 'Microsoft Azure password.'
        -
          macro: '{$AZURE.RESOURCE_ID}'
          description: 'Microsoft Azure virtual machine ID.'
        -
          macro: '{$AZURE.SUBSCRIPTION_ID}'
          description: 'Microsoft Azure subscription ID.'
        -
          macro: '{$AZURE.TENANT_ID}'
          description: 'Microsoft Azure tenant ID.'
        -
          macro: '{$AZURE.VM.CPU.UTIL.CRIT}'
          value: '90'
          description: 'The critical threshold of the CPU utilization expressed in %.'
      valuemaps:
        -
          uuid: 38c8ce1516704ec2a6f1ea9686db56b9
          name: 'Azure resource health state'
          mappings:
            -
              value: '0'
              newvalue: Available
            -
              value: '1'
              newvalue: Degraded
            -
              value: '2'
              newvalue: Unavailable
            -
              value: '3'
              newvalue: Unknown
  graphs:
    -
      uuid: 781dd83ed494465bbf2c16efbc753a51
      name: 'Azure: Data disk read/write bytes'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.data.disk.read.bps
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.data.disk.write.bps
    -
      uuid: 7d198b2f6186498ab39ece80f3f7b30e
      name: 'Azure: Data disk read/write rates'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.data.disk.read.ops
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.data.disk.write.ops
    -
      uuid: a2d0eb282276486896067f8a30f8ea51
      name: 'Azure: Disk read/write bytes'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.disk.read.bytes
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.disk.write.bytes
    -
      uuid: 58a8c6942314408ab0e88b15d53f67e5
      name: 'Azure: Disk read/write rates'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.disk.read.ops
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.disk.write.ops
    -
      uuid: b427ad3dbb8d4f8caf1edfb0cab04733
      name: 'Azure: Flows'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.flows.inbound
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.flows.outbound
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.flows.inbound.max
        -
          sortorder: '3'
          color: A54F10
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.flows.outbound.max
    -
      uuid: f0f37dc8840a45ba8e8cb62f5fea6804
      name: 'Azure: Network traffic'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.network.in.total
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.network.out.total
    -
      uuid: 41bd1642704c4d3fbe4fb34c8c389320
      name: 'Azure: OS disk read/write bytes'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.os.disk.read.bps
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.os.disk.write.bps
    -
      uuid: df77fe1de4ae46f98744ff73ed427b3b
      name: 'Azure: OS disk read/write rates'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.os.disk.read.ops
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.os.disk.write.ops
    -
      uuid: 3051d683b44b48ee94030465254abc7f
      name: 'Azure: Premium data disk cache read'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.premium.data.disk.cache.read.hit
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.premium.data.disk.cache.read.miss
    -
      uuid: d727dc11deaa46b282892552c9b03752
      name: 'Azure: Premium OS disk cache read'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.premium.os.disk.cache.read.hit
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure virtual machine by HTTP'
            key: azure.vm.premium.os.disk.cache.read.miss
    -
      uuid: 750ae48e6ef749c19a06f4bbe716f92f
      name: 'Azure MySQL: Connections'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure MySQL flexible server by HTTP'
            key: azure.db.mysql.connections.active
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure MySQL flexible server by HTTP'
            key: azure.db.mysql.connections.total
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'Azure MySQL flexible server by HTTP'
            key: azure.db.mysql.connections.aborted
    -
      uuid: 360a24b56be74cf48df3135008437824
      name: 'Azure MySQL: Connections'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.connections.active
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.connections.failed
    -
      uuid: f929f47602734f82a79f22a5f4446f61
      name: 'Azure MySQL: Network traffic'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure MySQL flexible server by HTTP'
            key: azure.db.mysql.network.egress
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure MySQL flexible server by HTTP'
            key: azure.db.mysql.network.ingress
    -
      uuid: dc6840162405481ebc1c3c98fdfcaef1
      name: 'Azure MySQL: Network traffic'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.network.egress
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.network.ingress
    -
      uuid: 3fcf43fd338e4902874d940fc0bec8b9
      name: 'Azure MySQL: Server log storage utilization'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.storage.server.log.used
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.storage.server.log.limit
    -
      uuid: bdc178e6faaa4850badc0c60c7c80d40
      name: 'Azure MySQL: Storage utilization'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.storage.used
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure MySQL single server by HTTP'
            key: azure.db.mysql.storage.limit
    -
      uuid: 4210e6b4ed8744589dce88217e961a56
      name: 'Azure MySQL: Storage utilization'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure MySQL flexible server by HTTP'
            key: azure.db.mysql.storage.used
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure MySQL flexible server by HTTP'
            key: azure.db.mysql.storage.limit
    -
      uuid: 2b60e8b1fd7c43f4ac61812e43c0e1ca
      name: 'Azure PostgreSQL: Connections'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure PostgreSQL flexible server by HTTP'
            key: azure.db.pgsql.connections.active
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure PostgreSQL flexible server by HTTP'
            key: azure.db.pgsql.connections.succeeded
        -
          sortorder: '2'
          color: F63100
          item:
            host: 'Azure PostgreSQL flexible server by HTTP'
            key: azure.db.pgsql.connections.failed
    -
      uuid: c76cf8ec6a584af6be815ec4a9257a8c
      name: 'Azure PostgreSQL: Connections'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.connections.active
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.connections.failed
    -
      uuid: a4679d243b574bea84397c980723c68b
      name: 'Azure PostgreSQL: Network traffic'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure PostgreSQL flexible server by HTTP'
            key: azure.db.pgsql.network.egress
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure PostgreSQL flexible server by HTTP'
            key: azure.db.pgsql.network.ingress
    -
      uuid: 8bc17d843775414ea971e640e1fe5ec0
      name: 'Azure PostgreSQL: Network traffic'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.network.egress
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.network.ingress
    -
      uuid: 9e750a5a462b4429ac5a36a72bd60c66
      name: 'Azure PostgreSQL: Server log storage utilization'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.storage.server.log.used
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.storage.server.log.limit
    -
      uuid: 5fa13cfbdd784475818fae06ff94f879
      name: 'Azure PostgreSQL: Storage utilization'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure PostgreSQL flexible server by HTTP'
            key: azure.db.pgsql.storage.used
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure PostgreSQL flexible server by HTTP'
            key: azure.db.pgsql.storage.free
    -
      uuid: 9ecd071a77364c4486fa5f63125cd985
      name: 'Azure PostgreSQL: Storage utilization'
      graph_items:
        -
          color: 1A7C11
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.storage.used
        -
          sortorder: '1'
          color: 2774A4
          item:
            host: 'Azure PostgreSQL single server by HTTP'
            key: azure.db.pgsql.storage.limit