Step by Step - Database Discovery

[Aman Trivedi1]

Hi Everyone,

We are planning to implement Database Discovery in our environment. We have already implemented.

• Windows Discovery

The next phase is Database Discovery.

Databases in Scope

• Microsoft SQL Server
• Oracle Database
• PostgreSQL
• Azure SQL Database

Authentication Options Under Consideration

Option 1 – Existing Windows Service Account

Use the existing Windows Discovery service account  and grant the required database-level permissions.

Option 2 – Dedicated Database Discovery Account

Create a dedicated database discovery account (username/password) with read-only permissions specifically for ServiceNow Database Discovery.

1. Prerequisites

For each database type (MS SQL, Oracle, PostgreSQL, Azure SQL):

• Required MID Server version/configuration
• Network and firewall requirements
• Supported authentication methods
• Port requirements
  

Any documentation, implementation guides, KB articles, or real-world recommendations would be greatly appreciated.

Thank you in advance.

[shubhamseth]

@Aman Trivedi1 In this case, can you try below link which has few of DBs mentioned for discovery: 

https://www.servicenow.com/docs/r/it-operations-management/itom-visibility/database-discovery.html

[Harish Bainsla]

Hi @Aman Trivedi1 

please check below link

https://www.servicenow.com/docs/r/it-operations-management/itom-visibility/database-discovery.html?c...

https://www.servicenow.com/community/itom-blog/extending-discovery-to-discover-databases-and-databas...

https://www.servicenow.com/community/itom-forum/how-oracle-database-discovery-works-any-implementati...

https://youtu.be/anyXEd0MUUU?si=PKa_E7f7M4Al4dBh

https://www.servicenow.com/community/itom-forum/how-to-discover-database-instances/m-p/949096

if my answer helps you mark helpful and accept solution