The OOTB pattern "Azure DataBase" has an Identification Section called "Azure DataBase" which uses a shared library "Azure - Databases instances to Database". The first step (56.1) in this shared library, "Filter to match only MS SQL", has an error that prevents Discovery from discovering the MS SQL databases found earlier in the pattern.

The OOTB filter condition is searching for the following:

$databases_per_database_instances[].type Contains "Microsoft.Sql"

However, the target table $databases_per_database_instances does not exist when this step is executed, which means that the result will always return empty, and the pattern will not check any instances for databases. To fix this, the filter should be changed with the source table name as the following:

$cmdb_ci_cloud_database[].type Contains "Microsoft.Sql"



Steps to Reproduce

1. Open pattern "Azure DataBase"
2. Open Identification Section "Azure DataBase"
3. Look for referened library "Azure - Databases instances to Database"
4. Check first step 56.1 "Filter to match only MS SQL"
5. The filter condition shouldn't use target table $databases_per_database_instances[].type


To fix this issue, the filter should be changed with the source table name as the following:

$cmdb_ci_cloud_database[].type Contains "Microsoft.Sql"


Related Problem: PRB1349832

Seen In

There is no data to report.

Intended Fix Version


Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-08-15 15:42:39