External DataStores

this query gives all information of all datastore parameters which are of the type 'External Query'. It gives the name, Category, ConnectionString, SQLQuery, Refresh rate (in hours) & Last refresh timestamp

SELECT "Name"

     ,"Category"
     ,CASE "ConnectionTypeId"
            WHEN 0 THEN 'Internal'
            WHEN 1 THEN 'SQL Server'
            WHEN 2 THEN 'Oracle'
            WHEN 3 THEN 'Odbc'
            WHEN 4 THEN 'OleDb'
            END as ConnectionType
     ,"ConnectionString"
     ,"SqlQuery"
     ,"CacheTime"
     ,"CachedSince"
 FROM "Parameter" WHERE "Type" = 5