Table Of Contents

History

History

---

Revised: July 24, 2009, OL-3743-42

The History (history) table stores a list of executed commands. A list of all executed commands can be sent to a file (report history), or displayed on the screen (show history).

Table Name: HISTORY

Table Containment Area: EMS only.

Command Types

Show and report

Examples

show history

report history

---

Note Using the command without any tokens returns all entries in the table.

---

Usage Guidelines

Primary Key Token(s): None.

Syntax Description

ADAPTER	The OSS adapter. User input is not modified prior to validation. VARCHAR(30): 1-30 ASCII characters. Permitted values are: CLI SPIT IOS MNT TEST GUI FTP SNMP SUP CORBA HTTP CRON QAM DBASE
AUTO-REFRESH	Specifies whether to display cached data on the screen. CHAR(1): Y/N (Default = Y). Y—Queries the database for the most current data. N—Queries the database for the most current data only if the cached data is unavailable.
DISPLAY	Specifies what token information to display on the screen. VARCHAR(1024): 1-1024 (Default = all tokens are displayed). Permitted values are any valid token that can be shown for this command. Multiple tokens can be entered by separating with a comma.
END-TIME	Ending time for history range. DATE/TIME: in the format: YYYY-MM-DD HH:MM:SS.
LIMIT	Specifies the number of rows to display on the screen. INTEGER: 1-100000000 (Default = 100000000). Note The actual maximum number of rows displayed is currently lower than 100000000 due to software limitations.
NOUN	The command noun. VARCHAR(50): 1-50 ASCII characters.
ORDER	Specifies whether to display data on the screen in a sorted order. VARCHAR(1024): 1-1024 (Default = all rows are displayed). Permitted values are any valid token that can be shown for this command. Multiple tokens can be entered by separating with a comma.
RESULT	The result of the command. VARCHAR(100): 1-100 ASCII characters.
SESSION	The login session ID. VARCHAR(30): 1-30 ASCII characters.
START-ROW	Specifies to begin displaying data on the screen at a specific row. INTEGER: 1-100000000 (Default = 1).
START-TIME	The starting time for history range. Start-time must occur before end-time. DATE/TIME: in the format: YYYY-MM-DD HH:MM:SS.
TRANSACTION-ID	The transaction id. VARCHAR(30): 1-30 ASCII characters.
USER	The user. VARCHAR(50): 1-50 ASCII characters.
USER-DOMAIN	The user domain. VARCHAR(100): 1-100 ASCII characters.
USER-INPUT	The command input. VARCHAR(100): 1-100 ASCII characters.
VERB	The command verb. VARCHAR(50): 1-50 ASCII characters.