Stock level in CMDB

Hi there,

Is it possible to have a report from Insight ( or an alert ) when a certain object type reaches a pre defined level ?

For example,

I want to know when mobile phones, laptops etc, have been issued by the Tech teams. - They will take a phone from the store, edit the CMDB record and change the status from "In Stock" to "Active"..... I want to know when the number of "In Stock" items falls below 5.

I can't see anywhere in Automation to do this, and I really don't want to start messing with scripting if I can avoid it.

1 answer

Hi Mark,

There is currently not any support (as of version 5.3.1) in our query language (IQL) for count  operations of this type. What is support is to check against attribute values of an object like:

Cost < 5

But we don't have IQL supported for operations like:

count(Status = "In Stock") < 5

You can read more about IQL and what is possible at

This is something we do want to implement in the future.

We have an open ticket system at, where you can add feature requests. We have one added already for this kind of IQL, it's at 

Feel free to watch that ticket for updates.

It is possible to use groovy script in automation, so it is possible to count the objects matching what you want, but that also mean you would have to do the scripting for the actions needed, and as you mentioned, this is something you would like to avoid.

Best Regards

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Marketplace Apps

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,706 views 3 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you