v_computerhistory

0 rows


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 ,

View Definition


Possibly Referenced Tables/Views