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