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 65 √ null
SpywareCount DECIMAL 65 √ null
DefragCount DECIMAL 65 √ null
CleanupCount DECIMAL 65 √ null
BackupSuccessCount DECIMAL 65 √ null
BackupFailCount DECIMAL 65 √ null
Alerts DECIMAL 64 √ null
OfflineServers DECIMAL 45 √ null
Availablity DECIMAL 15,4 √ null
Connectivity DECIMAL 23,4 √ null
CPU DECIMAL 15,4 √ null
MEM DECIMAL 18,4 √ null
FRAG DECIMAL 15,4 √ null
Issues DECIMAL 64 √ 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 INT 10 0
OpenTickets DECIMAL 42 0
Devices DECIMAL 42 0
Assets DECIMAL 42 0
FinishedTickets DECIMAL 42 0

View Definition

Possibly Referenced Tables/Views