h_locationstats

542 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
LocationID INT 10 null
TotalComputers INT 10 null
ActiveComputers INT 10 null
LocationOnline INT 10 null
TotalDevices INT 10 null
ActiveDevices INT 10 null
RetiredAssets INT 10 null
MasterComputers INT 10 null
ProbeEnabled INT 10 null
Servers INT 10 null
WorkStations INT 10 null
Mobile INT 10 null
Smartphone INT 10 null
Tablet INT 10 null
StatDate TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
LocationID Must be unique Asc/Asc LocationID + StatDate

Diagram producer might be missing

No diagrams were produced please see application output for any errors