Tables are the default chart type for viewlets. All data imported will display, unless a schema is used. In table viewlets, schemas control what columns are displayed and in what order (see how to configure the layout of a dashboard). Use the scroll bar at the bottom of the viewlet to view additional columns. Columns can also be expanded by hovering over the line separators within the header sections.
Click columns headers to sort the data in ascending () or descending () order.
Viewlets with a lot of data to display will have multiple pages. Use the left and right arrows to easily navigate through the pages. The First and Last Page buttons allow users to quickly jump to the first and last pages. Use the Previous and Next Page buttons to navigate through each page. Enter a page number to load a specific page.
Click on any of the data records to view additional details in a new viewlet within the Console section.
Users can create a customized table with specified columns and column order. Use ‘fields’ and ‘order by <field name> asc’ or ‘order by <field name> desc’ expressions (asc is ascending order and desc is descending, see Other jKQL Queries for more information on jKQL sorting options).
The following is an example:
jKQL > Get activities fields ParentID, ActivityID, EventID order by ParentID desc
This query will produce a table composed of three columns in the order specified in the query. The data will be sorted by the ParentID column in descending order.
Table columns can also be rearranged manually. Simply click and drag a column header to the new desired position.
Table menu options
Users have different options to dig deeper into the data of table. Select all desired records or use the top box to select all records. A pop-up menu appears. Select an option from the pop-up menu to view additional data details within the Console section.
Tables generated by jKQL queries with the following expressions will not have a pop-up menu: snapshots, logs, actions, active users, count of/number of, token, organization, teams, repository, set, license, fields, items, relatives, provider types, keywords, parameter, dictionary, features, access token, IP location, resource, group by.
A viewlet containing activities (Get activities) will have the following menu options: Events, Related, Parent, Topology, Root Cause (available only for severity status of Error, Halt, Failure, Fatal or Critical), Children (available when one or more activities with children are selected), Compare (available only when more than one line is selected).
The pop-up menu options depend on the data type. A viewlet containing events (Get events) will have the following menu items: Related, Parent, Analyze, Topology, Compare (available only when more than one line is selected).
After selecting an option on the pop-up menu, a new viewlet related to the option selected will open in the Console section.
If Events, Related, Parent, Children or Analyze were selected, the data will display in a table by default. You can modify the jKQL query to customize the viewlet. These tables have their own pop-up menus which allow users to dig deeper into data. Every selection from the pop-up menu will open a new viewlet within the Console section.
After selecting Events from the activities’ table pop-up menu, the separate Events viewlet in the Console section is generated. The tab name is the selected menu option and the name of the main viewlet. The records of the Events viewlet have also a pop-up menu with multiple options.
The below figure is the viewlet that appears when Related is selected from the pop-up menu of the Events_Event Severity tab. The table displays events which have the same selected Activity ID(s).
Select Parent from the pop-up menu to open a viewlet which displays parent activities (activities with a greater hierarchical status) of the selected activities or events. Only items with values within the ParentID column will have a Parent menu option on the table’s pop-up menu.
The parent activities of other activities or events will display. An activity without a ParentID means that it is the prime activity with the highest hierarchical status.
Select Topology in the table pop-up menu to generate a topology viewlet using the selected items within the Console section.
When selecting activity table records with a severity status of Error, Halt, Failure, Fatal or Critical, Root Cause will be an option on the pop-up menu. Clicking this will open a viewlet in the Console section displaying a topology. The topology will allow you to dig deeper into the data and find the root cause of the issue.
Select Children from the pop-up menu to open a viewlet which displays child activities. Please note that not every data record will have child activities and will therefore not have the Children option in the pop-up menu. Activities or events of an activity will display.