The connection section which is used in service map discovery as part of the MSSQL databases with spaces in the names are truncated. - Known Error

The connection section which is used in service map discovery as part of the MSSQL databases with spaces in the names are truncated. Description The connection section which is used in service map discovery as part of the MSSQL databases with spaces in the names are truncated.

The reported "PRB1476301" was fixed for the shared reference library "MSSQL populate database table :" which was as per the "Pattern record : sa_pattern_dd88d71f9f613200c7445f9bc32e7059:"

SSQL populate database table : Pattern record : sa_pattern_dd88d71f9f613200c7445f9bc32e7059:

- Currently the reported behaviour is part of a "connection section" which is used in service map discovery for the MSSQL databases with spaces in the names are truncated - Successfully reproduced the issue in-house for the Discovery Patterns : MSSql DB On Windows for the pattern record : 3D28d607dbfead4be3887c843814455500

ref :: https:// .service-now.com/nav_to.do?uri=%2Fsa_pattern.do%3Fsys_id%3D28d607dbfead4be3887c843814455500

step { name = "Create db table form the wmi output" if { condition = is_not_empty {get_attr {"db_output_from_wmi"}} on_true = parse_var_to_var { from_var_name = "db_output_from_wmi[*].Name" to_var_names = table { name = "dbs" col_names = "database" } parsing_strategy = delimited_parsing { delimiters = " " selected_positions = 1 } if_not_found_do = nop {} } on_false = nop {} } }

Steps to Reproduce

The reported "space" can be find for the Discovery Patterns : "MSSql DB On Windows",, please find the below lab instance for your reference:

Lab : Quebec_Patch7

Discovery Patterns : MSSql DB On Windows pattern record : 3D28d607dbfead4be3887c843814455500

ref :: https:// .service-now.com/$sn_pattern_designer.do?authoring_mode=modify&sys_id=28d607dbfead4be3887c843814455500&sysparm_view=&sysparm_record_target=sa_pattern&sysparm_record_row=7&sysparm_record_list=nameCONTAINSsql%5EORDERBYname&sysparm_record_rows=17

Workaround Changes Required

1. Removed the space delimiter so that complete db name is populated.

2. Disabled step "Filter db table for entry point input" as it is incorrect here and stops creating inclusion connections to DB CIs.

3. Added new step "Filter empty dbs" after above disabled step to remove any dbs that are empty.

4. Modified the precondition and entrypoint creation to consider all the dbs discovered.

Update set attached