service mapping issues

[ihabeeb]

While establishing service mapping , I am having some issues ;

1) ServiceNow Service mapping CI discovery into DB configuration is not customer-specific.

The Service Mapping process currently connects to all the databases, but we need to limit it to only the one the customer specifies in the entry point hostname. From my research, it appears that I should locate the discovery pattern associated with the MS SQL Server CI and define the entry point there. Is this the correct approach, and if so, how can I find the discovery pattern for the MS SQL Server CI? Additionally, I'd like to make this solution dynamic. Your guidance is greatly appreciated.

2) Load Balancer Port 0 issue
Port 0 issue - We have defined 4 entry points per port against the listener public IP. The virtual server load balancer  is able to point to the correct listener server pool. But the pool is not being mapped correctly due to the error message under 'Log Message':

"Failed to identify CI due to the host 10.0.7.98 lacking an application running on port 0. Make sure that the application is running and run quick discovery on the host".

3) Load Balancer - Pattern matching non-defined pools issue 
A pool is not defined against a virtual server on the load balancer.
SNow Discovery of the f5 load balancer is not reading the iRule to map the pools against the virtual server on the load balancer. I Also need tp  understand how common Virtual Server on the F5 load balancer  can map to multiple pools.

Any help to the above queries is much appreciated. Thanks in advance ...

[Abbas_5]

Hello @ihabeeb,
Please refer to the below link:

https://www.servicenow.com/community/itom-articles/service-mapping-troubleshooting-tips-and-tricks/t...

If it is helpful, please mark it as a thumbs-up and accept the correct solution.
Thanks & Regards,
Abbas Shaik

[ihabeeb]

Hi @Abbas_5,

I have already reviewed the article you provided, but it doesn't seem to address my specific queries or provide much helpful information in that regard.

[SiD2]

Hi @ihabeeb 

My first suggestion is to ask multiple questions in different posts rather than clubbing 3 different complex queries here. I'm unaware of point 3 and trying to address other 2 queries.

1. I guess OOB it must have been designed so to discover all DBs but need to see if there's an option to specify the db name and for that I need exact pattern name i.e. being executed in your case. You can right click on the MSSQL node on map and open Discovery log and then you can check the pattern name and even its connection section steps to find how it creates connections to all DBs.

2. The error message sounds clear enough and asks you to do a horizontal discovery on that IP and would suggest the same. I don't understand how can an application run on port 0. If it's indeed running on port 0 then I'm unaware how to fix that and you can raise a support case with us.

[ihabeeb]

Thank you @SiD2 ,
1) I have gone through the discovery logs and find the below 

I am new to service mapping , so these are the details ,I am able to find from discovery logs. please help me on this ...