Table: Administrator

This table contains two kinds of entries: 

1. Scout Enterprise administrator profiles (identified by setting Type=-1 and ID=-1)
2. 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 Enterprise and copy the Rights 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)       - not used -
Rights NVARCHAR(255)     0000000000000000000000000000000000000000000000000000
Definition of policy/rights
Type INTEGER      
-1 Administrator profile
1 TYPE_GROUP  Permissions on a Scout Enterprise OU
(ID refers to Groups)
 4 TYPE_DEVICE_ENTRY  Permissions on a Scout Enterprise device
(ID refers to Device)
ID INTEGER      
-1 Administrator profile  
>=0 Scout Enterprise 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 Enterprise 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));