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

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published yesterday in Marketplace Apps

The 7 hacks of highly successful automation

...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...

155 views 0 12
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