Archiving records on cmdb_ci table created multiple empty archive tables

[PriyanshuVerma1]

Hey guys,

I created an archive rule on cmdb_ci table with following conditions,

class = 'computer';

created on = at or before 31st Jan 2024;

As i saved the archive rule, it created multiple empty archive tables

There bunch more like these, around 100.

Now I don't know what are these tables and how are they created are these child table of cmdb_Ci table or somehow related to that table. 

[AshishKM · Accepted solution]

Hi @PriyanshuVerma1 , 

You can check the table hierarchy at Tables [ sys_db_object ] for child table mapping.

Check if this "Computer [ cmbd_ci_computer ]" table is parent of any other table for which these archive table created.

-Thanks,

AshishKM

[Kevin Callaghan]

I'd think filter is impactful.

Class 'is a' Computer versus Class 'is' Computer. 

Very different results. 

And if you are building an archive IN the computer class, why not create in ON the table versus trying to walk down to that table. You can only create 1 rule per class as I recall.