Notifications

38 views

Description

MSSQL Database names with spaces are truncated when using the MSSql DB On Windows Pattern 

Steps to Reproduce

  1. Log into a Kingston instance
  2. Discover a server with an MSSQL instance where a database name contains a space
  3. Confirm the database is created, however, the part of the name after the first space is missing

Workaround

  1. Navigate to the MSSql DB On Windows Pattern on your instance
  2. Click the Identification Section called Identification for MS SQL Server
  3. Expand shared library reference to library MSSQL populate database table
  4. At step Create db table from the wmi output click Add Variable under Variables table.
  5. Click the name and rename it fake_group
  6. Modify the regular expression:
    From: \sName=(\S*)
    To: [\s+|^]Name\s*=\s*(.*?)(\s\S+=|$)
  7. Click Save and then click With libraries

 


Related Problem: PRB1298431

Seen In

There is no data to report.

Intended Fix Version

Madrid

Fixed In

Kingston Patch 9
London Patch 2

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:2018-12-06 14:50:27
Published:2018-11-20