Spotfire Server: How to Analyze Metadata Related to the Usage of Library Favorites

Description:
I would like to analyze which users are using the Library Favorites feature and which library items they have marked as favorites. Is this type of metadata logged anywhere in Spotfire?

Resolution:
As of Spotfire 14.6 LTS, this metadata is not available out-of-the-box. It is not exposed through the Spotfire UI or standard usage logs.

However, you can retrieve metadata for Library Favorites directly from the Spotfire Server database.
The relevant entries are stored in the table LIB_PRINCIPAL_PROPS.

To extract only the records related to Library Favorites, filter on LIB_PRINCIPAL_PROPS.PROPERTY_NAME = 'spotfire.Favorite'.

These rows contain user-level metadata indicating which library items have been marked as favorites.

Example Record:

ITEM_ID: 46dd46fe-cd71-4046-ad74-9a7162ad4056
USER_ID: dfeac8e0-c0b7-4aa5-b5bc-aa1170557e47
GROUP_ID: abac999-c0b7-4bb5-b5bc-aa1173227e47
PROPERTY_NAME: spotfire.Favorite
PROPERTY_VALUE_JSON: (null)
CREATED: 2025-11-11 10:00:00

Disclaimer:
This is an undocumented/internal Spotfire data base table, and this can be changed at any time.