Spotfire Ideas Portal
It will be great to have LDAP synchronization status on Spotfire server interface. And it will be even better if this information was available in the Spotfire database (ACTIONLOG or dedicated table) in order to use it in an analysis (in order to send by mail the last status to support team and quickly investigate if KO).
Parsing the log files or redirect the logs to database is the only solution for the moment and it's not really convenient. If something standard, without any specific customization could be developed, thank you in advance.
While not perfect we use this query on the Spotfire Metadata database (Oracle in our case) which works fine on our heavy used domains. CUSTOM_CREATED_DATE_TIME is a custom field that defaults to SYSDATE. It''s not supported but we found no issues (and I doubt we will ever find one).
SELECT ROWNUM AS ID,
DOMAIN,
MAX_DATE_TIME,
HOURS_SINCE_LAST_UPDATE
FROM
(
SELECT UPPER(SUBSTR(DOMAIN_NAME, 1, INSTR(DOMAIN_NAME, '.') - 1)) AS DOMAIN,
TO_CHAR(CAST(GREATEST(NVL(MAX(LAST_MODIFIED_MEMBERSHIP), TO_DATE('1-Jan-1900', 'DD-Mon-YYYY')), MAX(CUSTOM_CREATED_DATE_TIME)) AS DATE), 'DD-Mon-YYYY HH24:MI') AS MAX_DATE_TIME,
ROUND((SYSDATE - CAST(GREATEST(NVL(MAX(LAST_MODIFIED_MEMBERSHIP), TO_DATE('1-Jan-1900', 'DD-Mon-YYYY')), MAX(RBS_CREATED_DATE_TIME)) AS DATE)) * 24) AS HOURS_SINCE_LAST_UPDATE
FROM USERS
GROUP
BY UPPER(SUBSTR(DOMAIN_NAME, 1, INSTR(DOMAIN_NAME, '.') - 1))
ORDER
BY 1
)