Accessing the NetMRI Database Using SQL
- Viktoryia Varapayeva (Deactivated)
Owned by Viktoryia Varapayeva (Deactivated)
You can leverage access to the NetMRI database using SQL to simplify your NetMRI reporting and integrations. To do so, the database credentials must be enabled for your user account. Only a user with the SysAdmin role can enable database credentials. For information on how to enable the NetMRI database access to a user, see Creating User Accounts.
Once the credentials are granted to you, you can connect to the NetMRI database using an SQL client. The access is limited to read-only operations. Use port 6033 for SQL connection.
You can perform the following as the SQL database user:
- Perform SELECT operations on tables from the NetMRI, report, config, and archive databases.
- Create temporary tables.
- Execute stored procedures and functions on historical data, namely:
- BeginReport
- BeginReportRunQuery
- LoopReportQuery
If you want to be able to execute more procedures and functions, contact Infoblox Technical Support.