Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | 0 |
|
|
|||
| LocationID | INT | 10 | 0 |
|
|
|||
| Total | BIGINT | 19 | 0 |
|
|
|||
| Workstations | DECIMAL | 23 | 0 |
|
|
|||
| Servers | DECIMAL | 23 | 0 |
|
|
|||
| WindowsWorkstations | DECIMAL | 23 | 0 |
|
|
|||
| WindowsServers | DECIMAL | 23 | 0 |
|
|
|||
| WindowsXP | DECIMAL | 23 | 0 |
|
|
|||
| Windows2K | DECIMAL | 23 | 0 |
|
|
|||
| WindowsVista | DECIMAL | 23 | 0 |
|
|
|||
| Windows7 | DECIMAL | 23 | 0 |
|
|
|||
| Windows8 | DECIMAL | 23 | 0 |
|
|
|||
| MacWks | DECIMAL | 23 | 0 |
|
|
|||
| ServerSBS | DECIMAL | 23 | 0 |
|
|
|||
| ServerWin | DECIMAL | 23 | 0 |
|
|
|||
| Server2003 | DECIMAL | 23 | 0 |
|
|
|||
| ServerLinux | DECIMAL | 23 | 0 |
|
|
|||
| ServerMac | DECIMAL | 23 | 0 |
|
|
|||
| Mobiles | BIGINT | 19 | 0 |
|
|
|||
| Smartphones | BIGINT | 19 | 0 |
|
|
|||
| Tablets | BIGINT | 19 | 0 |
|
|
|||
| MDAndroid | BIGINT | 19 | 0 |
|
|
|||
| MDApple | BIGINT | 19 | 0 |
|
|
|||
| MDWin | BIGINT | 19 | 0 |
|
|
|||
| VirusCount | DECIMAL | 54 | 0 |
|
|
|||
| SpywareCount | DECIMAL | 54 | 0 |
|
|
|||
| DefragCount | DECIMAL | 54 | 0 |
|
|
|||
| CleanupCount | DECIMAL | 54 | 0 |
|
|
|||
| BackupSuccessCount | DECIMAL | 54 | 0 |
|
|
|||
| BackupFailCount | DECIMAL | 54 | 0 |
|
|
|||
| Alerts | DECIMAL | 42 | 0 |
|
|
|||
| OfflineServers | DECIMAL | 23 | √ | null |
|
|
||
| Availablity | DECIMAL | 11 | √ | null |
|
|
||
| Connectivity | BIGINT | 19 | 0 |
|
|
|||
| CPU | DECIMAL | 11 | 0 |
|
|
|||
| Issues | DECIMAL | 42 | 0 |
|
|
|||
| FRAG | DECIMAL | 11 | 0 |
|
|
|||
| FREE | DECIMAL | 15 | 0 |
|
|
|||
| MEM | DECIMAL | 14 | 0 |
|
|