| Table Name: | MPTenantMonitorMachines |
| View Name: | MARITenantMonitorMachines |
| 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 | View(engl.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 |
MPTenantEnvironments.EnvironmentID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MPTenantMonitorAppInstallations | Bucket to store installation data at client location: installed apps |
| MPTenantMonitorAppUsers | Bucket to store installation data at client location: assigned users |
| MPTenantMonitorDatabases | Bucket to store installation data at client location: used databases |
| MPTenantMonitorEnvironments | Bucket to store installation data at client location: Information from SLD |