How to list all dataconnections which are saved in Spotfire library?

How to list all dataconnections which are saved in Spotfire library?

All  content which you save to Spotfire library is stored in a Spotfire database.You can find list of all "dataconnections" saved to Spotfire library by querying "LIB_ITEMS" joined with table "LIB_ITEM_TYPES" or via search expression in Library Administration Tool. Solution#1: Run the following query on the Spotfire Database
---------------------------
select a.* from dbo.LIB_ITEMS a,dbo.LIB_ITEM_TYPES b where a.ITEM_TYPE=b.TYPE_ID and b.LABEL='dataconnection'
---------------------------

Note: The above query was tested on MSSQL Server Spotfire database. 

Solution#2:  Search for "type:dataconnection" in Spotfire Library Administration tool  as mentioned in the attached screenshot.