Stock level in CMDB

Mark_Byrne December 20, 2017

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

0 votes
Alexander Sundström
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2017

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
TAGS
AUG Leaders

Atlassian Community Events