Contracts - CI with Contracts vs CIs without Contracts

nathanpalin
Tera Contributor

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?

1 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

 

AGLearnNGrow_0-1739285989606.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

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

AGLearnNGrow_0-1738966148658.png

 

 

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.

AGLearnNGrow_1-1738966291355.png

 

 

These 2 reports will helpful for you.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

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 

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

 

AGLearnNGrow_0-1739285989606.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************