View: Watchdog entries

The view Watchdog entries is similar to page Recent log messages.

Important! Script below is for version 3.x. See new scripts for version 4.x here.

$view = new view();
$view->name = 'recent_log_messages_extended';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'watchdog';
$view->human_name = 'Recent log messages extended';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Recent log messages extended';
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'access site reports';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '50';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'severity' => 'severity',
  'type' => 'type',
  'timestamp' => 'timestamp',
  'message' => 'message',
  'name' => 'name',
);
$handler->display->display_options['style_options']['default'] = 'timestamp';
$handler->display->display_options['style_options']['info'] = array(
  'severity' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'type' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'timestamp' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'message' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'name' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
);
$handler->display->display_options['style_options']['sticky'] = TRUE;
/* Relationship: Watchdog: User */
$handler->display->display_options['relationships']['uid']['id'] = 'uid';
$handler->display->display_options['relationships']['uid']['table'] = 'watchdog';
$handler->display->display_options['relationships']['uid']['field'] = 'uid';
/* Field: Watchdog: Severity */
$handler->display->display_options['fields']['severity']['id'] = 'severity';
$handler->display->display_options['fields']['severity']['table'] = 'watchdog';
$handler->display->display_options['fields']['severity']['field'] = 'severity';
$handler->display->display_options['fields']['severity']['watchdog_severity_icon'] = 1;
/* Field: Watchdog: Type */
$handler->display->display_options['fields']['type']['id'] = 'type';
$handler->display->display_options['fields']['type']['table'] = 'watchdog';
$handler->display->display_options['fields']['type']['field'] = 'type';
/* Field: Watchdog: Timestamp */
$handler->display->display_options['fields']['timestamp']['id'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['table'] = 'watchdog';
$handler->display->display_options['fields']['timestamp']['field'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['label'] = 'Date';
$handler->display->display_options['fields']['timestamp']['date_format'] = 'short';
/* Field: Watchdog: Message */
$handler->display->display_options['fields']['message']['id'] = 'message';
$handler->display->display_options['fields']['message']['table'] = 'watchdog';
$handler->display->display_options['fields']['message']['field'] = 'message';
$handler->display->display_options['fields']['message']['alter']['max_length'] = '200';
$handler->display->display_options['fields']['message']['alter']['trim'] = TRUE;
$handler->display->display_options['fields']['message']['watchdog_message_format'] = 1;
$handler->display->display_options['fields']['message']['watchdog_message_link'] = 1;
/* Field: User: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'users';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['relationship'] = 'uid';
/* Filter criterion: Watchdog: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'watchdog';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['exposed'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['operator_id'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['label'] = 'Type';
$handler->display->display_options['filters']['type']['expose']['operator'] = 'type_op';
$handler->display->display_options['filters']['type']['expose']['identifier'] = 'type';
$handler->display->display_options['filters']['type']['expose']['multiple'] = TRUE;
$handler->display->display_options['filters']['type']['expose']['remember_roles'] = array();
/* Filter criterion: Watchdog: Severity */
$handler->display->display_options['filters']['severity']['id'] = 'severity';
$handler->display->display_options['filters']['severity']['table'] = 'watchdog';
$handler->display->display_options['filters']['severity']['field'] = 'severity';
$handler->display->display_options['filters']['severity']['exposed'] = TRUE;
$handler->display->display_options['filters']['severity']['expose']['operator_id'] = 'severity_op';
$handler->display->display_options['filters']['severity']['expose']['label'] = 'Severity';
$handler->display->display_options['filters']['severity']['expose']['operator'] = 'severity_op';
$handler->display->display_options['filters']['severity']['expose']['identifier'] = 'severity';
$handler->display->display_options['filters']['severity']['expose']['multiple'] = TRUE;
$handler->display->display_options['filters']['severity']['expose']['remember_roles'] = array();
/* Filter criterion: Watchdog: Timestamp */
$handler->display->display_options['filters']['timestamp']['id'] = 'timestamp';
$handler->display->display_options['filters']['timestamp']['table'] = 'watchdog';
$handler->display->display_options['filters']['timestamp']['field'] = 'timestamp';
$handler->display->display_options['filters']['timestamp']['operator'] = 'between';
$handler->display->display_options['filters']['timestamp']['exposed'] = TRUE;
$handler->display->display_options['filters']['timestamp']['expose']['operator_id'] = 'timestamp_op';
$handler->display->display_options['filters']['timestamp']['expose']['label'] = 'Date';
$handler->display->display_options['filters']['timestamp']['expose']['description'] = 'Format: CCYY-MM-DD HH:MM:SS';
$handler->display->display_options['filters']['timestamp']['expose']['operator'] = 'timestamp_op';
$handler->display->display_options['filters']['timestamp']['expose']['identifier'] = 'timestamp';
$handler->display->display_options['filters']['timestamp']['expose']['remember_roles'] = array();
/* Filter criterion: Watchdog: Message */
$handler->display->display_options['filters']['message']['id'] = 'message';
$handler->display->display_options['filters']['message']['table'] = 'watchdog';
$handler->display->display_options['filters']['message']['field'] = 'message';
$handler->display->display_options['filters']['message']['operator'] = 'contains';
$handler->display->display_options['filters']['message']['exposed'] = TRUE;
$handler->display->display_options['filters']['message']['expose']['operator_id'] = 'message_op';
$handler->display->display_options['filters']['message']['expose']['label'] = 'Message';
$handler->display->display_options['filters']['message']['expose']['description'] = 'Note: messages are stored in database as string with tokens';
$handler->display->display_options['filters']['message']['expose']['operator'] = 'message_op';
$handler->display->display_options['filters']['message']['expose']['identifier'] = 'message';
$handler->display->display_options['filters']['message']['expose']['remember_roles'] = array();

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'admin/reports/dblog/extended';
$translatables['recent_log_messages_extended'] = array(
  t('Master'),
  t('Recent log messages extended'),
  t('more'),
  t('Apply'),
  t('Reset'),
  t('Sort by'),
  t('Asc'),
  t('Desc'),
  t('Items per page'),
  t('- All -'),
  t('Offset'),
  t('« first'),
  t('‹ previous'),
  t('next ›'),
  t('last »'),
  t('Watchdog - Users'),
  t('Severity'),
  t('Type'),
  t('Date'),
  t('Message'),
  t('Name'),
  t('Format: CCYY-MM-DD HH:MM:SS'),
  t('Note: messages are stored in database as string with tokens'),
  t('Page'),
);