- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2025 07:31 AM - edited 02-11-2025 01:24 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 07:00 AM
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
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2025 02:11 PM
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.
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 01:24 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 07:00 AM
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
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]
****************************************************************************************************************