Database Table: Software Usage

Note: Available categories and options may vary depending on the products and components installed.

The Software Usage table, INFOHIS, stores information about the offline software usage.

This table contains the following columns:

ACID

Includes the Action ID.

Example:

MHISAC_PREVENTED = 0

MHISAC_NORMAL_NORMAL = 1

MHISAC_WARNING_NORMAL = 2

MHISAC_NORMAL_ABNORMAL = 3

MHISAC_WARNING_ABNORMAL = 4

MHISAC_QUEUED_GRANTED = 5 (The number of minutes the user was in queue for this application.)

MHISAC_NORMAL_INACTIVITY = 6, (Started normal, Inactivity stop.)

MHISAC_WARNING_INACTIVITY = 7 (Started with warning, Inactivity stop.)

APFLAG

Indicates whether the software usage entry was collected by the engine or by importing online data.

DOMAIN_UUID

Includes the UUID of the domain instance.

ENDDATE

Includes the date when the application was last stopped

ENDTIME

Includes the time when application was last stopped

ENDTOTAL

Includes the total of ENDTIME, seconds since 1970.1.1.

OBJECT_TYPE

Includes the type of object.

Example: ca_discovered_hardware=1, ca_discovered_user=2.

OBJECT_UUID

Object UUID. Foreign key to either ca_discovered_hardware or ca_discovered_user depending on object_type.

STDATE

Includes the start date when application was launched

STTIME

Includes the start time when application was launched

STTOAL

Includes the start date and time

SW_DEF_UUID

Includes the software definition UUID of the monitored application.

SW_DOMAIN_UUID

Includes the software domain UUID of the monitored application.

More information: