1
0
-1
1 answer
- 210
At present Open-AudIT can list all installed software.
It can also list database instances and databases for SQL Server (only). We plan to extend this to other DBMS like MySQL, Postgresql, Oracle, et al in the future (or sooner if we have someone sponsor the development).
- Kapil Vyas
What about the Enterprise Edition - does it enable the other DBMS instances?
- Mark Unwin
Enterprise build on top of Community but does not do any additional information collecting.
Add your comment...
I am trying to get all the DBMS instances such as:
"KAPILPC\\SQL2012 (SQL Server 11.0.5058 -sa)"
"Oracle Database 10g Enterprise Edition"
I am interested in knowing if Open Audit can query a list of DBMS instances configured on a single machine or domain.
Mark Unwin - are you familiar with what is the (mysql) query that I can write - OpenAudit provides a mysql query interface to query such things. But - I couldn't find any documentation or tried querying different mysql database tables to find if there was a way to query the DBSM instances running on a system. I couldn't hit anything tangible. Am I missing something?
Appreciate greatly for the quick reply.
Thanks,
Kapil
Mark Unwin - are you familiar with what is the (mysql) query that I can write - OpenAudit provides a mysql query interface to query such things. But - I couldn't find any documentation or tried querying different mysql database tables to find if there was a way to query the DBSM instances running on a system. I couldn't hit anything tangible. Am I missing something?
Appreciate greatly for the quick reply.
The database tables of interest would be: software, service, server, server.item software.name like '%sql server%' service.name like '%mssql%' server.type = 'database' server_item.type = 'database'