public function NonExistingUserFailedLoginsSensorPlugin::getAggregateQuery in Monitoring 8

Builds simple aggregate query over one db table.

Return value

\Drupal\Core\Database\Query\Select The select query object.

Overrides DatabaseAggregatorSensorPlugin::getAggregateQuery

1 call to NonExistingUserFailedLoginsSensorPlugin::getAggregateQuery()

NonExistingUserFailedLoginsSensorPlugin::verboseResultCounting in src/Plugin/monitoring/SensorPlugin/NonExistingUserFailedLoginsSensorPlugin.php

Get the verbose results of the attempts per ip.

File

src/Plugin/monitoring/SensorPlugin/NonExistingUserFailedLoginsSensorPlugin.php, line 29

Contains \Drupal\monitoring\Plugin\monitoring\SensorPlugin\NonExistingUserFailedLoginsSensorPlugin.

Class

NonExistingUserFailedLoginsSensorPlugin

Monitors non existing user failed login from dblog messages.

Namespace

Drupal\monitoring\Plugin\monitoring\SensorPlugin

Code

public function getAggregateQuery() {
  $query = parent::getAggregateQuery();
  $query
    ->addField('watchdog', 'variables');
  $query
    ->groupBy('variables');
  $query
    ->orderBy('records_count', 'DESC');
  return $query;
}