Report Formulas
Can formulas be created in the out of box reporting tools for the KACE appliances?
For instance if I wanted total work log hours for technician by day, week, etc can formulas be created in KACE reporting to accomplish this or would a third party reporting software like Crystal Reports have to be used?
For instance if I wanted total work log hours for technician by day, week, etc can formulas be created in KACE reporting to accomplish this or would a third party reporting software like Crystal Reports have to be used?
0 Comments
[ + ] Show comments
Answers (5)
Please log in to answer
Posted by:
airwolf
13 years ago
Posted by:
rspencer
13 years ago
Posted by:
airwolf
13 years ago
As I said, you'll have to use custom SQL queries for the majority of the reports you are looking for because the "wizard" cannot join tables (ticket work, comments, and other fields are in three separate tables). It's no different than using something like Crystal Reports, because you'll have to write queries either way. You CAN use third-party reporting tools if you desire (using read-only ODBC), but there is no need because all data that would be available in a third-party reporting tool is already available in custom SQL reports.
You'll need a DBA or you'll need to learn MySQL query syntax for custom SQL reporting.
You'll need a DBA or you'll need to learn MySQL query syntax for custom SQL reporting.
Posted by:
airwolf
13 years ago
Posted by:
anujp
13 years ago
Greetings
Thanks for the explanation m8
Been banging my head on this for sometime.
Is it possible to get a template of a MySQL query for calculating the averages.
And probably a hint about how to amalgamate it with one of the SQL report template in KACE 1100 - "Work Report last 31 days by person"
select W.STOP as DATE, CONCAT(CAST(T.ID AS CHAR), " - ", T.TITLE) as TICKET, U.FULL_NAME, substring(W.NOTE,1,1200) as NOTE,
format((time_to_sec(timediff(stop, start)))/3600.0 + ADJUSTMENT_HOURS,2) as HOURS_WORKED
from (HD_WORK W, HD_TICKET T, USER U)
where W.HD_TICKET_ID = T.ID
and isnull(W.VOIDED_BY)
and W.USER_ID = U.ID
and W.STOP > DATE_SUB(NOW(), INTERVAL 31 DAY)
order by U.FULL_NAME, TICKET, W.STOP
Much appreciated
Thanks for the explanation m8
Been banging my head on this for sometime.
Is it possible to get a template of a MySQL query for calculating the averages.
And probably a hint about how to amalgamate it with one of the SQL report template in KACE 1100 - "Work Report last 31 days by person"
select W.STOP as DATE, CONCAT(CAST(T.ID AS CHAR), " - ", T.TITLE) as TICKET, U.FULL_NAME, substring(W.NOTE,1,1200) as NOTE,
format((time_to_sec(timediff(stop, start)))/3600.0 + ADJUSTMENT_HOURS,2) as HOURS_WORKED
from (HD_WORK W, HD_TICKET T, USER U)
where W.HD_TICKET_ID = T.ID
and isnull(W.VOIDED_BY)
and W.USER_ID = U.ID
and W.STOP > DATE_SUB(NOW(), INTERVAL 31 DAY)
order by U.FULL_NAME, TICKET, W.STOP
Much appreciated
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.