How to access the Spotfire 10.6 Scheduling and Routing information

[Tim Caldwell]

Spotfire version 10.6

We need to show the users when the data was last updated.

this is contained in the Spotfire Scheduling and routing page.

how do i access this information to show up in the visualization of an analysis in a text box or something.

[David Boot-Olazabal]

Hi tcaldwell,

You can find this information in the Spotfire database. Consider this custom query:

SELECT

max(f."LOGGED_TIME") as "Last Run time",

f."ID2" AS "ANALYSIS",

b.RELOAD_FREQUENCY,

b.RELOAD_UNIT,

b.NAME as "Schedule",

c.NAME as "Routing Name",

c.status,

f."USER_NAME",

len(b.Week_days) as LengthWeekDays,

DATEADD(mS,(b.START_TIME), Convert(DateTime, DATEDIFF(DAY, 0, GETDATE()))) as Schedule_Start,

--Datediff(hour,max(f."LOGGED_TIME"),DATEADD(mS,(b.START_TIME), Convert(DateTime, DATEDIFF(DAY, 0, GETDATE())))) as Hours_Since_Last_Run,

GETDATE() as CurrentDateTime

FROM

[spotfire_Server].[dbo].[RULES_SCHEDULES] a,

[spotfire_Server].[dbo].[JOB_SCHEDULES] b,

[spotfire_Server].[dbo].[ROUTING_RULES] c,

[spotfire_Server].[dbo].[uSERS] d,

[spotfire_server].[dbo].[sCHEDULED_UPDATES_SETTINGS] e,

[spotfire_Actionlog].[dbo].[ACTIONLOG] f

where

b.ID = a.SCHEDULE_ID and

a.ROUTING_RULE_ID = c.ID and

d.USER_ID = b.LAST_MODIFIED_BY and

(c.status = 1 or c.status = 0) and

c.id = e.ROUTING_RULE_ID and

c."ENTITY_VALUE" = f."ID2"

and f."USER_NAME" = 'scheduledupdates@SPOTFIRESYSTEM'

and f.log_action IN ('load_start','update_start')

group by

f.ID2, b.name, c.NAME ,c.ENTITY_VALUE, START_TIME, b.RELOAD_FREQUENCY, b.RELOAD_UNIT, f."USER_NAME", c.status, b.Week_days

 

kind regards,

David