Hi @needabitofhelp,

Interesting. I can see the core table of 'task', along with other heavily used tables such as 'cmdb' which is great, but, like you, I am questioning as to why you can't retrieve or see the 'incident', or 'change_request' tables.

There does seem to be a pattern here. Any table that extends 'task' (Remember I mentioned the OO - Object Oriented design) is missing. Depending on what applications/modules you had installed, you're missing 60 or so plus. This is just for tables that extend 'task' such as 

'incident', 'change_request', 'problem' etc. FYI - 'incident_fact_table' does not extend 'task'.

I've also noticed the same pattern against other missing core tables such as 'cmdb_ci' which extends from 'cmdb'.

It seems the query is not pulling back extended tables.

@needabitofhelp  - To help others (or for me to help you more directly), please mark this response as correct and/or helpful.

Thanks, Robbie