Is there a query that will give me all the library, model, and table names for an r9.6 and later mart?

SQL Server dbms:

(the logic for this query will be the same for the other mart supported databases such as Oracle and PostgreSQL)

select m9cg.C_Name 'Library',
m9cg2.C_Name 'Model',
m9rd.O_PhysicalName 'Table Name'
from m9ReportData m9rd,
m9catalog m9cg,
m9catalog m9cg2
where m9rd.O_Type =1075838979
and m9rd.O_ParentiD = m9cg.C_Container_Id
and m9rd.C_Id = m9cg2.C_Id
order by 1,2,3

You can modify the query to filter it on specific models or tables or libraries using a where clause.
e.g., below replace tablename with the specific name of the table.

m9cg2.C_Name 'Model',
m9rd.O_PhysicalName 'Table Name'
from m9ReportData m9rd,
m9catalog m9cg,
m9catalog m9cg2
where m9rd.O_Type =1075838979
and m9rd.O_PhysicalName = 'tablename'
and m9rd.O_ParentiD = m9cg.C_Container_Id
and m9rd.C_Id = m9cg2.C_Id
order by 1,2,3