Software Metering data displayed in the Admin Console is based on this table. Data in this table is created by the Software Metering Agents and collected by the Asset Management Engine. Only offline metering data is stored in the database. Each entry describes events from metered applications. When the Metering Agent on the PC detects that a metered application has started or stopped, it will be logged in this table. Both the starting time, ending time (termination) and total time of execution for the metered application is stored. The UDOMID and UNITID defines the Unit who reported the metering data. The sw_def_uuid defines the application (from the ca_software_def table) which the report entry describes. Dates and times are stored in seconds after 1st Jan 1970. Times-only fields (such as STTIME and ENDTIME) are stored in seconds after hour 00:00. Possible action codes (the ACID field): Prevent = 0 Normal Start = 1 Start Warning = 2 Normal start and undetermined end = 3 Warning start = 4 Queue time = 5 Note that the amount of data in this table can grow very quickly and usually the Admin Console will periodically ask to delete entries more than 2 weeks old. This table is created dynamically by product and will not exist unless the product is installed.
| 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) |
| sw_def_uuid | byte(16) | not null | Software Definition Uuid. Points to ca_software_def.sw_def_uuid |
| sttotal | integer | not null | Starttime when this application was launched. Seconds since 1970.1.1 |
| sw_domain_uuid | byte(16) | not null | Domain uuid for Software definition. Used for replication purposes |
| acid | integer | with null | Action ID. MHISAC_PREVENTED = 0, //'1 MHISAC_NORMAL_NORMAL = 1, //'2,3 MHISAC_WARNING_NORMAL = 2, //'5,3 MHISAC_NORMAL_ABNORMAL = 3, //'2,6 MHISAC_WARNING_ABNORMAL = 4, //'5,6 MHISAC_QUEUED_GRANTED = 5, //'8,9 'How long was the user in queue for this application MHISAC_NORMAL_INACTIVITY = 6, //'2,10 'Started normal, Inactivity stop MHISAC_WARNING_INACTIVITY = 7 //'5,10 'Started with warning, Inactivity stop } |
| stdate | integer | with null | Start Date when application was launched |
| sttime | integer | with null | Start Time when application was launched |
| enddate | integer | with null | End date when application was stopped |
| endtime | integer | with null | End Time when application was stopped |
| endtotal | integer | with null | Total end time, seconds since 1970.1.1 application was stopped |
| apflag | integer | with null | Flag |
| domain_uuid | byte(16) | with null | Domain uuid. Points typically to ca_discovered_hardware.domain_uuid |
| object_type | integer | with null | Object Type. 1=ca_discovered_hardware,2=ca_discovered_user |
Product Name: Unicenter Desktop and Server Management
Table Type: Table