This table is typically used by Unicenter Asset Management. It stores information about application auditing. Agents with software auditing enabled will collect information about processes running on the system to the database. Information about each and every process is stored in this table.
Please note that auditing takes up quite some database storage and processing time, so it may be a good idea to limit the number of applications for auditing to a minimum.
Each entry describes both the starting time, ended time (termination) and total time of execution for the audited application.
Auditing is not limited to monitor the defined applications in the ca_software_def table only - so the table does not carry any sw_def_uuid foreign field around. Instead the filename of the application monitored is reported back (EXENAME, a string of 32 characters)
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_uuid | byte(16) | not null | Object Uuid. Foreign key to either ca_discovered_hardware or ca_discovered_user depending on object_type (1=ca_discovered_hardware,2=ca_discovered_user) |
| object_type | integer | with null | Object Type. 1=ca_discovered_hardware,2=ca_discovered_user |
| object_domain_uuid | byte(16) | with null | Object domain uuid. Foreign Key to ca_n_tier. Used for replication purposes. |
| sttotal | integer | not null | Start date time |
| vernr | integer | not null | Used in case multible instances of the same executale was launched at the same time. Typically just contains seconds since 1970.1.1 |
| exename | nvarchar(32) | not null | Name of executable |
| exepath | nvarchar(127) | with null | The complete path to the audited file (if available) is supplied in the EXEPATH field. Only 127 characters is however available in this field! |
| acid | integer | with null | Action ID |
| stdate | integer | with null | STDATE. Date when the application was launched,
Dates and times are stored in seconds after 1st Jan 1970. All dates are generated on the Agent who reported the data. |
| sttime | integer | with null | STTIME is the time the application was launched,
Dates and times are stored in seconds after 1st Jan 1970. All dates are generated on the Agent who reported the data. |
| enddate | integer | with null | ENDDATE. Date of application shutdown.
Dates and times are stored in seconds after 1st Jan 1970. All dates are generated on the Agent who reported the data. |
| endtime | integer | with null | ENDTIME is the time of application shutdown.
Dates and times are stored in seconds after 1st Jan 1970. All dates are generated on the Agent who reported the data. |
| endtotal | integer | with null | End date time, in total |
Product Name: Unicenter Desktop and Server Management
Table Type: Table