John Austin Posted February 18, 2022 Share Posted February 18, 2022 I want to get the following meta deta I formation, but need help with the queries. Total User Total Reports Reports Not-Used in last 30 days Reports Not-Used in last 90 days Total Size of Reports/Dashboards (GB) Top 10 Reports by Consumption Top 10 Reports by Size (MB) Least 10 Reports by Consumption Least 10 Reports by Size (MB) Reports by department Data sources Reports by each Datasource Report Refresh Frequency (Daily) Report Refresh Frequency (Weekly) Report Refresh Frequency (Monthly) Report Refresh Frequency (Hourly) Report Refresh Frequency (On-Demand) Subscriptions by Users Reports subscriptions Report Avg Load Time Size of Data Sets, Report Last Execution Date, Creation Date Report max and minimum loading type Count of active and inactive user Count of active user by department Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted February 25, 2022 Share Posted February 25, 2022 You also filed a Support ticket, which was answered based on your current license, which is a Cloud trial. For a more general answer here are some links to articles that can provide more details. NOTE: We do not officially support querying the back end database as changes could cause Spotfire to stop working, so a lot of these come with a warning. =========================== Here is the wiki article that a (former) skilled Spotfire admin wrote: https://community.spotfire.com/wiki/tibco-spotfire-metadata-queries At least some can be retrieved through ways possible. For the first two you can use the LibraryService, UserDirectory Web Service API Total User Total Reports https://docs.tibco.com/pub/spotfire_server/latest/doc/api/TIB_sfire_serv... https://docs.tibco.com/pub/spotfire_server/latest/doc/api/TIB_sfire_serv... For dxp's based on which Data source Reports by each Datasource To find the list of analysis files using Information Links where you know Information Link name: type: dxp depends_on(type::query InformationLinkName) To find the list of all analysis files that uses any Data connection: type:dxp depends_on(type:dataconnection) To find the list of all analysis files that uses any Data connection where the connection name is known: type:dxp depends_on(type:dataconnection title:SQL) The below KB articles might be of help to you. If the connections are stored in the library then they could be retrieved by querying the Spotifre Server database. https://support.tibco.com/s/article/How-to-query-the-TIBCO-Spotfire-data... https://support.tibco.com/s/article/How-to-identify-the-list-of-analysis... Application Profiler https://support.tibco.com/s/article/How-to-get-list-of-Table-Columns-and... More articles: https://support.tibco.com/s/article/How-to-query-the-TIBCO-Spotfire-data... https://support.tibco.com/s/article/How-to-identify-the-list-of-analysis... https://support.tibco.com/s/article/How-to-get-list-of-Table-Columns-and... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now