Contracts - CI with Contracts vs CIs without Contracts

[nathanpalin]

We have multiple Contracts in ast_contract, with CIs associated to them via the 'Contract Used By' related list.

Not all CIs we have recorded are associated to a Contract.

From a CI perspective, I cannot find a relation along the lines of "Uses Contract". Instead I have built a Reference field to pull from the ast_contract table, as a band-aid solution.

I would like to report on how many CIs are associated to any Contract vs those that are not.

How should I be doing this, please?

[Dr Atul G- LNG]

Hi @nathanpalin 

I tired at my end and here are inputs for you

Create a report on ast_contract table

Then on related list add the table contract used by  None , to see where NO CI Attached to any contract

and create another report in same table but this time add, Greater than or Equal to 1 , to know if any CI attached to Contract.

These 2 reports will helpful for you.

[nathanpalin]

Hi Atual,

Thank you for the above. I have created the two reports which will be invaluable to our Cost and Licencing team.

What I require is the inverse of these reports: which Configuration Items use which Contracts?

Without sharing my screen, I have visibility of Contract > Contract Used By > Configuration Item. For my reporting purposes I need a view of Configuration Items (in this case: Computers) > Uses Contract (or equivalent) > Contract.

Is that possible?

Thanks, again.

NP 

[Dr Atul G- LNG · Accepted solution]

Hi @nathanpalin 

On the ast_contract tabel it si not possible unless we create the data base view if ast_contact and the ast_contract_instance table , but other way create a table in asy_contract_instance and there you can see this information