This table is typically used by Unicenter Asset Management. It keeps status records for modules run by each Agent. When a Module has run on the Agent it will return a status code (OK, ERROR, WAITING) and a possible status message string. Modules are hardware inventory scanners, software scanner, metering agent, and remote control agent. The definition of the modules can be found in the NCMODCFG table. Each entry in this table holds information about the status of execution of one module by an Agent. Object_UUID is a foreign key to either ca_discovered_hardware or ca_discovered_user. The MDOMID and MOID are keys in NCMODCFG and defines the module the status belongs to. The STATUS field will contain a code according to the returned Module error level: OK = 1 Error = 0 Waiting = -1 All Assets who have no entry in this table are assumed to have a "Waiting" status. The STCOUNT field is incremented each time status is collected for that module. The STQCOUNT field is incremented each time the execution of a module is cancelled by a user (only possible if the scheduling properties allow the user to cancel the execution). STDATE is the date/time the module was executed. STELAPSE describes how many seconds it took to execute the module. The STTEXT field contains the status text string returned by the Agent. This string can only be 127 characters long. If the returned status field exceeds this limit, the STFLAG will indicate that the STATMODM table contains the complete status text. STREV is an internal version number, which is incremented whenever the module properties are updated.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| moid | integer | not null | Module ID. Foreign Key to NCMODCFG |
| mdomid | integer | not null | Module domain ID. Foreign Key to NCMODCFG |
| 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) |
| status | integer | with null | Status (1=OK,O=Waiting/Reinitialized, -1 Error) |
| stcount | integer | with null | Number of times is has been running |
| stqcount | integer | with null | Number of times it has been canceled |
| stdate | integer | with null | Date of last status update |
| stelapse | integer | with null | Elapsed time for Execution (Seconds) |
| sttext | nvarchar(127) | with null | 127 characters Status Text |
| strev | integer | with null | Revision Number |
| stflag | integer | with null | More Status Text (0=None,1=More - look in STATMODM |
| auto_rep_version | date | with null | Replication version |
| object_type | integer | with null | Object Type. 1=Computer, 2=User |
| object_domain_uuid | byte(16) | with null | Object domain uuid. Typically points to ca_discovered_hardware.domain_uuid |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| moid mdomid object_uuid |
statmodm | moid mdomid object_uuid |