v_reportstatsloc

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ClientID INT 10 0
LocationID INT 10 0
Installed DECIMAL 45 0
Fully Patched DECIMAL 54 0
Missing 1-2 Patches DECIMAL 32 0
Missing 3-5 Patches DECIMAL 32 0
Missing 6+ Patches DECIMAL 32 0
PTotal DECIMAL 42 0
TotalComputers BIGINT 19 0
WindowsWorkstations DECIMAL 23 0
WindowsServers DECIMAL 23 0
Workstation DECIMAL 23 0
Servers DECIMAL 23 0
Mobiles BIGINT 19 0
Smartphones BIGINT 19 0
Tablets 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 0
Availablity DECIMAL 11 0
Connectivity BIGINT 19 0
CPU DECIMAL 11 0
MEM DECIMAL 14 0
FRAG DECIMAL 11 0
Issues DECIMAL 43 0
WindowsXPPrev DECIMAL 24 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
ServerLinux DECIMAL 23 0
ServerMac DECIMAL 23 0
MDAndroid BIGINT 19 0
MDApple BIGINT 19 0
MDWin BIGINT 19 0
OS DECIMAL 31 0
Update Health DECIMAL 36 0
Drive Health BIGINT 19 0
OpenTickets BIGINT 19 0
Devices BIGINT 19 0
Assets BIGINT 19 0
FinishedTickets BIGINT 19 0

View Definition