Scout Database Model (CR)
Table: Administrator
This table contains two kinds of entries:
- Scout administrator profiles (identified by setting Type=-1 and ID=-1)
- Administrator policies/object rights on either a device or an OU/group (identified by Type=1|4 and ID>=0)
The Rights attribute is a 210 bit long string, each bit represents a single permission. In order to create Administrator entries manually, it is good practice to add a new entry via Scout and copy theRights value to your new entry.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| AdministratorID | INTEGER | PK | NN | Unique ID of administrator entry | |
| Name | NVARCHAR(255) | Name of real user or group (f.e. <server><user>) |
|||
| Sid | NVARCHAR(255) |
|
|||
| Rights
|
NVARCHAR(255)
|
|
|
0000000000000000000000000000000000000000000000000000
|
|
| Definition of policy/rights | |||||
| Type
|
INTEGER
|
|
|
|
|
| -1 Administrator profile | |||||
| 1 TYPE_GROUP, Permissions on a Scout OU (/en-us/unicon-elux-scout/white_papers/dbmodel/entity/table_groups.html) | |||||
| 4 TYPE_DEVICE_ENTRY, Permissions on a Scout device (ID refers to Device) | |||||
| ID
|
INTEGER
|
|
|
|
-1 Administrator profile |
>=0 Scout object ID |
|||||
| For Type=1, the foreign key refers to table Device.DeviceID,for Type=4, the foreign key refers to table Groups. GroupID | |||||
| ProfileType
|
SMALLINT(6)
|
|
|
|
Pre-defined profiles (administrator profiles only) |
| 0 - Minimum profile (objects not visible, menus not allowed) | |||||
| 1 - Scout object ID | |||||
| 3 - Individual profile | |||||
| ReservedString1 | NVARCHAR(255) | ||||
| ReservedString2 | NVARCHAR(255) | ||||
| ReservedInt1 | INTEGER | 0 | Optional ID of root OU Refers to table Groups.GroupID | ||
| ReservedInt2 | INTEGER |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | AdministratorID |
How to create
CREATE TABLE Administrator(
AdministratorID INTEGER NOT NULL,
Name NVARCHAR(255),
Sid NVARCHAR(255),
Rights NVARCHAR(255),
Type INTEGER,
ID INTEGER,
ProfileType SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (AdministratorID));
Table: Administrator
In this article
Copied!
Failed!