How to discover database instances?

[Subhamoy Maitr1]

I want to discover the following Database classes:

Database Instance
DB2 Instance
MS SQL DataBase
MS SQL Server
MSFT SQL Catalog
MSFT SQL Instance
MySQL Instance
Oracle Instance

I need the following information:

1. Which ports are needed for this discovery?

2. What type of credentials (Windows/SSH/SNMP) are needed?

3. Any specific application needed to be installed on the mid server?

4. How to map the data to the corresponding tables

[Rahul Priyadars]

1. Which ports are needed for this discovery?-22 and 135 WMI

2. What type of credentials (Windows/SSH/SNMP) are needed?-Depends on DB is running on what OS Host. So windows and SSH both

3. Any specific application needed to be installed on the mid server? Nope

4. How to map the data to the corresponding tables--> It as a part of Standard Discovery process.

You can always refer DOCS as all these topics are covered in Docs.

https://docs.servicenow.com/bundle/paris-it-operations-management/page/product/discovery/concept/dat...

Regards

RP

[Vivektietsood]

You would need to have specific ports opened for DB, for example - Oracle 1521, SQL 1433, MY SQL 3306. These are the typical ports and you should check with your network admin if these ports are configured for the DBs you want to discovery. These ports need to be opened in addition to windows 135 and Linux 22 because DBs are essentially applications so for discovery to completely scan - it needs Device and software level ports. 

Similarly you would need to have credentials at a device as well as at DB level. For Windows you would need admin access to scan just at a device level and then access to SQL. Following link has links to different DB access requirements. 

You dont need to have any apps installed on mid but make sure that ports are opened from mid as I mentioned above. 

Discovery would create maps automatically.

https://docs.servicenow.com/bundle/paris-it-operations-management/page/product/discovery/concept/dat...

Please mark helpful or accept solution so that it helps others with a similar question

[Ashutosh Munot1]

1. Which ports are needed for this discovery? Basic ports 22 and 135 along with 1521 and 1433 which i have done.

2. What type of credentials (Windows/SSH/SNMP) are needed? Applicative credentials are needed for oracle discovery and sometimes on windows as well for MSSQL.

3. Any specific application needed to be installed on the mid server? No, it just needs the connectivity on those ports and credentials for this.

4. How to map the data to the corresponding tables? This is handled already in patterns which servicenow provides.

Thanks,
Ashutosh

[Ashutosh Munot1]

If you have your answer then please mark answer correct.