Counter per group of policy-compliant and non-compliant devices
Data model
Fields
| Field | Type | Description |
|---|---|---|
| compliant_devices* | INT | Compliant Device Counter |
| date_id* | INT | Date Identifier |
| group_id* | INT | Identifier of the group to which the record belongs |
| id* | INT | Registry ID |
| non_compliant_devices* | INT | Non-compliant device counter |
Primary Key
| PK_AES_GROUP_COMPLIANCE |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| date_id* | dbo.ADW_DIM_DATE | id | FK02_AES_GROUP_COMPLIANCE |
| group_id* | dbo.AES_GROUP | id | FK01_AES_GROUP_COMPLIANCE |