Json Report

[Rakshanda Kunte]

Hi,

There is one string field "Additional Information" which is in JSON format on alert table.

I need to show this data in Dashboard/create a report first.

How can I show every attribute on the dashboard/report separately? And create a trend?

Is there any way?

Thanks.

[Kieran Anson]

As this data is unstructured and different per-event source (or event management rule) you wouldn't be able to report on it in a clean manner.

You could possible create a secondary table to store the JSON key values, but I'd question the value.

What is the business wanting to report on that isn't available as part of the alert table dictionary?

[Rakshanda Kunte]

Hi @Kieran Anson ,

These values are available on Event Rule Table. 

(In Event Additional Info) and mapped to "Additional Information" on the event. 

Is it possible to use this "Event Input" to create a report?

Thanks.

[Kieran Anson]

The event builder, which you screenshotted, knows to parse the data in the additional information field as it's expected to be JSON. However the data isn't persisted, it lives in memory during transformation. It's expected that you only map the required information from the event into the alert, not keep it all.

You need to work out WHAT your client wants to do with this information, rather than just storing it.

[Rakshanda Kunte]

Hi @Kieran Anson,

Approach 1: Create a new Table

We are creating Dashboard using Performance analytics. And to showcase the "attributes" in 'additional information' we will need to create new fields on new table. (It involves auditing process as well). 

If we go with creating new fields for each attribute, those must be "choice" or "reference" type. 

And most of the fields will be string. so, it cannot be done.

Requirement from requester: If we select any family/group on dashboard, it should showcase the alerts and events details from specific source. 

They also want to see this 'additional information' on dashboard. 

Do you think this can be done with any other approach to get the additional information on the dashboard?

I have created below dashboard for alerts requirement using performance analytics.

Thanks.