0

I am trying to show Event Data in a SQL Tile in SquaredUp, everything is working fine, it bringing back the data from the SQL Query and showing it in the relevant columns, but here comes the problem, I want to be able to manipulate one of the returned values and split the data into the following columns.

The Value return is one long string, it reads as follows:

Successful logon: to resource: Notepad Brokered by device: CTXSERVER123 Test Details: ———————- Latest Test Result: True Storefront Connection Time: 00:00:01.3438073 Receiver Startup: 00:00:00.8750339 Connection Time: 00:00:00.0468798 Logon Time: 00:00:19.4695385 Logoff Time: 00:00:03.1876311

 

What I would like to do is split this into a number of Columns and display the information on the Dashboard

Column
Value

Status
Successful logon: to resource: Notepad Brokered by device: CTXSERVER123

SF Connect Tm
00:00:02.2934935 (Rounded up to 2 decimal places)

Receiver Start-up Tm
00:00:01.0937693 (Rounded up to 2 decimal places)

Connect Tm
00:00:00.0469506 (Rounded up to 2 decimal places)

Logon Time
00:00:22.2327728 (Rounded up to 2 decimal places)

Logoff Time
00:00:03.6875498 (Rounded up to 2 decimal places)

Example

Status
SF Connect
Receiver Startup
Connect Tm
Logon Time
Logoff Time

Successful logon: to resource: Notepad Brokered by device: CTXSERVER123
00:00:02.30
00:00:01.09
00:00:00.05
00:00:22
00:00:03.6875498

 

I am not having much luck with the Split Command can anyone help please, or does anytone know a better way to display this information.

Also, does anyone know if there is a set of command that can be used when manipulating data in SquaredUp, I am not a developer so not sure what language this is written in. I am assuming its Java or a variant of Java.

Thanks in advance

Prakash

Prakash Bhimji edited question