How to discover MySQL Databases?

Ganesh Suresh
Kilo Contributor

‎10-12-2018 04:39 AM

Hello All,

Can any one help me with this, if you have already done.

I'm trying to discover 'MySQL Server' --> MySQL Instance --> MySQL Database Names.

Based on the MySQL IP's, i'm able to discover - 'MySQL Server' --> MySQL Instance but we are not getting MySQL Databases under MySQL instances.

How to discover MySQL databases?

Thanks,

Ganesh

Labels:
0 Helpfuls
  • 1,436 Views
2 REPLIES 2

robertgeen
Tera Guru

‎10-12-2018 04:57 AM

Out of the box you only get to the instance level with MySQL discovery. You would have to extend the patter/probe/sensors to run a query on the instance to pull back the list of databases. This would all be custom. Thanks.

0 Helpfuls

Sudharsanan Rav
ServiceNow Employee
ServiceNow Employee

‎10-16-2018 02:23 AM

Hi Ganesh,

There should be a specific file within the installation directory which may/might hold the information about the related Databases.

You can reach out to the respective application support for help, if needed you may need to update your probes/sensor or patterns.

0 Helpfuls