Monitoring Report Queries

InetSoft's Style Intelligence provides a simple interface for report queries that allows users with minimal experience to full access to administrative level tools. View the information below to learn more about this powerful reporting software.

The 'Queries' page under the 'Monitoring' node provides key information about queries currently executing on the server. In a clustered environment, select a machine from 'Cluster Node' menu to view the monitoring statistics for that machine. The page provides the following information:

More Report Examples

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index

Query ID	A unique identifier.
Data Objects	The number of dataset rows cached in memory or disk.
Thread	The thread within which the query is executing. Click the link to obtain a stack trace.
Name	The name of the query, or of the worksheet/data model executing the query.
Asset	The name of the report or Viewsheet from which the query was executed.
User	The user who executed the query.
Rows	The number or query rows that have been processed. (Requires 'Monitoring Level' set to 'Medium' on the 'Settings' page.)
Age	The length of time that the query has been executing.

“We evaluated many reporting vendors and were most impressed at the speed with which the proof of concept could be developed. We found InetSoft to be the best option to meet our business requirements and integrate with our own technology.”

- John White, Senior Director, Information Technology at Livingston International

To terminate an executing query, click the corresponding 'Select' box to select the query, and then click the 'Remove' button.
The 'Cache' page under the 'Monitoring' node provides key information for both the report cache and the data cache. In a clustered environment, select a machine from 'Cluster Node' menu to view the monitoring statistics for that machine. The page provides the following information:

Pages	The number of report pages cached in memory or disk.
Data Objects	The number of dataset rows cached in memory or disk.
Hits	The number of cache hits. A hit occurs when a query is performed against the cache and a match is found. (Requires 'Monitoring Level' set to 'High' on the 'Settings' page.)
Misses	The number of cache misses. A miss occurs when a query is performed against the cache and no match is found. (Requires 'Monitoring Level' set to 'High' on the 'Settings' page.)
Swapped	The number of bytes swapped from disk to memory, or from memory to disk. (Requires 'Monitoring Level' set to 'Medium' on the 'Settings' page.)

Previous: Report Generation

Next: Monitoring User Reports