Reading Spotfire Web Player Server Log File

Hi All,

I've a requirement to provide status of Scheduled Reports in Spotfire. Upon investigation I found that this information is available in Spotfire.Dxp.Web file. Upon opening this file, there are lot many information which is irrelevant to me. Can someone guide me:

  1. How to read this file using Informatica?
  2. Are there any keywords that I can focus on to get the status of Scheduled Reports' status?

1 Comment

In 7.6 (and probably 7.5 and 7.7)

I created an information link to the Spotfire Admin Database.  Next I created a simple Spotfire report and used automation services to send a screenshot of the report out a couple of times in the morning to interested parties.

[[{"fid":"86616","view_mode":"default","attributes":{"height":"249","width":"697","class":"media-element file-default"},"fields":{"format":"default","field_file_image_alt_text[und][0][value]":"","field_file_image_title_text[und][0][value]":""},"type":"media"}]]

This SQL query returns status for all scheduled updates.

select CASE J1.status
  WHEN 1 THEN 'LOADING'
  WHEN 3 THEN 'FAILED'
  WHEN 5 THEN 'COMPLETE'
  END as Status,
J1.name,
R1.ENTITY_VALUE,
J1.LAST_MODIFIED as Last_Load_Time

from JOB_INSTANCES_DETAIL_VIEW J1
inner join (
Select max(last_modified) as maxlast_modified, routing_rule_ID from JOB_INSTANCES_DETAIL_VIEW
group by routing_rule_ID 
) J2
ON J1.ROUTING_RULE_ID = J2.Routing_Rule_ID and J1.LAST_MODIFIED=j2.maxlast_modified
Left join ROUTING_RULES R1
ON J1.ROUTING_RULE_ID= R1.ID
order by J1.Name

 

 

david_walker - Nov 22, 2016 - 9:22am ::
+ Add a Comment

(2) Answers

Login