Kace Database
Does anyone know if there is a way I can copy my Kace database?
I want to copy the entire database to somewhere else and make the copy read-only.
I would also need to be able to run reports from the copied database
1 Comment
[ + ] Show comment
-
in security settings you can enable database access and then pull it off into another DB. - n1md4 6 years ago
-
I don't understand. Can you provide more detail? I want to duplicate the entire database - cjohnson4 6 years ago
Answers (1)
Please log in to answer
Posted by:
Nico_K
6 years ago
Go to Settings | Security Settings and you can enable the access to the database from external.
Then connect any DB Reporting tool (like mysqlworkbench) to it and run the reports.
This acess is read only and you always have the current database fields (and since it is read only you will not corrupt it due to this way)
See here for the full procedure: https://support.quest.com/kace-systems-management-appliance/kb/114938/
Then connect any DB Reporting tool (like mysqlworkbench) to it and run the reports.
This acess is read only and you always have the current database fields (and since it is read only you will not corrupt it due to this way)
See here for the full procedure: https://support.quest.com/kace-systems-management-appliance/kb/114938/
Comments:
-
There's not a way we can duplicate the database? - cjohnson4 6 years ago
-
What is the reason you want to copy the database? If all you want to do is read-only reporting then this method is best. You can't write to the database with the R1 user so you don't have to worry about messing anything up. And you can query the database live rather than having to export every time you want an updated query. - JasonEgg 6 years ago
-
FWIW, once you're connected you should be able to duplicate the database as well (mysqldump should work, though I haven't tested that), but I agree w JasonEgg that this seems like an unnecessary extra step. - EricAtStauer 6 years ago