| View Name: | MARITenantMonitorMachines |
| Based on table: | MPTenantMonitorMachines |
| Group: | Group: TenantMonitorMachines |
| Description: | Bucket to store installation data at client location: database servers, RDP Servers, Clients |
| ClassID: | 645. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MachineID | MachineID INT Primary |
||
| ComputerName | ComputerName NVARCHAR (100) Index |
||
| MachineType | MachineType INT Index |
||
| OSInfo | OSInfo NVARCHAR (255) |
||
| DBType | DBType INT |
||
| DBName | DBName NVARCHAR (100) |
||
| DBInfo | DBInfo NVARCHAR (255) |
||
| APPInfo | APPInfo NVARCHAR (255) |
||
| EnvironmentID | EnvironmentID INT Index |
MARITenantEnvironments.EnvironmentID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MARITenantMonitorAppInstallations | Bucket to store installation data at client location: installed apps |
| MARITenantMonitorAppUsers | Bucket to store installation data at client location: assigned users |
| MARITenantMonitorDatabases | Bucket to store installation data at client location: used databases |
| MARITenantMonitorEnvironments | Bucket to store installation data at client location: Information from SLD |