Words and Phrases
Use Table Views
Table views display data in tabular format. Each row displays data about one object. If there are more rows than fits on a single screen, you can scroll through the table view using the scroll bar.
If a table contains more rows than the maximum limit set for a table, filter your table view to reduce the number of rows. See Use the View Toolbars for more information about how NNMi indicates the table has exceeded the maximum limit specified. See Filter a Table View for information about how to filter a table view.
From a table view, in addition to the tasks accessed with the view display panel toolbar, you can perform the following tasks:
- Resize a Column
- Hide a Column
- Display a Hidden Column
- Select all Rows in a Table
- Sort Column Data
- Stop Periodic Refresh of a View
- Filter a Table View
- Restore Table Defaults
- Export Table Information
- Limits to View Settings
The following customizations are saved across browser sessions:
- Column width
- Hidden columns
- Sort column and order
- Column filters
- Quick filter value
- Node or interface group filter
- Time period filter (for incidents)
Resize a Column
You can resize columns using your mouse.
To resize a column in the table:
- Mouse over the edge of the column until you see a ↔ resize icon.
- Drag the column edge to the width you want.
Hide a Column
If you find you no longer want to include a column of information in your view, you can hide a specified column.
To hide a table column:
-
Right-click the column of interest.
-
Select Visibility.
The list of column names appears.
- Click to clear the check box
that precedes the name of the column you want to hide.
Display a Hidden Column
If you want to display a hidden column.
To display a hidden table column:
-
Right-click the column of interest.
-
Select Visibility.
The list of column names appears.
- Click to check the check box
that precedes the name of the column you want to display.
Select all Rows in a Table
If you want to select all rows in a table.
To select all rows in a table:
- Select any row in the table.
-
Do one of the following:
- Press Ctrl-a.
- Right-click any row in the table view, and select Select All.
- The table view data appears highlighted.
Related Topics
Sort Column Data
By sorting columns, you can get the most important information at the top of your table. For example, at times you might want to view all critical nodes. At other times, you might need to find node contact information.
To sort by columns:
- Right-click the column heading or data cell on which you want to sort.
- To sort the column in ascending order, select Sort: → Ascending
- To sort the column in descending order, select Sort: → Descending
When sorting column data, note the following:
- You can click the column header to initiate a sort on the column values. Clicking the column heading again, reverses the sort direction.
- Network Node Manager i Software Smart Plug-ins (iSPIs) might provide table views in which sorting is disabled for one or more columns.
- Sorting tables that contain large amounts of data (for example, viewing all interfaces or incidents), can sometimes result in slow response times. In this case, it is better to first filter the table information so that it contains only the values of interest before performing your sort.
More About Sorting
When sorting table columns, note the following:
- You can sort on only one column heading at one time.
-
Capital letters are sorted separately from lowercase.
The Assigned To column in incident views is sorted in alphabetical order according to the language locale that is set for the NNMi management server. When determining alphabetical order, NNMi uses the user display name rather than the actual login name and does not sort capital letters separately from lowercase. If you are an NNMi administrator, you can set the language locale for the sort order using the
server.propertiesfile. See the "Maintaining NNMi" chapter of the Network Node Manager i Software Deployment Reference at https://softwaresupport.softwaregrp.com/ for more information. The default sort locale value is English (en_US). -
NNMi sorts some table columns using lexicographical ordering. This might produce unfamiliar orders for strings such as Object IDs that contain numbers. For example you might expect the following order when sorting the
sysObjectIDdata type:- 1.3.6.1.4.1.1
- 1.3.6.1.4.1.3
- 1.3.6.1.4.1.20
Using lexicographical ordering, these system object ID values are ordered as follows:
- 1.3.6.1.4.1.1
- 1.3.6.1.4.1.20
- 1.3.6.1.4.1.3
- Some table columns, such as Status and ifType, display data types which have a natural sort order that is distinct from an alphabetical order. When sorting these columns, the values are sorted according to a natural or pre-determined order rather than alphabetically. For example when sorting the Status column, you always see the following order (ascending) or the reverse (descending): Critical, Major, Minor, Warning, Unknown, Disabled, Normal, and No Status.
- Your sort choices are saved across user sessions.
Stop Periodic Refresh of a View
You can manually stop the periodic refresh of the group of items displayed in a table view at any time.
The status of this group of objects is always updated on a regular basis, you are only stopping updates based on network objects being added or deleted from the NNMi database.NNMi's status bar displays the refresh rate and whether the refresh rate has been disabled.
To stop the periodic refresh of a table view:
In the view toolbar, click the
Stop Periodic Refresh icon. The following message displays in the Status Bar at the bottom-right corner of the table:
If you want to restart the refresh rate, click the
Refresh icon in the view toolbar. The following message displays in the Status Bar at the bottom-right corner of the table:
You cannot change the refresh rate. NNMi sets that default rate for each view.
Filter a Table View
When using table views, you can reduce the amount of information displayed by filtering a view using one of the object's attribute values. For example, you can access only those incidents that have a Status of Critical, or only those incidents that have a Description that is Interface Down.
Filtering a table view is also useful to reduce the number of rows when a table contains more rows than the maximum limit set for a table. See Use the View Toolbars for more information about how NNMi indicates the table has exceeded the maximum limit specified.
When a view is first displayed, it displays a set of filtered columns based on the view definition provided by NNMi.
The view status bar indicates if one or more filters have been set for the view. FILTER:ON indicates that one or more filters have been set. These are filters that you can modify. In some views, NNMi provides factory set filters that cannot be changed. For example, the My Open Incidents view is filtered on the Assigned To attribute, which cannot be changed. FILTER:OFF indicates no modifiable filters have been set for the view. These views might have factory set filters.
When specifying filters, you can perform the following tasks:
- Filter Tables by Node or Interface Group
- Filter by Time Period (Incident Views Only)
- Filter by Attribute Value
- "Modify a Table View Filter"
- "Remove a Filter"
- "Restore Default Filters"
- "Display Current Filter Settings"
When using filters, note the following:
- You can filter on multiple table columns. The resulting filter is a logical AND of the filters for all of the columns.
- Network Node Manager i Software Smart Plug-ins (iSPIs) might provide table views in which filtering is disabled for one or more columns.
- NNMi matches to the milliseconds when filtering on columns that represent time values (for example, Last Occurrence). Therefore, only those times that match to the milliseconds are included in your view. Try using the less than or equal or greater than or equal filter options to include a wider range of time values.
- NNMi restricts certain filter operations or options per data type. Only the filter options that apply to the attribute data type appear. The data types and valid filter options are described in the table below.
- A different subset of these filter options appears depending on whether you are clicking a data cell, a column header, or a blank row. A data cell filter menu includes filters that use the value of the selected data cell.
| Data Type | Valid Filter Options |
|---|---|
| All data types | Equals this value Not equal to this value |
Text (String) Numeric Enumerated List IP Address Date and Time | Create Filter... |
| Boolean data types | Is true Is false |
| Numeric (Integer, IP address, and date) | Greater than or equal to this value Less than or equal to this value |
| Data Type | Valid Filter Options |
|---|---|
| Group Filter | Provides a drop-down menu in the view display panel toolbar of the node and interface groups available to you. |
| Quick Filter | Provides a drop-down menu in the view display panel toolbar of all of the possible values for an attribute. These drop-down menus are provided for table views that include "by" in the view name. |
| Time Period Filter | Provides a drop-down menu in the view display panel toolbar in incident views. This filter lists a variety of time periods for which you can filter your incident views. Possible values include: Last 5 minutes, Last Hour, Last 8 Hours, Last Day, Last 3 Days, Last Week, Last Month, and All. |
NNMi lets you filter your table views by node or interface group. For example, you might want to view all of the important Cisco routers, or all of the Voice-Over-IP interfaces within your network.
Your NNMi administrator creates these groups. They are listed in a "group selector" drop-down menu list on the view toolbar as shown below:
Node Group filters are available for:
- Node views
- Interface views
- IP address views
- Incident views
- Node Sensor views
- Physical Sensor views
Interface Group filters are available for:
- Interface views
- IP Address views
- Card views
To filter a view by Node or Interface Group:
Navigate to the view of interest.
- From the workspace navigation panel, select the workspace that contains the view you want to use; for example, Inventory.
- Select the view of interest; for example, Interfaces.
- In the group selector drop-down list, select the Node Group or Interface Group you want to use as a filter.
When using Node Group or Interface Group filters, note the following:
- By default, table views are not filtered by Node or Interface Group.
- If a view can be filtered by both Node Group and Interface Group, the selection box lists the Node Groups first, followed by the Interface Groups. Each list appears in alphabetical order.
- When the filter is applied, the view automatically refreshes to show the appropriate set of objects.
- If you set a Node Group or Interface Group filter, NNMi combines the group filter with any other filters using the AND Boolean operator.
- To clear the group filter, return the selection value to "<Set node group filter>" or "<Set node or interface group filter>".
When monitoring your network, you might be interested in only viewing information for a particular set of nodes or interfaces. Your network administrator can group sets of nodes or interfaces into node or interface groups. An example Node Group could be all important Cisco routers, or all routers in a particular building. As another example, all interfaces used for Voice-Over-IP might be grouped together in your network.
Your administrator configures Node Groups based on any of the following:
- Vendor or model SNMP object identifiers.
- Specific devices identified by name or IP address.
- Devices identified with wildcard characters to define a Node Group. These groups might be based on a naming strategy that is set in place for your organization.
You can display the definition of a group:
Node Group definitions
- From the workspace navigation panel, select the Inventory workspace.
- Select the Node Groups view.
- Double-click the row representing the Node Group.
- The Node Group form displays.
- When finished, click the
Close icon.
Interface Group definitions
- From the workspace navigation panel, select the Inventory workspace.
- Select the Interface Groups view.
- Double-click the row representing the Interface Group.
The Interface Group form displays.
Interface group definitions match the way your team identifies important network devices. Each interface group can include one or more interface-type specifications (based on industry-standard IANA ifType-MIB variables).
- When finished, click the Close icon.
Special Actions are provided for Node Groups and Interface Groups. See Using Actions to Perform Tasks.
Filter by Time Period (Incident Views Only)
Incident views enable you to filter your view by time period. Filtering using the time period filter lets you focus on the most recent incidents of interest. The available time periods include:
- Last 5 Minutes
- Last Hour
- Last 8 Hours
- Last Day
- Last 3 Days
- Last Week
- Last Month
- All
A month is defined as 31 days.
When specifying filters based on attribute (column) values, some filter options require that you specify the value by selecting the value in an object instance and some require that you open a Create Filter... dialog to specify the value. You can also specify a filter based on whether an attribute contains a value.
The following filter options require an attribute value as the basis for the filter.
When using the filter options listed below, first right-click the value in the table on which you want to filter.You can change a filter at any time. NNMi saves filters per user so that the filters you specify are maintained during subsequent user sessions.
To filter your view by selecting an attribute value in the table:
- Right-click the attribute value on which you want to base your filter.
Select one of the following filter options:
- Equals this value
- Not equal to this value
- Greater than or equal to this value
- Less than or equal to this value
- Is true
- Is false
NNMi displays a table view of all instances that have been selected based on the filter option and attribute values you specified or selected.
Each filtered column is indicated using the
filter icon.
Create a Filter to Specify Values
NNMI enable you to provide attribute values on which you want to filter. You can provide attributes values by creating a filter for any of the following types of values:
- Text (String)
- Numeric
- Enumerated List
- IP Address
- Date and Time
To filter information by specifying one or more values:
- Right-click the column or attribute on which you want to filter.
Select Create filter...
NNMi displays the Filter Dialog that is appropriate for the selected column's data type.
In the Create Filter ... Dialog displayed:
- Select a Filter Option (see Filter Option tables) .
Specify one or more valid values (see Valid Filter Values)
If your NNMi administrator is using Lightweight Directory Access Protocol (LDAP) to store user name information, NNMi shows the configured display name in the Incident Assigned To column, but internally stores the user name that identifies the user account. To specify a filter for the Incident Assigned To column, do one of the following:
- Specify the user name as the filter value.
- Right-click the Assigned To on which you want to filter. Then, select Filter > Equals this value or Filter > Not equal to this value. NNMi creates the filter using the stored user name value.
If you are an NNMi administrator, see the "Maintaining NNMi" chapter in the Network Node Manager i Software Deployment Reference for more information about configuring the Incident Assigned To display name.
Click Apply.
NNMi displays a table view of all instances that have been selected based on the filter option and attribute values you specified or selected.
Each filtered column is indicated using the
filter icon.
| Filter Option | Description |
|---|---|
equals | NNMi displays only instances that contain the numeric value or values you specify. |
not equals | NNMi displays only instances that have an attribute value that does NOT contain the numeric value or values specified. For certain attributes, this option can also filter values that are "empty" or null. |
| greater than or equal to | NNMi performs an alphabetical (lexicographical) comparison and displays all text string values that are after the text string value you enter. |
| less than or equal to | NNMi displays all values that are less than or equal to the numeric value you enter |
| Filter Option | Description |
|---|---|
equals | NNMi displays only instances that contain the value or values you select. |
not equals | NNMi displays only instances that have an attribute value that does NOT contain the value or values you selected. For certain attributes, this option can also filter values that are "empty" or null. |
| Filter Option | Description |
|---|---|
| equals | NNMi displays only instances that contain the IP Address value you specify. |
| range | NNMi displays only instances that are within the IP Address range you specify. |
| is empty | NNMi displays only the instances that do not have a value for this attribute. |
| is not empty | NNMi displays only the instances that contain a value for this attribute. |
| Filter Option | Description |
|---|---|
| on or after | NNMi displays only instances that have date and time values that occur on or after the date and time you specify. |
| on or before | NNMi displays only instances that have date and time values that occur on or before the date and time you specify. |
| between | NNMi displays only instances that have date and time values that occur after the first date and time you specify and before the second date and time you specify. Use the between operator when you want to filter on instances that occur within a specified hour or day. |
Use Null Value Filters
NNMi provides the following filter options to filter your view based on whether the attribute contains a value. These filter options appear for data types that do not require a value:
- Is not empty
- Is empty
To filter your view based on null values:
- Right-click the column or attribute value on which you want to filter.
- Select from the filter options described in the table below.
NNMi displays a table view of all instances that have been selected based on the filter option and any attribute values you specified or selected.
Each filtered column is indicated using the
filter icon. You can change a filter at any time. NNMi saves filters per user so that the filters you specify are maintained during subsequent user sessions.
| Filter Option | Description |
|---|---|
Is not empty | NNMi displays only the instances that contain a value for this attribute. |
Is empty | NNMi displays only the instances that do not have a value for this attribute. |
You can change a filter for a table view at any time. NNMi saves filters per user so that the filters you specify are maintained during subsequent user sessions.
To modify a filter :
- Right-click the column or attribute on which you want to filter.
Select Modify filter...
Note the following:
- If a filter is not created for the selected table column, the Modify filter.... option does not appear.
- If you have used an existing attribute value with the Not equal to this value filter, you can select an additional attribute value and select Not equal to this value also.
NNMi displays the filter dialog that is appropriate for the selected column's data type. If the filter was created using the “Not equal to this value” option with the Text (String) or IP address data type, NNMi does not include the values for the current filter.
In the Modify Filter ... dialog displayed:
- Select a Filter Option (see Filter Option tables) .
- Specify one or more valid values (see Valid Filter Values)
Click Apply.
NNMi replaces the previous filter with the new filter values. NNMi displays a table view of all instances that have been selected based on the filter option and attribute values you specified or selected.
Each filtered column is indicated using the
filter icon.
| Filter Option | Description |
|---|---|
| equal | NNMi displays only instances that contain the numeric value or values you specify. |
| not equal | NNMi displays only instances that have an attribute value that does NOT contain the numeric value or values specified. |
| greater than or equal | NNMi performs an alphabetical (lexicographical) comparison and displays all text string values that are after the text string value you enter. |
| less than or equal | NNMi displays all values that are less than or equal to the numeric value you enter. |
| Filter Option | Description |
|---|---|
| equal | NNMi displays only instances that contain the value or values you select. |
| not equal | NNMi displays only instances that have an attribute value that does NOT contain the value or values you selected. |
| Filter Option | Description |
|---|---|
| equal | NNMi displays only instances that contain the IP Address value you specify. |
| range | NNMi displays only instances that are within the IP Address range you specify. |
| Filter Option | Description |
|---|---|
| on or after | NNMi displays only instances that have date and time values that occur on or after the date and time you specify. |
| on or before | NNMi displays only instances that have date and time values that occur on or before the date and time you specify. |
| between | NNMi displays only instances that have date and time values that occur after the first date and time you specify and before the second date and time you specify. Use the between operator when you want to filter on instances that occur within a specified hour or day. |
NNMi lets you remove a filter for a selected column at any time.
To remove a filter:
- Right-click the column that has a filter that you want to remove.
- Select Remove filter from the drop-down menu.
NNMi removes all existing filters that have been set for that column.
You can restore the default filters for a view. This option removes any filters that you have defined for the current view.
To restore the default filter settings:
In the table toolbar, click the 
Restore Default Filters icon.
Show View In New Window icon, and then click the Restore Default Filters icon.All filters are reset to the default values and any filters that you have created are removed for the current view.
You will lose any selections you have in the view.Display Current Filter Settings
To keep track of the filters you have created, you can view the filter that has been set on a column by column basis.
To view a column's filter:
Mouse over the column of interest.
The example below shows the filter option and the string provided for that filter:
The following table explains the symbols used for each filter option
| Symbol | Filter Option |
|---|---|
<= | Less than or equal to this value |
>= | Greater than or equal to this value |
= | Equals this value |
NOT IN | Not equal to this value |
IS NULL | Is empty |
IS NOT NULL | Is not empty |
LIKE | Contains string... Starts with string... Matches string... |
Restore Table Defaults
You can remove the types of table view customizations described in the following table. Remove customizations when you no longer find them useful or when you reach the limit for the maximum number of customizations that can be stored.
If you are concerned about reaching your table view settings limit, remove view settings for tables that are not important.
The Restore Default Filters icon does not appear on table views in forms. If you want to clear settings from a table view that appears in a form, use the Show View in New Window icon to open the table view in a new window and perform these operations.| What You can Remove | How | Description |
|---|---|---|
| Only table view filters | From the view display panel toolbar, select Restore Default Filters. | Clears all customizations to filters for the table view and refreshes the view with the view's default filter settings. |
| All customizations for all table views | Select View → Restore All Default View Settings | Clears all customizations (and cookies) for all table view customizations. |
Export Table Information
You can export the contents of a table view for use in other applications. You can choose to export only the rows that are selected or all of the rows in your table.
You must have a minimum of Operator Level1 Role to export table information.When printing table information, note the following:
- The first column of table information does not appear in the exported version. The contents of this column is for selection purposes only.
- You can copy and paste the table data to other applications, such as Microsoft Excel, for additional editing and manipulating, such as getting a list of hostnames.
To export selected table rows:
- Select the row or rows that you want to export.
- Right-click a selected row.
Select Export to CSV.
NNMi displays the Export to CSV dialog.
- To included the table column headings in the exported data, click to check Include Column Headings.
NNMi stores date and enumerated values in both localized (Jul 12, 2010 10:07 AM) and raw (1278950859739) format. By default, NNMi exports only the localized (human readable) format for date and enumerated values.
Select the Use Localized (Human Readable) Data option to include only the localized (human readable) format for both dates and enumerated values.
Select the Use Raw (Computer Readable) Data option to include only the raw (computer readable) format for both date and enumerated values.
In the Opening <file_name> dialog, select one of the following options.
- Open with to view the file contents.
- Save File to save the file to a specified file name.
To export all table rows:
- Right-click any cell or column header with the table.
- Click Select All.
- Right-click a row.
Select Export to CSV.
NNMi displays the Export to CSV dialog.
- To included the table column headings in the exported data, click to check Include Column Headings.
NNMi stores date and enumerated values in both localized (Jul 12, 2010 10:07 AM) and raw (1278950859739) format. By default, NNMi exports only the localized (human readable) format for date and enumerated values.
Select the Use Localized (Human Readable) Data option to include only the localized (human readable) format for both dates and enumerated values.
Select the Use (Computer Readable) Raw Data option to include only the raw (computer readable) format for both date and enumerated values.
In the Opening <file_name> dialog, select one of the following options.
- Open with to view the file contents.
- Save File to save the file to a specified file name.
Limits to View Settings
NNMi automatically saves the following kinds of table view settings:
- Column width
- Hidden columns
- Sort column and order
- Filters
When customizing table views, note the following:
- All settings for each table are stored in a corresponding cookie for that table.
The number of tables that have settings that can be saved, and the behavior when the limit is reached depends the browser you use:
Microsoft Internet Explorer discards your oldest cookie and lets you continue creating customizations. If you are using Microsoft Internet Explorer, the cookie limit is 48.
If you are using Mozilla Firefox, the cookie limit is 48. If you reach the 48 limit, Mozilla Firefox removes the next to last cookie before saving the latest cookie created.
- Table view settings are specific to each operating system user. Therefore, if you log on as a different operating system user, you will have different view settings. If you sign into NNMi as a different NNMi user, but as the same operating system user, you will have the same view settings.
You can remove the customizations for all of your tables using the View → Restore All Default View Settings. See Restore Table Defaults for more information.