Table containing the request for commands sent to the device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cmdreq_commandtypeid* | INT | Command type identifier |
| cmdreq_deviceid | INT | Device Identifier |
| cmdreq_expenseid | INT | Unique identifier of the consumption plan associated with the command prompt |
| cmdreq_groupid | INT | Identifier of the group to which the command was sent |
| cmdreq_id* | INT | Unique identifier of the command request |
| cmdreq_policyid | INT | Unique identifier of the policy associated with the command request |
| cmdreq_requestdate* | DATETIME | Date the command request is sent |
| cmdreq_ruleid | INT | Unique identifier of the rule associated with the command request |
| cmdreq_targettypeid* | INT | Identifier of the type of command to be sent |
Primary Key
| PK_AMDMCOMMANDREQUEST |
|---|
| cmdreq_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cmdreq_commandtypeid* | dbo.AMDM_COMMANDTYPE | cmdtype_id | FK02_AMDMCOMMANDREQUEST |
| cmdreq_deviceid | dbo.AMDM_DEVICE | id | FK03_AMDMCOMMANDREQUEST |
| cmdreq_expenseid | dbo.AMDM_EXPENSEPLAN | plan_id | FK07_AMDMCOMMANDREQUEST |
| cmdreq_groupid | dbo.AMDM_GROUP | group_id | FK04_AMDMCOMMANDREQUEST |
| cmdreq_manprojectid | dbo.AMDM_MANAGEMENTPROJECT | manproject_id | FK09_AMDMCOMMANDREQUEST |
| cmdreq_policyid | dbo.AMDM_POLICY | policy_id | FK05_AMDMCOMMANDREQUEST |
| cmdreq_ruleid | dbo.AMDM_RULESET | ruleset_id | FK06_AMDMCOMMANDREQUEST |
| cmdreq_targettypeid* | dbo.AMDM_COMMANDTARGETTYPE | cmdtgtype_id | FK01_AMDMCOMMANDREQUEST |
| cmdreq_userid | dbo.AFW_USERS | user_id | FK08_AMDMCOMMANDREQUEST |