The Application Queries portlet enables you to view key information about the queries submitted by applications, based on the historical DBQL data in Teradata Database. You can review application queries designated as suspect based on thresholds set by a Viewpoint Administrator. You can view key metrics for any date for which query log data has been collected and retained by Viewpoint for the applications you have access to, and drill down to see details about specific queries. You can also view the trends of key performance indicators, aggregated daily or weekly and going back over a time frame from the last six months to two years, specific to an application and application version.
You can only see data in the Application Queries portlet if the optional query logging (DBQL) feature has been enabled in Teradata Database. The Application Queries portlet displays all queries that have been logged for the applications you have access to.
The Application Queries portlet does not participate in the rewind feature. The portlet provides a date selector to select the date of the query log information you want to view.