Report showing Contract number and Asset Covered

[Mike88]

Afternoon all

I'm looking for a bit of help or advice. I'm trying to create a report that shows our Contract numbers and the associated Software Assets covered.

I can run a report showing just the contract numbers using ast_contract
and
I can run a report showing just the software assets using alm_licence

However it seems that there is no clear way to combine the two records to a single report. Has anyone come across similar and how was it resolved?

I've looked under the column selector when running from Contract table but can find no field for 'Asset Covered' likewise when running from licence table there is nothing for Contract number.

[Mark Manders · Accepted solution]

Try the 'clm_m2m_contract_asset' table. The 'contract' field is not on the list OOB , but you can just add it.