Database discovery issue

[Chavan AP]

hey Guys, 

I am having an issue with discovering databases in our instance. 

few Que:

how database discovery works? for MySQL, MSSQL, and for oracle?

where does DB ci get stored?

what is the database catalog and database instance?

where I could find is database probe?

which are database discovery schedule?

how to debug database discovery issue?

please help me with the same, thanks in advance

Regards

Aj

[Ashutosh Munot1 · Accepted solution]

Hi,

DB are discovered as a part of horizontal discovery. They are discovered using patterns like MS SQL Windows DB patterne,etc.

Worth to mentioned that we discovery DB instance on Servers and not DB directly. So this is very important to keep in mind.

where does DB ci get stored? In tables like : cmdb_ci_db_instance where instance are stored and then we have DB tables like cmdb_ci_db_mssql_database

what is the database catalog and database instance?an instance is a copy of the sqlservr.exe executable that runs as an operating system service while a database is a systematic collection of data that stores data in tables. 

where I could find is database probe? They are patterns and can be found in patterns list.

which are database discovery schedule? As i mentioned if you see windows servers disocvery then there you should see the pattern will be triggered in discovery logs. If cloud discovery then you need to check cloud scheduled in discovery scheduled list.

how to debug database discovery issue? Using patterns and discovery logs you can debug this. Each pattern has a debug mode on it.

Thanks,
Ashutosh

[Chavan AP]

thanks 🙂 

[Priyanka Chandr]

Hi,

Discovery can find database applications, such as MySQL, Oracle, and MongoDB. Discovery can also find database management system software, such as MSSQL Server.

Also refer below link

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

Please mark it correct and helpful.

Thanks,

[Runjay Patel]

Check out this video, it will clear all your doubts and help you to understand Cloud Discovery queries in details.

Link: https://www.youtube.com/watch?v=GWAvGbnCmlQ&ab_channel=ServiceNowHelpdesk

It help you to understand below points.

• Cloud Discovery
• Cloud Service Mapping vs Discovery
• Steps by step setup
• Practice with real world scenario
• Troubleshooting
• CI Class Tables and Attributes
• Amazon AWS Cloud Discovery Step by Step Configuration
• Azure Cloud Discovery Step by Step Configuration

Please mark reply as Helpful/Correct, if applicable. Thanks!!