Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ComputerID | INT | 10 | 0 |
|
|
|||
| ClientID | INT | 10 | 0 |
|
|
|||
| Client_Name | VARCHAR | 50 |
|
|
||||
| Client_Company | VARCHAR | 100 | null |
|
|
|||
| Location_Name | VARCHAR | 50 | null |
|
|
|||
| LocationID | INT | 10 | 0 |
|
|
|||
| Computer_Name | VARCHAR | 50 | null |
|
|
|||
| Domain | VARCHAR | 100 | null |
|
|
|||
| UserName | VARCHAR | 1000 | null |
|
|
|||
| OS | VARCHAR | 100 | null |
|
|
|||
| OS_Version | VARCHAR | 60 | null |
|
|
|||
| BiosName | VARCHAR | 100 | null |
|
|
|||
| BiosVer | VARCHAR | 100 | null |
|
|
|||
| BiosMFG | VARCHAR | 100 | null |
|
|
|||
| BiosFlash | VARCHAR | 100 | null |
|
|
|||
| TimeZone | DECIMAL | 11,1 | 0.0 |
|
|
|||
| CPUUsage | INT | 10 | null |
|
|
|||
| LocalAddress | VARCHAR | 30 | null |
|
|
|||
| InternetAddress | VARCHAR | 30 | null |
|
|
|||
| Flags | INT | 10 | null |
|
|
|||
| UpTime | BIGINT | 19 | null |
|
|
|||
| TempFiles | BIGINT | 19 | null |
|
|
|||
| SystemMemory | INT | 10 | null |
|
|
|||
| MAC | VARCHAR | 50 | null |
|
|
|||
| ServiceVersion | VARCHAR | 8 | null |
|
|
|||
| LastContact | DATETIME | 19 | null |
|
|
|||
| CPU | VARCHAR | 255 | √ | null |
|
|
||
| ClockSpeed | INT | 10 | √ | null |
|
|
||
| Family | INT | 10 | √ | null |
|
|
||
| CPUMFT | VARCHAR | 255 | √ | null |
|
|
||
| CPU_Serial | VARCHAR | 255 | √ | null |
|
|
||
| ProccessorCount | BIGINT | 19 | 0 |
|
|
|||
| VideoCard | VARCHAR | 255 | √ |
|
|
|||
| RouterAddress | VARCHAR | 30 | null |
|
|