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"
     ,"CachedSince"
 FROM "Parameter" WHERE "Type" = 5

The following query shows last modification date, number of entries and the person that did the last modification for all datastore parameters:

 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
    ,"LastModifiedDate"
    ,"LastModifiedByPersonId"

,(select UniqueId from Person where person.id = LastModifiedByPersonId) as LastModifiedByUniqueId

    ,(select count(*) from ParameterData where parameter_id = Parameter.ID) as NrOfEntries
 FROM "Parameter"