Which data table include the SQL query records and the SQL work order exec records? #4507
Answered
by
waitspring
waitspring
asked this question in
Q&A
|
Our company want to create a kanban for ODC usage data, but we can not make sure which data table include the SQL query records and the SQL work order exec records. ODC tables list:
|
Answered by
waitspring
Jul 17, 2026
Replies: 1 comment
|
Count SQL query records: select count(*)/datediff('2026-07-01 00:00:00', '2026-05-08 00:00:00')
from audit_event
where create_time > '2026-05-08 00:00:00'
and action = 'SELECT';Count SQL work order exec records: select count(*)/datediff('2026-07-01 00:00:00', '2026-05-08 00:00:00')
from task_task
where parameters_json like '%sqlContent%' |
0 replies
Answer selected by
waitspring
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Count SQL query records:
Count SQL work order exec records: