Creating a Calculated Field for Thresholds

[Scott_Goeden]

I'm currently in need to a way to alert on Trunk Group utilization on our Avaya PBX. I need to create a threshold that will alert when the utilization is at 90% of available trunks. However I can't create something based solely on each trunk group because we have groups of SIP TGs (15 in a group) that will fill up the first TG before sending requests to the second (and so forth in the 15 TG group). Looking at the individual TGs will result in constant false positives as one of the TGs in this SIP trunk group fills up.

I’m looking for a way to add the total trunks active (TRNKSACT) for a grouping of TG Names (TGRPNAME) or TG Numbers (TGRPNUMB), then set a threshold based on what 80% of available trunks should be.

So if the return was something like this:

TG TrunksActive Utilization
610 255 255 of 255 (255)
611 255 255 of 255 (255)
612 10 10 of 255 (255)
613 0 0 of 255 (255)
614 0 0 of 255 (255)
615 0 0 of 255 (255)

I’d need the total sum of active trunks for all 6 trunk groups (520) so that I can build a threshold that says Active Trunks for this grouping of TGs is > 1224 (or 80% of the total 1530 available trunks), which wouldn’t trigger the threshold.

If the return was something like this:

TG TrunksActive Utilization
610 255 255 of 255 (255)
611 255 255 of 255 (255)
612 255 255 of 255 (255)
613 255 255 of 255 (255)
614 255 255 of 255 (255)
615 0 0 of 255 (255)

Since I’d have a threshold set to alarm at 1224 (or 80% of the total 1530) I would get an alarm saying that we’ve breached out warning threshold of 80% usage on our SIP trunks.

[Shoaib_Dilawar]

Hi Scott,

Prognosis supports grouping (combines) in a display, but same feature is not available in thresholds.

For thresholds, it needs summarized data in a record. So if we need to get summary data based on custom groups you mentioned, we can create a custom solution that reads in data from prognosis, summarizes and produces a new record. This new record can then be used in threshold.

Let me know if you want to discuss it further.

Regards,
Shoaib.

[GeraldC]

Good question. I note that this is Avaya SIP Trunks, and the AvayaTrunkGroupAvailability record (key field is the trunk group number). Prognosis Displays have a Combine feature that should be able to get the totals over where-clause-defined groups of TGs like this. However you need an alert from a Threshold not a Display. Prognosis Thresholds do not have that Combine feature. It might require a new user defined record and a PACE solution to populate it. The IR Consulting team are the experts on PACE and would be able to verify this and what is involved. HTH
P.S.
It looks like Shoaib has reached out to you regarding this.

[Scott_Goeden]

Thank you both for the quick reply to this post. I'm still causing Shoaib issues

Sounds like I'm getting into the weeds now. I'll reach out to professional services if this is something we'd like to pursue.

[Shoaib_Dilawar]

Not at all Scott

This is piece of cake compared to some of other complex project we both worked on