Job Management Partner 1/Software Distribution Description and Planning Guide

[Contents][Glossary][Index][Back][Next]

Appendix C.45 netmdm_monitoring_security

This table stores the suppress history and operation history that are managed in the Operation Log List window.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_nodename VARCHAR2 64 varchar 64 MVARCHAR 64 Node name --
dm_hostname VARCHAR2 64 varchar 64 MVARCHAR 64 Host name --
dm_ipaddress VARCHAR2 15 varchar 15 MVARCHAR 15 IP address --
dm_startdate DATE -- datetime 8 TIMESTAMP -- Event start time --
dm_enddate DATE -- datetime 8 TIMESTAMP -- Event end time --
dm_eventtype NUMBER 10 int 4 INTEGER -- Event type:
  • 0x00000001: Start process
  • 0x00000002: Stop process
  • 0x00000003: Change caption
  • 0x00000004: Change active window
  • 0x00000005: Start PC
  • 0x00000006: Stop PC
  • 0x00000007: Log on
  • 0x00000008: Log off
  • 0x00010010: Copy file
  • 0x00010011: Move file
  • 0x00010012: Rename file
  • 0x00010013: Delete file
  • 0x00010014: Create file
  • 0x00010015: Open file
  • 0x00020010: Copy folder
  • 0x00020011: Move folder
  • 0x00020012: Rename folder
  • 0x00020013: Delete folder
  • 0x00020014: Create folder
  • 0x00030001: Print
  • 0x00030002: Printing suppression
  • 0x00030003: Print suppression released
  • 0x00040001: Web access
  • 0x00050001: External media connection
  • 0x00050002: External media disconnection (removal)
  • 0x00060001: USB connection permission
  • 0x00060002: USB connection suppression
  • 0x01000000: Suppress history
--
dm_filename VARCHAR2 520 varchar 520 MVARCHAR 520 File name or folder name before operation.
(The file name or folder name is converted to lower-case letters and its full path is stored. A folder name ends with \.)
--
dm_filenamenew VARCHAR2 520 varchar 520 MVARCHAR 520 File name or folder name after operation.
(The file name or folder name is converted to lower-case letters and its full path is stored. A folder name ends with \.)
--
dm_productname VARCHAR2 50 varchar 50 MVARCHAR 50 Name of the product used --
dm_productversion VARCHAR2 50 varchar 50 MVARCHAR 50 Product version --
dm_productlanguage NUMBER 10 int 4 INTEGER -- Product language.
(If the language is unknown, NULL is set)
--
dm_fileversion VARCHAR2 50 varchar 50 MVARCHAR 50 File version --
dm_filelanguage NUMBER 10 int 4 INTEGER -- File language.
(If the language is unknown, NULL is set)
--
dm_logonuser VARCHAR2 128 varchar 128 MVARCHAR 128 Logon user --
dm_execaccount VARCHAR2 128 varchar 128 MVARCHAR 128 Program's execution account --
dm_caption VARCHAR2 520 varchar 520 MVARCHAR 520 Window caption --
dm_processname VARCHAR2 520 varchar 520 MVARCHAR 520 The following information is stored:

For software operation history:
Name of the process that resulted in the event

For file operation history:
Name of the process that manipulated file

For software start suppression:
Name of the program that suppressed the start
--
dm_drivetypeold NUMBER 10 int 4 INTEGER -- Drive type before operation:
  • 0: Other
  • 1: Local disk
  • 2: Network drive
  • 3: Removable
  • 4: CDROM
  • 5: RAMDISK
--
dm_drivetypenew NUMBER 10 int 4 INTEGER -- Drive type after operation:
  • 0: Other
  • 1: Local disk
  • 2: Network drive
  • 3: Removable
  • 4: CDROM
  • 5: RAMDISK
--
dm_documentname VARCHAR2 260 varchar 260 MVARCHAR 260 Name of the document that became the target of printing or printing suppression --
dm_printername VARCHAR2 484 varchar 484 MVARCHAR 484 Name of the printer used for printing --
dm_printingresult NUMBER 3 tinyint 1 SMALLINT -- Result of print operation suppression cancellation:
  • 0x00: Successful
  • 0x01: Failed
--
dm_url VARCHAR2 2,083 varchar 2,083 MVARCHAR 2,083 URL of the accessed Web page --
dm_drivetype NUMBER 10 int 4 INTEGER -- Drive type of the external media that was connected or disconnected (removed):
  • 0x0000: Other
  • 0x0001: Local disk
  • 0x0003: Removable
  • 0x0004: CDROM
--
dm_drivename CHAR 2 char 2 CHAR 2 Drive name of the external media that was connected or disconnected (removed).
Two letters are used to indicate the drive name.
--
dm_usbconnectname VARCHAR2 1024 varchar 1024 MVARCHAR 1024 Connect name of the device that was permitted or prevented from connecting --
dm_usbdiskdrive VARCHAR2 2048 varchar 2048 MVARCHAR 2048 Instance ID of the device that was permitted or prevented from connecting (disk drive) --
dm_usbcontroller VARCHAR2 2048 varchar 2048 MVARCHAR 2048 Device instance ID of the device that was permitted or prevented from connecting (USB controller) --
dm_usballowedcondition VARCHAR2 2069 varchar 2069 MVARCHAR 2069 Condition used for permitting device connection --
dm_devicetype NUMBER 10 int 4 INTEGER -- Type of device that was connected, disconnected, permitted, or prevented from connecting:
  • 0x0000: Unknown
  • 0x0001: USB storage device
  • 0x0002: Internal CD/DVD drive
  • 0x0003: Internal floppy disk drive
  • 0x0004: IEEE1394-connected device
  • 0x0005: Internal SD card
  • 0x0006: Bluetooth device
  • 0x0007: Imaging device
--

Legend:
--: Not applicable