Manual Execution
For manual runs, credentials can be placed directly in the configuration file. Filters are optional and accept multiple exact values separated with ;.
[CONF]
tenant_id=11111111-1111-1111-1111-111111111111
subscription_id=00000000-0000-0000-0000-000000000000
client_id=22222222-2222-2222-2222-222222222222
client_secret=my_client_secret
resource_group=rg-production;rg-development
server_name=sql-production;sql-development
database_name=appdb;billing
agent_per_database=1
agent_autodisable=0
interval=300
group_id=10
timeout=30
entities_list=/tmp/tmp_discovery.azure_sql.entities
enable_entities_interval=0
entities_interval=86400
skip_master_database=1
performance_metrics_enabled=1
storage_metrics_enabled=1
connection_metrics_enabled=1
tempdb_xtp_metrics_enabled=1
deadlock_metrics_enabled=1
./pandora_azure_sql --conf /etc/pandora/azure_sql.conf
The plugin returns JSON containing the summary and monitoring_data fields.