Management of tables generated by the CMDB Query Builder

[Christian_]

It looks to me like the CMDB Query Builder generates new tables for its result.

The character of these tables is that they all have a name starting at u_cmdb_qb_result_ and that they extend the Query Builder Results [cmdb_qb_result_base] table.

Over time, I see before me a larger number of tables here, and perhaps not all of them are relevant.

How should one manage these? (Archiving/Deletion..)

Are there analytics on the use of these tables?

Thanks in advance!

[Christian_]

If you are wondering about the data and not the management of the table it self, this KB Articles answers that question: KB0954427 - Query Results for CMDB Query Builder 
(Scheduled job: CMDB Query Builder query results clean up, runs every day and cleans up the data from the query results table, which is more than 24 hours old.)

[Christian_ · Accepted solution]

There is no dashboards OOTB atm for monitoring of the usage of the CMDB Query (tables).

The following Idea is created for this: Detect unused queries for the cmdb Query Builder which would help the customer to remove them, please upvote 🙂

(Note, when a query is deleted, the table is dropped backend.)