v_reportstats

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ClientID INT 10 0
MAX(v_Patches.LocationID) INT 10 null
LocationCount BIGINT 19 0
Installed DECIMAL 65 0
Fully Patched DECIMAL 54 0
Missing 1-2 Patches DECIMAL 54 0
Missing 3-5 Patches DECIMAL 54 0
Missing 6+ Patches DECIMAL 54 0
PTotal DECIMAL 64 0
TotalComputers DECIMAL 42 null
WindowsWorkstations DECIMAL 45 null
WindowsServers DECIMAL 45 null
Workstations DECIMAL 45 null
Servers DECIMAL 45 null
Mobile DECIMAL 42 null
Smartphones DECIMAL 42 null
Tablets DECIMAL 42 null
VirusCount DECIMAL 76 null
SpywareCount DECIMAL 76 null
DefragCount DECIMAL 76 null
CleanupCount DECIMAL 76 null
BackupSuccessCount DECIMAL 76 null
BackupFailCount DECIMAL 76 null
Alerts DECIMAL 64 null
OfflineServers DECIMAL 45 null
Availablity DECIMAL 15,4 null
Connectivity DECIMAL 24,4 null
CPU DECIMAL 15,4 null
MEM DECIMAL 18,4 null
FRAG DECIMAL 15,4 null
Issues DECIMAL 65 null
WindowsXPPrev DECIMAL 46 null
WindowsVista DECIMAL 45 null
Windows7 DECIMAL 45 null
Windows8 DECIMAL 45 null
MacWks DECIMAL 45 null
ServerSBS DECIMAL 45 null
ServerWin DECIMAL 45 null
ServerLinux DECIMAL 45 null
ServerMac DECIMAL 45 null
MDAndroid DECIMAL 42 null
MDApple DECIMAL 42 null
MDWin DECIMAL 42 null
OS DECIMAL 35,4 0.0000
Update Health DECIMAL 40,4 0.0000
Drive Health BIGINT 19 0
OpenTickets DECIMAL 42 0
Devices DECIMAL 42 0
Assets DECIMAL 42 0
FinishedTickets DECIMAL 42 0

View Definition


Possibly Referenced Tables/Views