Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DateChanged | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
|||
| WhatChanged | VARCHAR | 20 | null |
|
|
|||
| olddata | VARCHAR | 500 | null |
|
|
|||
| user | VARCHAR | 50 | null |
|
|
|||
| ComputerID | INT | 10 | 0 |
|
|
|||
| ClientID | INT | 10 | 0 |
|
|
|||
| LocationID | INT | 10 | 0 |
|
|
|||
| Name | VARCHAR | 50 | null |
|
|
|||
| Domain | VARCHAR | 100 | null |
|
|
|||
| Username | VARCHAR | 1000 | null |
|
|
|||
| PCDate | VARCHAR | 30 | null |
|
|
|||
| TimeZone | DECIMAL | 11,1 | 0.0 |
|
|
|||
| OS | VARCHAR | 100 | null |
|
|
|||
| WinDir | VARCHAR | 50 | null |
|
|
|||
| Version | VARCHAR | 60 | null |
|
|
|||
| BiosName | VARCHAR | 100 | null |
|
|
|||
| BiosVer | VARCHAR | 100 | null |
|
|
|||
| BiosMFG | VARCHAR | 100 | null |
|
|
|||
| BiosFlash | VARCHAR | 100 | null |
|
|
|||
| USB | VARCHAR | 255 | null |
|
|
|||
| Tape | VARCHAR | 255 | null |
|
|
|||
| Sound | VARCHAR | 255 | null |
|
|
|||
| SCSI | VARCHAR | 255 | null |
|
|
|||
| Serial | VARCHAR | 255 | null |
|
|
|||
| Parallel | VARCHAR | 255 | null |
|
|
|||
| IRQ | VARCHAR | 255 | null |
|
|
|||
| DMA | VARCHAR | 255 | null |
|
|
|||
| Address | VARCHAR | 400 | null |
|
|
|||
| Ports | TEXT | 65535 | null |
|
|
|||
| Comment | VARCHAR | 500 | null |
|
|
|||
| ServiceVersion | VARCHAR | 8 | null |
|
|
|||
| LastContact | DATETIME | 19 | null |
|
|
|||
| Password | VARCHAR | 32 | √ | null |
|
|
||
| Memory | VARCHAR | 255 | null |
|
|
|||
| Video | VARCHAR | 255 | null |
|
|
|||
| Processors | VARCHAR | 255 | null |
|
|
|||
| Nic | VARCHAR | 255 | null |
|
|
|||
| DNSInfo | VARCHAR | 500 | null |
|
|
|||
| LastInventory | DATETIME | 19 | null |
|
|
|||
| CPUUsage | INT | 10 | null |
|
|
|||
| TotalMemory | INT | 10 | null |
|
|
|||
| MemoryAvail | INT | 10 | null |
|
|
|||
| LocalAddress | VARCHAR | 30 | null |
|
|
|||
| RouterAddress | VARCHAR | 30 | null |
|
|
|||
| flags | INT | 10 | null |
|
|
|||
| Modems | VARCHAR | 500 | null |
|
|
|||
| DistributedApps | VARCHAR | 400 | , |
|
|