/build/static/layout/Breadcrumb_cap_w.png

Create report SQL form other database

Dear all !
it is possible to create a report from my K1000 to check another database (not Kace)?

thanks in advance

BR

0 Comments   [ + ] Show comments

Answers (4)

Posted by: dedenker 8 years ago
3rd Degree Black Belt
0
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?
Posted by: rollerinvinh 8 years ago
Orange Senior Belt
0
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")

BR,
Posted by: chucksteel 8 years ago
Red Belt
0
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.

Posted by: rollerinvinh 8 years ago
Orange Senior Belt
0
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

Don't be a Stranger!

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

Sign up! or login

Share

 
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