Notifications

60 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.

Fixed In

Kingston Patch 9
London Patch 2
Madrid

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:39:41
Published:2018-11-20