Best Practices Question

Create report SQL form other database

09/30/2015 869 views
Dear all !
it is possible to create a report from my K1000 to check another database (not Kace)?

thanks in advance

0 Comments   [ + ] Show comments


All Answers

This would mean that KACE execute an external program that runs a SQL query, then pipes the results...
I do not think this is a supported feature of KACE or recommended.

But might not be impossible, what you want to accomplish exactly?
Answered 09/30/2015 by: dedenker
3rd Degree Black Belt

Hi Dedenker,

it is a question on my side, i have an another solution of ticketing with db sql on my central db server

just if it possible to create a report from my K1000 (i do not know if exist a possibility to do an external data connexion) state of my tickets (for example like report "Open Tickets by Category")

Answered 09/30/2015 by: rollerinvinh
Orange Senior Belt

If you need to combine data sources you would be better off using an external reporting tool like Crystal Reports or even Microsoft Access. The KACE database is accessible using the reporting user. Check Settings, Security Settings, Enable Database access to see if your box is already configured to allow that.

Answered 10/01/2015 by: chucksteel
Red Belt

Hi Chucksteel,

thanks for your answer
so no possibility to read another database than Kace from report tab (exact)
except use an external reporting tools

Answered 10/01/2015 by: rollerinvinh
Orange Senior Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ