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.

[Tanushree Maiti]

Hi  @Aman Trivedi1 

Refer : Microsoft SQL Server and Cluster discovery 

Oracle database discovery 

PostgreSQL discovery 

Microsoft Azure SQL Database Spoke 

https://www.servicenow.com/community/itom-forum/need-help-on-discovery-for-db-instances/td-p/3176539

Database discovery 

[Aman Trivedi1]

Hi @shubhamseth , @doug_schulze , @Doci1 , @Selva Arun , 

I came across your comments on one of the databse Discovery articles.

Just checking if you have implemented ServiceNow Database Discovery in the past. If so, I would appreciate your guidance on the credentials and permissions required for the following database platforms:

1. Microsoft SQL Server
2. Oracle Database
3. PostgreSQL
4. Azure SQL Database
   

• What minimum database permissions are needed?
• Can we use an existing Windows service account for discovery, or is a dedicated database account recommended/required?
• Are there any additional prerequisites or best practices that we should be aware of?
  
  Thanks in Advance
  
  

[shubhamseth]

@Aman Trivedi1 

Can you refer below article which has all information about ask>

https://www.servicenow.com/community/itom-articles/servicenow-discovery-implementaion-requirement-ga...

[Aman Trivedi1]

Hi @shubhamseth Thanks for sharing.

Still it doesn't contain that much info related to database discovery.