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
Community showcase
Posted Oct 11, 2018 in Marketplace Apps

You + one app + a desert island...

Hi all! My name is Miles and I work on the Marketplace team. We’re looking for better ways to recommend and suggest apps that are truly crowd favorites, so of course we wanted to poll the Community. ...

3,372 views 6 6
Join discussion

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