Hi Paul,
Additionally, it's pretty complex to handle each scenario since business services can look vastly different. Here's a quick example we came up with: it handles a few levels from Service > Server and/or App > Other CIs. When using the CMDB Query builder, you can select new and choose "Service Mapping Query."
From there, you can build whichever relationship topology/report you want. Here's an example of what might work for what you want. Though, you can possibly go down a few more levels too. What you need to keep in mind is, queries such as these are very resource intensive if going at the CI level.
The query builder will let you find the records, and you can see the count when it returns the records. If your query shows multiple classes, you could group by class to see the count for the class you want. Your description makes me think you have some goal with this number that involves further processing, though, so you may be better served with a GlideAggregate query to get the number and then addition scripting to process it.
Hi Paul,
The query builder will let you find the records, and you can see the count when it returns the records. If your query shows multiple classes, you could group by class to see the count for the class you want. Your description makes me think you have some goal with this number that involves further processing, though, so you may be better served with a GlideAggregate query to get the number and then addition scripting to process it.
Additionally, it's pretty complex to handle each scenario since business services can look vastly different. Here's a quick example we came up with: it handles a few levels from Service > Server and/or App > Other CIs. When using the CMDB Query builder, you can select new and choose "Service Mapping Query."
From there, you can build whichever relationship topology/report you want. Here's an example of what might work for what you want. Though, you can possibly go down a few more levels too. What you need to keep in mind is, queries such as these are very resource intensive if going at the CI level.
Mark Correct if this solves your query and also mark Helpful if you find my response worthy based on the impact.
Thanks paul
