-
Problem report
-
Resolution: Unresolved
-
Major
-
None
-
7.0.19rc1
-
Zabbix 7.0LTS, any db engine, any web-server
-
Support backlog
Hello,
While working with Zabbix 7.0LTS it was discovered that GCP template does not allow to discover entities of SQL instances which have auditlog disabled:
https://cloud.google.com/sql/docs/sqlserver/db-audit
javascript preprocessing from template which create an issue (item with key gcp.cloudsql.instances.get):
if (obj.db_type.match(/SQLSERVER*/)) { var mssql_audit = getField(sql_inst, 'settings.sqlServerAuditConfig'); obj.audited = (mssql_audit.bucket) ? true : false; }
If for example SQL instance in GCP does not have auditing enabled, and GCP does not return information about it preprocessing would fail with error code:
Preprocessing failed for: .... 1. Failed: Required field "settings.sqlServerAuditConfig" is not present in data recieved
Removing line of preprocessing mentioned above solves issue, and SQL instance/instances are discovered
Is it possible to create any sort of filter, or edit javascript to also match entries which does not have "settings.sqlServerAuditConfig" field?