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.

[Rakshanda Kunte]

Hi @Kieran Anson ,

Would you please help if we can go with any other approach?

Thanks.

[Kieran Anson]

I'm not sure I understand what you're trying to achieve to be able to advice on alternative approaches

[Rakshanda Kunte]

Hi @Kieran Anson ,

Is it possible to import some data using scripting in Platform analytics workspace or in dashboards or reports?

Thanks.

[Kieran Anson]

You could use a remote table. The remote table would look up every alert record, parse the json, and then output it to a remote table. These live in memory and aren't stored

Remote tables (servicenow.com)