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 https://documentation.riada.se/insight/latest/insight-user-s-guide/iql-insight-query-language

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

We have an open ticket system at jira.riada.se, where you can add feature requests. We have one added already for this kind of IQL, it's at https://jira.riada.se/browse/ICS-192 

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
Alexander 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 30, 2018 in Marketplace Apps

Three tips for boosting your board's efficiency with Story Maps

Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...

823 views 2 9
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