public function Dblog404SensorPlugin::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
File
- src/
Plugin/ monitoring/ SensorPlugin/ Dblog404SensorPlugin.php, line 39 - Contains \Drupal\monitoring\Plugin\monitoring\SensorPlugin\Dblog404SensorPlugin.
Class
- Dblog404SensorPlugin
- Monitors 404 page errors from dblog.
Namespace
Drupal\monitoring\Plugin\monitoring\SensorPluginCode
public function getAggregateQuery() {
$query = parent::getAggregateQuery();
$query
->addField('watchdog', 'location');
// The message is the requested 404 URL.
$query
->groupBy('location');
$query
->orderBy('records_count', 'DESC');
$query
->range(0, 1);
return $query;
}