How to get Database and tablenames of database instances using discovery?

[Madhav9]

Hi 

We have a requirement to import database names of MySQL, PostgreSQL, MongoDB etc...We are successfully discovering MySQL instances. But how to read database and table data of each MySQL or PostgreSQL.

I have read in a document to provide applicative credentials. But failed doing it as well. Below is the only table which is getting populated.

• cmdb_ci_db_instance

These below tables are not getting populated

• cmdb_ci_database
• cmdb_ci_db_catalog

Thank you

[Alberto Consonn · Accepted solution]

Hi,

Just looking to the official documentation, seems possible to do in this way:

Important: Discovery does not support Oracle or MySQL database catalog discovery in the base system. You must create probes and sensors to find these. However the Windows - MSSQL probe is available by default for MSSQL discovery. A pattern is also available. However the pattern and the probes do not populate the same information.

(Database catalog discovery)

Try using the following example:

Example custom Discovery probe and sensor: populate a CI with text file values

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Alberto Consonn]

Any update on this?

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Runjay Patel]

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

Link: https://www.youtube.com/watch?v=30JbWVsusyE&t=10s&ab_channel=ServiceNowHelpdesk

It help you to understand below points.

• Discovery Overview
• Discovery prerequisite
• Understanding Discovery Phases in details
• Discovery credentials and IP Affinity
• Mid Server Management with Cluster and Load Balancer
• Schedule jobs
• Set up discovery from scratch to end
• Live implementation with real world data.
• Troubleshooting on various aspects
• Many more other issue related to mid server, CIs
• Cloud discovery
• Service Mapping

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

[abdullahkhan852]

Video is not available.