Can discovery populate listener_name in MSSQL discovery

Neel10
Tera Guru

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

1 ACCEPTED SOLUTION

SiD2
ServiceNow Employee
ServiceNow Employee

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.

Please mark Helpful / Accept Solution so that it helps others with similar questions.

View solution in original post

13 REPLIES 13

Vivektietsood
Tera Guru
Tera Guru

https://stackoverflow.com/questions/56234537/how-to-get-the-sql-server-listener-name

https://www.quora.com/How-do-I-find-the-listener-name-in-SQL-Server

These threads give details on how to get listener name.

Please like or accept solution so that it helps others with a similar question.

Neel10
Tera Guru

Thanks Vivek. Could you please share with me a  screenshot of some extension in a pattern for reference? 

 

SiD2
ServiceNow Employee
ServiceNow Employee

Hi Neel,

You can refer OOB "Oracle DB on Windows" pattern for reference, it has many extension sections.

find_real_file.png

 

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

Please mark Helpful / Accept Solution so that it helps others with similar questions.

Hi Neel,

Please refer to this link -

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

It has very detailed instructions on how to extend a pattern. 

Please like or accept solution so that it helps others with a similar question.

 

Hi Neel,

 

Were you able to populate Listener Name? if yes, could you please share the steps you used for pattern extension?

Thanks & Regards,

Girish.