Can discovery populate listener_name in MSSQL discovery

[Neel10]

I am looking to populate listener_name field in the MS SQL instance table. Is it to possible configure discovery to populate this field while discovering sql servers?

Thanks

Neel

[SiD2 · Accepted solution]

Hi Neel,

I guess OOB MSSQL pattern doesn't populate this field, but you can add an extension section to the pattern and populate it.

Let me know if you need assistance with this.

Please mark the appropriate responses as Correct/Helpful so that this thread gets closed and helps others with the same question in the future.

[Neel10]

Thanks SiD. Would you please give me a brief of the extension steps? which command should I execute for the listener name?

[SiD2]

Hi Neel,

I'm not much aware of the db side though, so couldn't help on that. You can check in web or with your win administrator to get the command and once you find it, you can use the same in the pattern.

But on patterns extension section you can refer the snow doc link below.

https://docs.servicenow.com/bundle/kingston-it-operations-management/page/product/service-mapping/ta...

Let me know if you need assistance with pattern extension once you are aware of getting that info.

[Ashutosh Munot1]

Hi Neel,

Lister data collection command you can get it from your DB guy.

Thanks

Ashutosh