Information/ Details as When and Who created a Cache Rule in Spotfire 10.1

[Sneha Acharya]

Hi,

 

Does any know how to retrieve the information as of when a cache rule was initially created (date timestamp)and who (userid/name) created it. This information is not available on Spotfire Admin Console on browser. And I tried to look in Spotfire_Server DB but the only information I got was when was the cache rule last_modified.

 

Regards,

Sneha

[Prashant Anand]

You can check schedule rule id in "ID" column under "ROUTING_RULES" table. You can then check created and modified date for this "ID" under "LIB_ITEMS" table.

[Sneha Acharya]

Hi Prashant,

Thanks for responding to the post, but unfortunately there were no records in LIB_ITEM tables for scheduling/cache rules.The query I used (below)didn't retrieve any records from the LIB_ITEM table.

SELECT TOP 1000 [iTEM_ID]

,[TITLE]

,[DESCRIPTION]

,[iTEM_TYPE]

,[FORMAT_VERSION]

,[CREATED_BY]

,[CREATED]

,[MODIFIED_BY]

,[MODIFIED]

,[ACCESSED]

,[CONTENT_SIZE]

,[PARENT_ID]

,[HIDDEN]

FROM [spotfire_Server].[dbo].[LIB_ITEMS] as l,

[spotfire_Server].[dbo].[ROUTING_RULES] as r

where l.ITEM_ID = r.ID

 

 

Regards,

Sneha