Observium stop draw graphs

Probably already fixed some time ago.

Hi Milan Krenek, we have not received the additional information requested earlier from you in this issue 'Command ./poller.php -h 237 -m sensors -dd

show error during processing:

for database "sensors"
SQL WARNINGS[
1364: Field 'sensor_class' doesn't have a default value
1364: Field 'sensor_oid' doesn't have a default value
]

The drawing graps stop after update database and PHP 7.2 and I test now 7.4:

o OS Linux 3.10.0-1127.19.1.el7.x86_64 [amd64] (CentOS 7)
o Apache 2.4.6
o PHP 7.4.11 (OPcache: ENABLED)
o Python 2.7.5
o MariaDB 10.4.15-MariaDB (extension: mysqli 7.4.11)
o SNMP NET-SNMP 5.7.2
o RRDtool 1.7.1
o Fping 3.10 (IPv4 only)

The files rrd are in folder and script say it is not necesary to create
Example one file:
rw-rr-. 1 apache apache 117272 Oct 22 14:40 processor-cpm-7.rrd

ps -fe show over 2004 running processes like:
root 8770 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 283
root 8774 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 277
root 8775 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 272
root 8776 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 263
root 8777 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 262
root 8779 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 164
root 8781 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 295
root 8783 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 302
root 8785 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 317
root 8788 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 350
root 8789 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 349
root 8793 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 344
root 8795 8550 0 14:35 ? 00:00:00 php /opt/observium/poller.php -q -h 347
root 8798 9031 0 13:40 ? 00:00:00 php /opt/observium/poller.php -q -h 448
root 8801 8798 0 13:40 ? 00:00:00 /usr/bin/rrdtool -
root 8803 8774 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8811 8770 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8827 8767 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8828 8779 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8831 8776 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8832 8764 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8837 8785 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8841 8775 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8842 8777 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8849 8781 0 14:35 ? 00:00:00 /usr/bin/rrdtool -
root 8853 8793 0 14:35 ? 00:00:00 /usr/bin/rrdtool -'!

Issues without your response will be closed within 2 weeks.

how? Oo That's a lot of windows services!

We have 18578 records.

how many entries are in your winservices table?

Unfortunately it make sense. In the report upper you see the processing of SQL took around 40sec.
In our environment we monitor switches, routers and also virtual servers and when I run pooler manualy it did not finsh to 5min.

The poolers grow in processes and database have problem with locking records and update time on database grows also.

I gave to virtual machine more CPU, more RAM and I try also increase threads for pooler with the same results. Increased threads consume more time over pooler than count threads by default.

After add index on table "winservices" the pooler process finish less than 5min.

Is this fixed now? The issue doesn't seem to make sense, there's no reason why a column in the winservices table would make any graphs not draw.

Even less reason why an index would make any difference, since it has no effect on the actual data returned.

I solved problem after add collum "name" to index in table "winservices"

INFO: observium-wrapper poller processed 304 devices in 589.62 seconds with 16 threads, load average (5min) 2.31

WARNING: the process took more than 5 minutes to finish, you need faster hardware or more threads
INFO: in sequential style processing the elapsed time would have been: 8947 seconds
WARNING: Consider setting a minimum of 32 threads. (This does not constitute professional advice!)

DEBUG!

CMD[/usr/bin/svn info /opt/observium]

CMD EXITCODE[0]
CMD RUNTIME[0.0613s]
STDOUT[
Path: .
Working Copy Root Path: /opt/observium
URL: http://svn.observium.org/svn/observium/trunk
Repository Root: http://svn.observium.org/svn
Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8
Revision: 10774
Node Kind: directory
Schedule: normal
Last Changed Author: adama
Last Changed Rev: 10774
Last Changed Date: 2020-10-21 01:40:55 +0200 (Wed, 21 Oct 2020)

]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00052786s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00012517s]

SQL[SET SESSION `sql_mode` = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION']
SQL RUNTIME[0.00127697s]
DB mode(s) disabled: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.018s]
STDOUT[
+02:00
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00077510s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00107193s]

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00049901s]

SQL[SELECT * FROM `alerts_maint` WHERE `maint_start` < '1603377560' AND `maint_end` > '1603377560']
SQL RUNTIME[0.00200891s]

SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `device_id` = '26' AND `poller_id` = '0' ORDER BY `device_id` ASC]
SQL RUNTIME[0.00086904s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '26']
SQL RUNTIME[0.00218987s]

SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'device' AND `entity_id` = '26']
SQL RUNTIME[0.00081205s]

SQL[SELECT * FROM `observium_processes` WHERE `process_name` = 'poller.php' AND `device_id` = '26']
SQL RUNTIME[0.00088096s]

SQL[INSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('13497','poller.php','15883','0','php /opt/observium/poller.php -q -h 26 -d','1603377560','26')]
SQL RUNTIME[0.00813293s]

SQL[SELECT * FROM `alert_tests` WHERE 1]
SQL RUNTIME[0.00066209s]
Cached 14 alert rules.

SQL[SELECT * FROM `alert_table` WHERE `device_id` = '26']
SQL RUNTIME[0.00148010s]

CMD[/usr/sbin/fping -t 1000 -c 1 -q xx.xx.xx.30 2>&1]

CMD EXITCODE[0]
CMD RUNTIME[0.0094s]
STDOUT[
xx.xx.xx.30 : xmt/rcv/%loss = 1/1/0%, min/avg/max = 4.19/4.19/4.19
]

CMD[/usr/bin/snmpget -v2c -c *** -Pud -OQUs -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'server-av':'161' sysObjectID.0 sysUpTime.0]

CMD EXITCODE[0]
CMD RUNTIME[0.0179s]
STDOUT[
sysObjectID.0 = enterprises.311.1.1.3.1.2
sysUpTime.0 = 23:2:20:30.90
]
SNMP STATUS[TRUE]
RRD /opt/observium/rrd/server-av/status.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/server-av/status.rrd N:1]
RRD RUNTIME[0.0012s]
RRD STDOUT[OK u:0.00 s:0.01 r:0.04]
RRD_STATUS[TRUE]

RRD /opt/observium/rrd/server-av/ping.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/server-av/ping.rrd N:4.19]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:0.04]
RRD_STATUS[TRUE]

RRD /opt/observium/rrd/server-av/ping_snmp.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/server-av/ping_snmp.rrd N:17.94]
RRD RUNTIME[0.0011s]
RRD STDOUT[OK u:0.00 s:0.01 r:0.04]
RRD_STATUS[TRUE]

SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '26']
SQL RUNTIME[0.00075579s]
Module [unix-agent] excluded in process [poller].
Module [junose-atm-vp] excluded in process [poller].
Module [cisco-ipsec-flow-monitor] excluded in process [poller].
Module [cisco-remote-access-monitor] excluded in process [poller].
Module [cisco-cef] excluded in process [poller].
Module [lsp] disabled globally by config in process [poller].
Module [arista-software-ip-forwarding] excluded in process [poller].
Module [cipsec-tunnels] excluded in process [poller].
Module [cisco-cbqos] excluded in process [poller].
Module [cisco-eigrp] excluded in process [poller].
Module [aruba-controller] excluded in process [poller].
Module [cisco-vpdn] excluded in process [poller].

including: includes/polling/wmi.inc.php
WMI Poller:

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT Name FROM Win32_ComputerSystem"

CMD EXITCODE[0]
CMD RUNTIME[0.1135s]
STDOUT[
CLASS: Win32_ComputerSystem
Name
server-av
]

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT * FROM Win32_OperatingSystem"

CMD EXITCODE[0]
CMD RUNTIME[0.1059s]
STDOUT[
CLASS: Win32_OperatingSystem
BootDevice##BuildNumber##BuildType##Caption##CodeSet##CountryCode##CreationClassName##CSCreationClassName##CSDVersion##CSName##CurrentTimeZone##DataExecutionPrevention_32BitApplications##DataExecutionPrevention_Available##DataExecutionPrevention_Drivers##DataExecutionPrevention_SupportPolicy##Debug##Description##Distributed##EncryptionLevel##ForegroundApplicationBoost##FreePhysicalMemory##FreeSpaceInPagingFiles##FreeVirtualMemory##InstallDate##LargeSystemCache##LastBootUpTime##LocalDateTime##Locale##Manufacturer##MaxNumberOfProcesses##MaxProcessMemorySize##MUILanguages##Name##NumberOfLicensedUsers##NumberOfProcesses##NumberOfUsers##OperatingSystemSKU##Organization##OSArchitecture##OSLanguage##OSProductSuite##OSType##OtherTypeDescription##PAEEnabled##PlusProductID##PlusVersionNumber##PortableOperatingSystem##Primary##ProductType##RegisteredUser##SerialNumber##ServicePackMajorVersion##ServicePackMinorVersion##SizeStoredInPagingFiles##Status##SuiteMask##SystemDevice##SystemDirectory##SystemDrive##TotalSwapSpaceSize##TotalVirtualMemorySize##TotalVisibleMemorySize##Version##WindowsDirectory
\Device\HarddiskVolume1##9600##Multiprocessor Free##Microsoft Windows Server 2012 R2 Datacenter##1252##1##Win32_OperatingSystem##Win32_ComputerSystem##(null)##server-av##120##True##True##True##3##False####False##256##2##6623188##1885504##8004328##20160519201118.000000+120##0##20200929141837.490244+120##20201022163921.584000+120##0409##Microsoft Corporation##4294967295##137438953344##(en-US)##Microsoft Windows Server 2012 R2 Datacenter|C:\Windows|\Device\Harddisk0\Partition2##0##61##14##8####64-bit##1033##400##18##(null)##False##(null)##(null)##False##True##3##Windows User##00253-50000-00000-AA442##0##0##2228224##OK##400##\Device\HarddiskVolume2##C:\Windows\system32##C:##0##16907828##14679604##6.3.9600##C:\Windows
]

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT NumberOfLogicalProcessors,Name FROM Win32_Processor"

CMD EXITCODE[0]
CMD RUNTIME[0.0926s]
STDOUT[
CLASS: Win32_Processor
DeviceID##Name##NumberOfLogicalProcessors
CPU0##Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz##4
]

SQL[SELECT `processor_descr` FROM `processors` WHERE `device_id` = '26']
SQL RUNTIME[0.00060987s]
Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT * FROM Win32_LogicalDisk WHERE FileSystem != 'CDFS'"

CMD EXITCODE[0]
CMD RUNTIME[0.1266s]
STDOUT[
CLASS: Win32_LogicalDisk
Access##Availability##BlockSize##Caption##Compressed##ConfigManagerErrorCode##ConfigManagerUserConfig##CreationClassName##Description##DeviceID##DriveType##ErrorCleared##ErrorDescription##ErrorMethodology##FileSystem##FreeSpace##InstallDate##LastErrorCode##MaximumComponentLength##MediaType##Name##NumberOfBlocks##PNPDeviceID##PowerManagementCapabilities##PowerManagementSupported##ProviderName##Purpose##QuotasDisabled##QuotasIncomplete##QuotasRebuilding##Size##Status##StatusInfo##SupportsDiskQuotas##SupportsFileBasedCompression##SystemCreationClassName##SystemName##VolumeDirty##VolumeName##VolumeSerialNumber
0##0##0##A:##False##0##False##Win32_LogicalDisk##3 1/2 Inch Floppy Drive##A:##2##False##(null)##(null)##(null)##0##(null)##0##0##5##A:##0##(null)##NULL##False##(null)##(null)##False##False##False##0##(null)##0##False##False##Win32_ComputerSystem##server-av##False##(null)##(null)
0##0##0##C:##False##0##False##Win32_LogicalDisk##Local Fixed Disk##C:##3##False##(null)##(null)##NTFS##83609260032##(null)##0##255##12##C:##0##(null)##NULL##False##(null)##(null)##True##False##False##160691122176##(null)##0##True##True##Win32_ComputerSystem##server-av##False####9C2EFDB6
0##0##0##F:##False##0##False##Win32_LogicalDisk##CD-ROM Disc##F:##5##False##(null)##(null)##(null)##0##(null)##0##0##11##F:##0##(null)##NULL##False##(null)##(null)##False##False##False##0##(null)##0##False##False##Win32_ComputerSystem##server-av##False##(null)##(null)
]

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT Name, ProcessId FROM Win32_Service WHERE Name LIKE 'SSQL$%' OR Name = 'MSSQLSERVER'"

CMD EXITCODE[0]
CMD RUNTIME[0.1451s]
STDOUT[
CLASS: Win32_Service
Name##ProcessId
MSSQLSERVER##1428
]
MSSQL:
MSSQLSERVER - PID: 1428

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT * FROM Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics"

CMD EXITCODE[1]
CMD RUNTIME[0.1473s]
STDOUT[
[wmi/wmic.c:212:main()] ERROR: Retrieve result data.
]
STDERR[
NTSTATUS: NT code 0x80041010 - NT code 0x80041010
]
WMI Error: Cannot connect to host or Class

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT * FROM Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryManager"

CMD EXITCODE[1]
CMD RUNTIME[0.0893s]
STDOUT[
[wmi/wmic.c:212:main()] ERROR: Retrieve result data.
]
STDERR[
NTSTATUS: NT code 0x80041010 - NT code 0x80041010
]
WMI Error: Cannot connect to host or Class

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT * FROM Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager"

CMD EXITCODE[1]
CMD RUNTIME[0.0927s]
STDOUT[
[wmi/wmic.c:212:main()] ERROR: Retrieve result data.
]
STDERR[
NTSTATUS: NT code 0x80041010 - NT code 0x80041010
]
WMI Error: Cannot connect to host or Class

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT * FROM Win32_PerfRawData_PerfProc_Process WHERE IDProcess=1428"

CMD EXITCODE[0]
CMD RUNTIME[0.1565s]
STDOUT[
CLASS: Win32_PerfRawData_PerfProc_Process
(null)##CreatingProcessID##Description##ElapsedTime##Frequency_Object##Frequency_PerfTime##Frequency_Sys100NS##HandleCount##IDProcess##IODataBytesPersec##IODataOperationsPersec##IOOtherBytesPersec##IOOtherOperationsPersec##IOReadBytesPersec##IOReadOperationsPersec##IOWriteBytesPersec##IOWriteOperationsPersec##Name##PageFaultsPersec##PageFileBytes##PageFileBytesPeak##PercentPrivilegedTime##PercentProcessorTime##PercentUserTime##PoolNonpagedBytes##PoolPagedBytes##PriorityBase##PrivateBytes##ThreadCount##Timestamp_Object##Timestamp_PerfTime##Timestamp_Sys100NS##VirtualBytes##VirtualBytesPeak##WorkingSet##WorkingSetPeak##WorkingSetPrivate
(null)##664##(null)##132458555295117647##10000000##1953125##10000000##810##1428##689849044988##44537937##14403425227##113755251##188228197095##16082657##501620847893##28455280##sqlservr##18457621##5028040704##5058375680##72512187500##787660625000##715148437500##202048##504744##8##5028040704##62##132478511624592305##3897620908770##132478511624592305##22357172224##22396088320##4926685184##4951437312##4873105408
]
CPU; RRD /opt/observium/rrd/server-av/wmi-app-mssql_MSSQLSERVER-cpu.rrd already exists - no need to create.

RRD CMD[update /opt/observium/rrd/server-av/wmi-app-mssql_MSSQLSERVER-cpu.rrd N:787660625000:62:160337756118376384]
RRD RUNTIME[0.0012s]
RRD STDOUT[]
RRD_STATUS[TRUE]

SQL[SELECT * FROM `applications` WHERE `device_id` = '26' AND `app_type` = 'mssql' AND `app_instance` = 'MSSQLSERVER']
SQL RUNTIME[0.01461911s]
.
SQL[UPDATE `applications` set `app_json` ='\{\"cpu\":{\"proc\":\"787660625000\",\"time\":\"160337756118376384\"}}',`app_lastpolled` ='1603377561' WHERE `app_id` = '15']
SQL RUNTIME[0.01100302s]

SQL[SELECT * FROM `applications` AS A LEFT JOIN `applications-state` AS S ON `A`.`app_id`=`S`.`application_id` WHERE `A`.`device_id` = '26' AND `A`.`app_instance` = 'MSSQLSERVER' AND `A`.`app_type` = 'mssql']
SQL RUNTIME[0.00206590s]

SQL[UPDATE `applications-state` set `app_last_polled` ='1603377561',`app_status` ='1',`app_state` ='a:1:\{s:3:\"cpu\";a:2:{s:4:\"proc\";s:12:\"787660625000\";s:4:\"time\";s:18:\"160337756118376384\";}}' WHERE `application_id` = '15']
SQL RUNTIME[0.00407910s]

CMD/bin/wmic --user=*** --password=*** --workgroup='domain.local' --delimiter='##' --namespace='root\CIMV2' //'server-av' "SELECT DisplayName,Name,StartMode,State FROM Win32_Service"

CMD EXITCODE[0]
CMD RUNTIME[0.2745s]
STDOUT[
CLASS: Win32_Service
DisplayName##Name##StartMode##State
Application Experience##AeLookupSvc##Manual##Stopped
Application Layer Gateway Service##ALG##Manual##Stopped
Application Identity##AppIDSvc##Manual##Stopped
Application Information##Appinfo##Manual##Running
Application Management##AppMgmt##Manual##Running
App Readiness##AppReadiness##Manual##Stopped
AppX Deployment Service (AppXSVC)##AppXSvc##Manual##Stopped
Windows Audio Endpoint Builder##AudioEndpointBuilder##Manual##Stopped
Windows Audio##Audiosrv##Manual##Stopped
Base Filtering Engine##BFE##Auto##Running
Background Intelligent Transfer Service##BITS##Manual##Running
Background Tasks Infrastructure Service##BrokerInfrastructure##Auto##Running
Computer Browser##Browser##Disabled##Stopped
Certificate Propagation##CertPropSvc##Manual##Running
COM+ System Application##COMSysApp##Manual##Stopped
Cryptographic Services##CryptSvc##Auto##Running
DCOM Server Process Launcher##DcomLaunch##Auto##Running
Optimize drives##defragsvc##Manual##Stopped
Device Association Service##DeviceAssociationService##Manual##Stopped
Device Install Service##DeviceInstall##Manual##Stopped
DHCP Client##Dhcp##Auto##Running
Diagnostics Tracking Service##DiagTrack##Auto##Running
DNS Client##Dnscache##Auto##Running
Wired AutoConfig##dot3svc##Manual##Stopped
Diagnostic Policy Service##DPS##Auto##Running
Device Setup Manager##DsmSvc##Manual##Stopped
Extensible Authentication Protocol##Eaphost##Manual##Stopped
Encrypting File System (EFS)##EFS##Manual##Stopped
Windows Event Log##EventLog##Auto##Running
COM+ Event System##EventSystem##Auto##Running
Eventlog to Syslog##EvtSys##Auto##Running
Function Discovery Provider Host##fdPHost##Manual##Stopped
Function Discovery Resource Publication##FDResPub##Manual##Stopped
Windows Font Cache Service##FontCache##Auto##Running
Windows Presentation Foundation Font Cache 3.0.0.0##FontCache3.0.0.0##Manual##Stopped
Google Chrome Elevation Service##GoogleChromeElevationService##Manual##Stopped
Group Policy Client##gpsvc##Auto##Running
Služba Aktualizace Google (gupdate)##gupdate##Auto##Stopped
Služba Aktualizace Google (gupdatem)##gupdatem##Manual##Stopped
Human Interface Device Service##hidserv##Manual##Stopped
Health Key and Certificate Management##hkmsvc##Manual##Stopped
Internet Explorer ETW Collector Service##IEEtwCollectorService##Manual##Stopped
IKE and AuthIP IPsec Keying Modules##IKEEXT##Auto##Running
IP Helper##iphlpsvc##Auto##Running
CNG Key Isolation##KeyIso##Manual##Running
KDC Proxy Server service (KPS)##KPSSVC##Manual##Stopped
KtmRm for Distributed Transaction Coordinator##KtmRm##Manual##Stopped
Server##LanmanServer##Auto##Running
Workstation##LanmanWorkstation##Auto##Running
Link-Layer Topology Discovery Mapper##lltdsvc##Manual##Stopped
TCP/IP NetBIOS Helper##lmhosts##Auto##Running
Local Session Manager##LSM##Auto##Running
McAfee Agent Common Services##macmnsvc##Auto##Running
McAfee Agent Service##masvc##Auto##Running
McAfee ePolicy Orchestrator 5.10.0 Server##MCAFEEAPACHESRV##Auto##Running
McAfee ePolicy Orchestrator 5.10.0 Event Parser##MCAFEEEVENTPARSERSRV##Auto##Running
McAfee Agent Backwards Compatibility Service##McAfeeFramework##Manual##Running
McAfee ePolicy Orchestrator 5.10.0 Application Server##MCAFEETOMCATSRV5100##Auto##Running
McAfee Firewall Core Service##mfefire##Manual##Stopped
McAfee Service Controller##mfemms##Auto##Running
McAfee Validation Trust Protection Service##mfevtp##Manual##Running
McAfee Endpoint Security Web Control Service##mfewc##Auto##Running
Multimedia Class Scheduler##MMCSS##Manual##Stopped
McAfee Mobile Plugin Service##MobilePluginService##Manual##Stopped
Windows Firewall##MpsSvc##Auto##Running
Distributed Transaction Coordinator##MSDTC##Auto##Running
Microsoft iSCSI Initiator Service##MSiSCSI##Manual##Stopped
Windows Installer##msiserver##Manual##Stopped
SQL Server (MSSQLSERVER)##MSSQLSERVER##Auto##Running
Network Access Protection Agent##napagent##Manual##Stopped
Network Connectivity Assistant##NcaSvc##Manual##Stopped
Netlogon##Netlogon##Auto##Running
Network Connections##Netman##Manual##Stopped
Network List Service##netprofm##Manual##Running
Net.Tcp Port Sharing Service##NetTcpPortSharing##Disabled##Stopped
Network Location Awareness##NlaSvc##Auto##Running
Network Store Interface Service##nsi##Auto##Running
Performance Counter DLL Host##PerfHost##Manual##Stopped
Performance Logs & Alerts##pla##Manual##Stopped
Plug and Play##PlugPlay##Manual##Running
IPsec Policy Agent##PolicyAgent##Manual##Running
Power##Power##Auto##Running
Printer Extensions and Notifications##PrintNotify##Manual##Stopped
User Profile Service##ProfSvc##Auto##Running
Remote Access Auto Connection Manager##RasAuto##Manual##Stopped
Remote Access Connection Manager##RasMan##Manual##Stopped
Routing and Remote Access##RemoteAccess##Disabled##Stopped
Remote Registry##RemoteRegistry##Auto##Stopped
RPC Endpoint Mapper##RpcEptMapper##Auto##Running
Remote Procedure Call (RPC) Locator##RpcLocator##Manual##Stopped
Remote Procedure Call (RPC)##RpcSs##Auto##Running
Resultant Set of Policy Provider##RSoPProv##Manual##Stopped
Special Administration Console Helper##sacsvr##Manual##Stopped
Security Accounts Manager##SamSs##Auto##Running
Smart Card##SCardSvr##Disabled##Stopped
Smart Card Device Enumeration Service##ScDeviceEnum##Manual##Stopped
Task Scheduler##Schedule##Auto##Running
Smart Card Removal Policy##SCPolicySvc##Manual##Stopped
Secondary Logon##seclogon##Manual##Stopped
System Event Notification Service##SENS##Auto##Running
Remote Desktop Configuration##SessionEnv##Manual##Running
Internet Connection Sharing (ICS)##SharedAccess##Disabled##Stopped
Shell Hardware Detection##ShellHWDetection##Auto##Running
Microsoft Storage Spaces SMP##smphost##Manual##Stopped
SNMP Service##SNMP##Auto##Running
SNMP Trap##SNMPTRAP##Manual##Stopped
Print Spooler##Spooler##Auto##Running
Software Protection##sppsvc##Auto##Stopped
SQL Server Browser##SQLBrowser##Auto##Running
SQL Server Agent (MSSQLSERVER)##SQLSERVERAGENT##Disabled##Stopped
SQL Server VSS Writer##SQLWriter##Auto##Running
SSDP Discovery##SSDPSRV##Disabled##Stopped
Secure Socket Tunneling Protocol Service##SstpSvc##Manual##Stopped
Spot Verifier##svsvc##Manual##Stopped
Microsoft Software Shadow Copy Provider##swprv##Manual##Stopped
Superfetch##SysMain##Manual##Stopped
System Events Broker##SystemEventsBroker##Auto##Running
Telephony##TapiSrv##Manual##Stopped
CLASS: Win32_TerminalService
DisplayName##Name##StartMode##State
Remote Desktop Services##TermService##Manual##Running
CLASS: Win32_Service
DisplayName##Name##StartMode##State
Themes##Themes##Auto##Running
Thread Ordering Server##THREADORDER##Manual##Stopped
Storage Tiers Management##TieringEngineService##Manual##Stopped
Distributed Link Tracking Client##TrkWks##Auto##Running
Windows Modules Installer##TrustedInstaller##Manual##Stopped
User Access Logging Service##UALSVC##Auto##Running
Interactive Services Detection##UI0Detect##Manual##Stopped
Remote Desktop Services UserMode Port Redirector##UmRdpService##Manual##Running
UPnP Device Host##upnphost##Disabled##Stopped
Credential Manager##VaultSvc##Manual##Stopped
Virtual Disk##vds##Manual##Stopped
VMware Alias Manager and Ticket Service##VGAuthService##Auto##Running
VMware SVGA Helper Service##vm3dservice##Auto##Running
Hyper-V Guest Service Interface##vmicguestinterface##Manual##Stopped
Hyper-V Heartbeat Service##vmicheartbeat##Manual##Stopped
Hyper-V Data Exchange Service##vmickvpexchange##Manual##Stopped
Hyper-V Remote Desktop Virtualization Service##vmicrdv##Manual##Stopped
Hyper-V Guest Shutdown Service##vmicshutdown##Manual##Stopped
Hyper-V Time Synchronization Service##vmictimesync##Manual##Stopped
Hyper-V Volume Shadow Copy Requestor##vmicvss##Manual##Stopped
VMware Tools##VMTools##Auto##Running
Volume Shadow Copy##VSS##Manual##Stopped
Windows Time##W32Time##Manual##Running
Windows Connection Manager##Wcmsvc##Auto##Running
Windows Color System##WcsPlugInService##Manual##Stopped
Diagnostic Service Host##WdiServiceHost##Manual##Stopped
Diagnostic System Host##WdiSystemHost##Manual##Stopped
Windows Event Collector##Wecsvc##Manual##Stopped
Windows Encryption Provider Host Service##WEPHOSTSVC##Manual##Stopped
Problem Reports and Solutions Control Panel Support##wercplsupport##Manual##Stopped
Windows Error Reporting Service##WerSvc##Manual##Stopped
WinHTTP Web Proxy Auto-Discovery Service##WinHttpAutoProxySvc##Manual##Running
Windows Management Instrumentation##Winmgmt##Auto##Running
Windows Remote Management (WS-Management)##WinRM##Auto##Running
WMI Performance Adapter##wmiApSrv##Manual##Running
Portable Device Enumerator Service##WPDBusEnum##Manual##Stopped
Windows Store Service (WSService)##WSService##Manual##Stopped
Windows Update##wuauserv##Manual##Stopped
Windows Driver Foundation - User-mode Driver Framework##wudfsvc##Manual##Stopped
]

SQL[SELECT * FROM `winservices` WHERE `device_id` = '26']
SQL RUNTIME[0.02052307s]
Array
(
[DisplayName] => Application Experience
[Name] => AeLookupSvc
[StartMode] => Manual
[State] => Stopped
)

SQL[UPDATE `winservices` set `displayname` ='Application Experience',`state` ='Stopped',`startmode` ='Manual' WHERE `device_id` = '26' AND `name` = 'AeLookupSvc']
SQL RUNTIME[50.51665998s]
SQL ERROR[Error in query: (Lock wait timeout exceeded; try restarting transaction) 1205]
Array
(
[DisplayName] => Application Layer Gateway Service
[Name] => ALG
[StartMode] => Manual
[State] => Stopped
)

SQL[UPDATE `winservices` set `displayname` ='Application Layer Gateway Service',`state` ='Stopped',`startmode` ='Manual' WHERE `device_id` = '26' AND `name` = 'ALG']
SQL RUNTIME[50.61821198s]
Array
(
[DisplayName] => Application Identity
[Name] => AppIDSvc
[StartMode] => Manual
[State] => Stopped
)

SQL[UPDATE `winservices` set `displayname` ='Application Identity',`state` ='Stopped',`startmode` ='Manual' WHERE `device_id` = '26' AND `name` = 'AppIDSvc']
SQL RUNTIME[50.48319983s]
SQL ERROR[Error in query: (Lock wait timeout exceeded; try restarting transaction) 1205]
Array
(
[DisplayName] => Application Information
[Name] => Appinfo
[StartMode] => Manual
[State] => Running
)

SQL[UPDATE `winservices` set `displayname` ='Application Information',`state` ='Running',`startmode` ='Manual' WHERE `device_id` = '26' AND `name` = 'Appinfo']
SQL RUNTIME[48.93595290s]
Array
(
[DisplayName] => Application Management
[Name] => AppMgmt
[StartMode] => Manual
[State] => Running
)

SQL[UPDATE `winservices` set `displayname` ='Application Management',`state` ='Running',`startmode` ='Manual' WHERE `device_id` = '26' AND `name` = 'AppMgmt']