Adding upstream version 2.11.4.upstream/2.11.4upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

38 files changed, 2480 insertions, 0 deletions

diff --git a/modules/monitoring/library/Monitoring/DataView/Command.php b/modules/monitoring/library/Monitoring/DataView/Command.php
new file mode 100644
index 0000000..6beb8bc
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Command.php
@@ -0,0 +1,24 @@
+<?php
+/* Icinga Web 2 | (c) 2014 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * View representation for commands
+ */
+class Command extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'command_id',
+            'command_instance_id',
+            'command_config_type',
+            'command_line',
+            'command_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Comment.php b/modules/monitoring/library/Monitoring/DataView/Comment.php
new file mode 100644
index 0000000..3a035bc
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Comment.php
@@ -0,0 +1,82 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Host and service comments view
+ */
+class Comment extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'comment_author_name',
+            'comment_data',
+            'comment_expiration',
+            'comment_internal_id',
+            'comment_is_persistent',
+            'comment_name',
+            'comment_timestamp',
+            'comment_type',
+            'host_display_name',
+            'host_name',
+            'object_type',
+            'service_description',
+            'service_display_name',
+            'service_host_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'comment_author',
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('host_display_name', 'service_display_name');
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'comment_timestamp' => array(
+                'order' => self::SORT_DESC
+            ),
+            'host_display_name' => array(
+                'columns' => array(
+                    'host_display_name',
+                    'service_display_name'
+                ),
+                'order' => self::SORT_ASC
+            ),
+            'service_display_name' => array(
+                'columns' => array(
+                    'service_display_name',
+                    'host_display_name'
+                ),
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Commentevent.php b/modules/monitoring/library/Monitoring/DataView/Commentevent.php
new file mode 100644
index 0000000..316700a
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Commentevent.php
@@ -0,0 +1,30 @@
+<?php
+/* Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Commentevent extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'commentevent_id',
+            'commentevent_entry_type',
+            'commentevent_comment_time',
+            'commentevent_author_name',
+            'commentevent_comment_data',
+            'commentevent_is_persistent',
+            'commentevent_comment_source',
+            'commentevent_expires',
+            'commentevent_expiration_time',
+            'commentevent_deletion_time',
+            'host_name',
+            'service_description'
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array('commentevent_id');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Contact.php b/modules/monitoring/library/Monitoring/DataView/Contact.php
new file mode 100644
index 0000000..986acab
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Contact.php
@@ -0,0 +1,73 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Contact extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'contact_object_id',
+            'contact_id',
+            'contact_name',
+            'contact_alias',
+            'contact_email',
+            'contact_pager',
+            'contact_has_host_notfications',
+            'contact_has_service_notfications',
+            'contact_can_submit_commands',
+            'contact_notify_service_recovery',
+            'contact_notify_service_warning',
+            'contact_notify_service_critical',
+            'contact_notify_service_unknown',
+            'contact_notify_service_flapping',
+            'contact_notify_service_downtime',
+            'contact_notify_host_recovery',
+            'contact_notify_host_down',
+            'contact_notify_host_unreachable',
+            'contact_notify_host_flapping',
+            'contact_notify_host_downtime',
+            'contact_notify_host_timeperiod',
+            'contact_notify_service_timeperiod'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'contact_name' => array(
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'contact', 'instance_name',
+            'contactgroup', 'contactgroup_name', 'contactgroup_alias',
+            'host', 'host_name', 'host_display_name', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('contact_alias');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Contactgroup.php b/modules/monitoring/library/Monitoring/DataView/Contactgroup.php
new file mode 100644
index 0000000..84eecd1
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Contactgroup.php
@@ -0,0 +1,57 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Contactgroup extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'contactgroup_name',
+            'contactgroup_alias',
+            'contact_count'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'contactgroup_name' => array(
+                'order' => self::SORT_ASC
+            ),
+            'contactgroup_alias' => array(
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'contactgroup',
+            'host', 'host_name', 'host_display_name', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('contactgroup_alias');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Customvar.php b/modules/monitoring/library/Monitoring/DataView/Customvar.php
new file mode 100644
index 0000000..c02d52f
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Customvar.php
@@ -0,0 +1,47 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Customvar extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'varname',
+            'varvalue',
+            'is_json',
+            'host_name',
+            'service_description',
+            'contact_name',
+            'object_type',
+            'object_type_id'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'varname' => array(
+                'columns' => array(
+                    'varname',
+                    'varvalue'
+                )
+            )
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array('host', 'service', 'contact');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/DataView.php b/modules/monitoring/library/Monitoring/DataView/DataView.php
new file mode 100644
index 0000000..5b16e28
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/DataView.php
@@ -0,0 +1,608 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+use Icinga\Data\Filter\FilterExpression;
+use Icinga\Data\Filter\FilterMatch;
+use IteratorAggregate;
+use Icinga\Application\Hook;
+use Icinga\Data\ConnectionInterface;
+use Icinga\Data\Filter\Filter;
+use Icinga\Data\FilterColumns;
+use Icinga\Data\PivotTable;
+use Icinga\Data\QueryInterface;
+use Icinga\Data\SortRules;
+use Icinga\Exception\QueryException;
+use Icinga\Module\Monitoring\Backend\Ido\Query\IdoQuery;
+use Icinga\Module\Monitoring\Backend\MonitoringBackend;
+use Icinga\Web\Request;
+use Icinga\Web\Url;
+use Traversable;
+
+/**
+ * A read-only view of an underlying query
+ */
+abstract class DataView implements QueryInterface, SortRules, FilterColumns, IteratorAggregate
+{
+    /**
+     * The query used to populate the view
+     *
+     * @var IdoQuery
+     */
+    protected $query;
+
+    protected $connection;
+
+    protected $isSorted = false;
+
+    /**
+     * The cache for all filter columns
+     *
+     * @var array
+     */
+    protected $filterColumns;
+
+    /**
+     * Create a new view
+     *
+     * @param ConnectionInterface   $connection
+     * @param array                 $columns
+     */
+    public function __construct(ConnectionInterface $connection, array $columns = null)
+    {
+        $this->connection = $connection;
+        $this->query = $connection->query($this->getQueryName(), $columns);
+    }
+
+    /**
+     * Return a iterator for all rows of the result set
+     *
+     * @return  IdoQuery
+     */
+    public function getIterator(): Traversable
+    {
+        return $this->getQuery();
+    }
+
+    /**
+     * Return the current position of the result set's iterator
+     *
+     * @return  int
+     */
+    public function getIteratorPosition()
+    {
+        return $this->query->getIteratorPosition();
+    }
+
+    /**
+     * Get the query name this data view relies on
+     *
+     * By default this is this class' name without its namespace
+     *
+     * @return string
+     */
+    public static function getQueryName()
+    {
+        $tableName = explode('\\', get_called_class());
+        $tableName = end($tableName);
+        return $tableName;
+    }
+
+    public function where($condition, $value = null)
+    {
+        $this->query->where($condition, $value);
+        return $this;
+    }
+
+    /**
+     * Add a filter expression, with as less validation as possible
+     *
+     * @param FilterExpression $ex
+     *
+     * @internal If you use this outside the monitoring module, it's your fault if something breaks
+     * @return $this
+     */
+    public function whereEx(FilterExpression $ex)
+    {
+        $this->query->whereEx($ex);
+        return $this;
+    }
+
+    public function dump()
+    {
+        if (! $this->isSorted) {
+            $this->order();
+        }
+        return $this->query->dump();
+    }
+
+    /**
+     * Retrieve columns provided by this view
+     *
+     * @return array
+     */
+    abstract public function getColumns();
+
+    protected function getHookedColumns()
+    {
+        $columns = array();
+        foreach (Hook::all('monitoring/dataviewExtension') as $hook) {
+            foreach ($hook->getAdditionalQueryColumns($this->getQueryName()) as $col) {
+                $columns[] = $col;
+            }
+        }
+
+        return $columns;
+    }
+
+    /**
+     * Create view from params
+     *
+     * @param   array $params
+     * @param   array $columns
+     *
+     * @return  static
+     */
+    public static function fromParams(array $params, array $columns = null)
+    {
+        $view = new static(MonitoringBackend::instance($params['backend']), $columns);
+
+        foreach ($params as $key => $value) {
+            if ($view->isValidFilterTarget($key)) {
+                $view->where($key, $value);
+            }
+        }
+
+        if (isset($params['sort'])) {
+            $order = isset($params['order']) ? $params['order'] : null;
+            if ($order !== null) {
+                if (strtolower($order) === 'desc') {
+                    $order = self::SORT_DESC;
+                } else {
+                    $order = self::SORT_ASC;
+                }
+            }
+
+            $view->order($params['sort'], $order);
+        }
+        return $view;
+    }
+
+    /**
+     * Check whether the given column is a valid filter column
+     *
+     * @param   string  $column
+     *
+     * @return  bool
+     */
+    public function isValidFilterTarget($column)
+    {
+        // Customvar
+        if ($column[0] === '_' && preg_match('/^_(?:host|service)_/i', $column)) {
+            return true;
+        }
+        return in_array($column, $this->getColumns()) || in_array($column, $this->getStaticFilterColumns());
+    }
+
+    /**
+     * Return all filter columns with their optional label as key
+     *
+     * This will merge the results of self::getColumns(), self::getStaticFilterColumns() and
+     * self::getDynamicFilterColumns() *once*. (i.e. subsequent calls of this function will
+     * return the same result.)
+     *
+     * @return  array
+     */
+    public function getFilterColumns()
+    {
+        if ($this->filterColumns === null) {
+            $columns = array_merge(
+                $this->getColumns(),
+                $this->getStaticFilterColumns(),
+                $this->getDynamicFilterColumns()
+            );
+
+            $this->filterColumns = array();
+            foreach ($columns as $label => $column) {
+                if (is_int($label)) {
+                    $label = ucwords(str_replace('_', ' ', $column));
+                }
+
+                if ($this->query->isCaseInsensitive($column)) {
+                    $label .= ' ' . t('(Case insensitive)');
+                }
+
+                $this->filterColumns[$label] = $column;
+            }
+        }
+
+        return $this->filterColumns;
+    }
+
+    /**
+     * Return all static filter columns
+     *
+     * @return  array
+     */
+    public function getStaticFilterColumns()
+    {
+        return array();
+    }
+
+    /**
+     * Return all dynamic filter columns such as custom variables
+     *
+     * @return  array
+     */
+    public function getDynamicFilterColumns()
+    {
+        $columns = array();
+        if (! $this->query->allowsCustomVars()) {
+            return $columns;
+        }
+
+        $query = MonitoringBackend::instance()
+            ->select()
+            ->from('customvar', array('varname', 'object_type'))
+            ->where('is_json', 0)
+            ->where('object_type_id', array(1, 2))
+            ->getQuery()->group(array('varname', 'object_type'));
+        foreach ($query as $row) {
+            if ($row->object_type === 'host') {
+                $label = t('Host') . ' ' . ucwords(str_replace('_', ' ', $row->varname));
+                $columns[$label] = '_host_' . $row->varname;
+            } else { // $row->object_type === 'service'
+                $label = t('Service') . ' ' . ucwords(str_replace('_', ' ', $row->varname));
+                $columns[$label] = '_service_' . $row->varname;
+            }
+        }
+
+        return $columns;
+    }
+
+    /**
+     * Return the current filter
+     *
+     * @return  Filter
+     */
+    public function getFilter()
+    {
+        return $this->query->getFilter();
+    }
+
+    /**
+     * Return a pivot table for the given columns based on the current query
+     *
+     * @param   string  $xAxisColumn    The column to use for the x axis
+     * @param   string  $yAxisColumn    The column to use for the y axis
+     * @param   Filter  $xAxisFilter    The filter to apply on a query for the x axis
+     * @param   Filter  $yAxisFilter    The filter to apply on a query for the y axis
+     *
+     * @return  PivotTable
+     */
+    public function pivot($xAxisColumn, $yAxisColumn, Filter $xAxisFilter = null, Filter $yAxisFilter = null)
+    {
+        $pivot = new PivotTable($this->query, $xAxisColumn, $yAxisColumn);
+        return $pivot->setXAxisFilter($xAxisFilter)->setYAxisFilter($yAxisFilter);
+    }
+
+    /**
+     * Sort result set either by the given column (and direction) or the sort defaults
+     *
+     * @param  string   $column
+     * @param  string   $direction
+     *
+     * @return $this
+     */
+    public function order($column = null, $direction = null)
+    {
+        $sortRules = $this->getSortRules();
+        if ($column === null) {
+            // Use first available sort rule as default
+            if (empty($sortRules)) {
+                return $this;
+            }
+            $sortColumns = reset($sortRules);
+            if (! isset($sortColumns['columns'])) {
+                $sortColumns['columns'] = array(key($sortRules));
+            }
+        } else {
+            if (isset($sortRules[$column])) {
+                $sortColumns = $sortRules[$column];
+                if (! isset($sortColumns['columns'])) {
+                    $sortColumns['columns'] = array($column);
+                }
+            } else {
+                $sortColumns = array(
+                    'columns' => array($column),
+                    'order' => $direction
+                );
+            };
+        }
+
+        $direction = $direction === null ? ($sortColumns['order'] ?? static::SORT_ASC) : $direction;
+        $direction = (strtoupper($direction) === static::SORT_ASC) ? 'ASC' : 'DESC';
+
+        foreach ($sortColumns['columns'] as $column) {
+            list($column, $order) = $this->query->splitOrder($column);
+            if (! $this->isValidFilterTarget($column)) {
+                throw new QueryException(
+                    mt('monitoring', 'The sort column "%s" is not allowed in "%s".'),
+                    $column,
+                    get_class($this)
+                );
+            }
+            $this->query->order($column, $order !== null ? $order : $direction);
+        }
+        $this->isSorted = true;
+        return $this;
+    }
+
+    /**
+     * Retrieve default sorting rules for particular columns. These involve sort order and potential additional to sort
+     *
+     * @return array
+     */
+    public function getSortRules()
+    {
+        return array();
+    }
+
+    /**
+     * Whether an order is set
+     *
+     * @return bool
+     */
+    public function hasOrder()
+    {
+        return $this->query->hasOrder();
+    }
+
+    /**
+     * Get the order if any
+     *
+     * @return array|null
+     */
+    public function getOrder()
+    {
+        return $this->query->getOrder();
+    }
+
+    public function getMappedField($field)
+    {
+        return $this->query->getMappedField($field);
+    }
+
+    /**
+     * Return the query which was created in the constructor
+     *
+     * @return \Icinga\Data\SimpleQuery
+     */
+    public function getQuery()
+    {
+        if (! $this->isSorted) {
+            $this->order();
+        }
+        return $this->query;
+    }
+
+    public function applyFilter(Filter $filter)
+    {
+        $this->validateFilterColumns($filter);
+
+        return $this->addFilter($filter);
+    }
+
+    /**
+     * Validates recursive the Filter columns against the isValidFilterTarget() method
+     *
+     * @param Filter $filter
+     *
+     * @throws \Icinga\Data\Filter\FilterException
+     */
+    public function validateFilterColumns(Filter $filter)
+    {
+        if ($filter instanceof FilterMatch) {
+            if (! $this->isValidFilterTarget($filter->getColumn())) {
+                throw new QueryException(
+                    mt('monitoring', 'The filter column "%s" is not allowed here.'),
+                    $filter->getColumn()
+                );
+            }
+        }
+
+        if (method_exists($filter, 'filters')) {
+            foreach ($filter->filters() as $filter) {
+                $this->validateFilterColumns($filter);
+            }
+        }
+    }
+
+    public function clearFilter()
+    {
+        $this->query->clearFilter();
+        return $this;
+    }
+
+    /**
+     * @deprecated(EL): Only use DataView::applyFilter() for applying filter because all other functions are missing
+     * column validation. Filter::matchAny() for the IdoQuery (or the DbQuery or the SimpleQuery I didn't have a look)
+     * is required for the filter to work properly.
+     */
+    public function setFilter(Filter $filter)
+    {
+        $this->query->setFilter($filter);
+        return $this;
+    }
+
+    /**
+     * Get the view's search columns
+     *
+     * @return string[]
+     */
+    public function getSearchColumns()
+    {
+        return array();
+    }
+
+    /**
+     * @deprecated(EL): Only use DataView::applyFilter() for applying filter because all other functions are missing
+     * column validation.
+     */
+    public function addFilter(Filter $filter)
+    {
+        $this->query->addFilter($filter);
+        return $this;
+    }
+
+    /**
+     * Count result set
+     *
+     * @return int
+     */
+    public function count(): int
+    {
+        return $this->query->count();
+    }
+
+    /**
+     * Set whether the query should peek ahead for more results
+     *
+     * Enabling this causes the current query limit to be increased by one. The potential extra row being yielded will
+     * be removed from the result set. Note that this only applies when fetching multiple results of limited queries.
+     *
+     * @return  $this
+     */
+    public function peekAhead($state = true)
+    {
+        $this->query->peekAhead($state);
+        return $this;
+    }
+
+    /**
+     * Return whether the query did not yield all available results
+     *
+     * @return  bool
+     */
+    public function hasMore()
+    {
+        return $this->query->hasMore();
+    }
+
+    /**
+     * Return whether this query will or has yielded any result
+     *
+     * @return  bool
+     */
+    public function hasResult()
+    {
+        return $this->query->hasResult();
+    }
+
+    /**
+     * Set a limit count and offset
+     *
+     * @param   int $count  Number of rows to return
+     * @param   int $offset Start returning after this many rows
+     *
+     * @return  self
+     */
+    public function limit($count = null, $offset = null)
+    {
+        $this->query->limit($count, $offset);
+        return $this;
+    }
+
+    /**
+     * Whether a limit is set
+     *
+     * @return bool
+     */
+    public function hasLimit()
+    {
+        return $this->query->hasLimit();
+    }
+
+    /**
+     * Get the limit if any
+     *
+     * @return int|null
+     */
+    public function getLimit()
+    {
+        return $this->query->getLimit();
+    }
+
+    /**
+     * Whether an offset is set
+     *
+     * @return bool
+     */
+    public function hasOffset()
+    {
+        return $this->query->hasOffset();
+    }
+
+    /**
+     * Get the offset if any
+     *
+     * @return int|null
+     */
+    public function getOffset()
+    {
+        return $this->query->getOffset();
+    }
+
+    /**
+     * Retrieve an array containing all rows of the result set
+     *
+     * @return  array
+     */
+    public function fetchAll()
+    {
+        return $this->getQuery()->fetchAll();
+    }
+
+    /**
+     * Fetch the first row of the result set
+     *
+     * @return  mixed
+     */
+    public function fetchRow()
+    {
+        return $this->getQuery()->fetchRow();
+    }
+
+    /**
+     * Fetch the first column of all rows of the result set as an array
+     *
+     * @return  array
+     */
+    public function fetchColumn()
+    {
+        return $this->getQuery()->fetchColumn();
+    }
+
+    /**
+     * Fetch the first column of the first row of the result set
+     *
+     * @return  string
+     */
+    public function fetchOne()
+    {
+        return $this->getQuery()->fetchOne();
+    }
+
+    /**
+     * Fetch all rows of the result set as an array of key-value pairs
+     *
+     * The first column is the key, the second column is the value.
+     *
+     * @return  array
+     */
+    public function fetchPairs()
+    {
+        return $this->getQuery()->fetchPairs();
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Downtime.php b/modules/monitoring/library/Monitoring/DataView/Downtime.php
new file mode 100644
index 0000000..ca42e2d
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Downtime.php
@@ -0,0 +1,96 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Host and service downtimes view
+ */
+class Downtime extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'downtime_author_name',
+            'downtime_comment',
+            'downtime_duration',
+            'downtime_end',
+            'downtime_entry_time',
+            'downtime_internal_id',
+            'downtime_is_fixed',
+            'downtime_is_flexible',
+            'downtime_is_in_effect',
+            'downtime_name',
+            'downtime_scheduled_end',
+            'downtime_scheduled_start',
+            'downtime_start',
+            'host_display_name',
+            'host_name',
+            'host_state',
+            'object_type',
+            'service_description',
+            'service_display_name',
+            'service_host_name',
+            'service_state'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'downtime_author',
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('host_display_name', 'service_display_name');
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'downtime_is_in_effect' => array(
+                'columns' => array(
+                    'downtime_is_in_effect',
+                    'downtime_scheduled_start'
+                ),
+                'order' => self::SORT_DESC
+            ),
+            'downtime_start' => array(
+                'order' => self::SORT_DESC
+            ),
+            'host_display_name' => array(
+                'columns' => array(
+                    'host_display_name',
+                    'service_display_name'
+                ),
+                'order' => self::SORT_ASC
+            ),
+            'service_display_name' => array(
+                'columns' => array(
+                    'service_display_name',
+                    'host_display_name'
+                ),
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Downtimeevent.php b/modules/monitoring/library/Monitoring/DataView/Downtimeevent.php
new file mode 100644
index 0000000..a1fc0f6
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Downtimeevent.php
@@ -0,0 +1,33 @@
+<?php
+/* Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Downtimeevent extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'downtimeevent_id',
+            'downtimeevent_entry_time',
+            'downtimeevent_author_name',
+            'downtimeevent_comment_data',
+            'downtimeevent_is_fixed',
+            'downtimeevent_scheduled_start_time',
+            'downtimeevent_scheduled_end_time',
+            'downtimeevent_was_started',
+            'downtimeevent_actual_start_time',
+            'downtimeevent_actual_end_time',
+            'downtimeevent_was_cancelled',
+            'downtimeevent_is_in_effect',
+            'downtimeevent_trigger_time',
+            'host_name',
+            'service_description'
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array('downtimeevent_id');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Eventgrid.php b/modules/monitoring/library/Monitoring/DataView/Eventgrid.php
new file mode 100644
index 0000000..1639e6b
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Eventgrid.php
@@ -0,0 +1,60 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Eventgrid extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'day',
+            'cnt_up',
+            'cnt_down_hard',
+            'cnt_down',
+            'cnt_unreachable_hard',
+            'cnt_unreachable',
+            'cnt_unknown_hard',
+            'cnt_unknown',
+            'cnt_critical',
+            'cnt_critical_hard',
+            'cnt_warning',
+            'cnt_warning_hard',
+            'cnt_ok',
+            'host_name',
+            'host_display_name',
+            'service_description',
+            'service_display_name',
+            'timestamp'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'day' => array(
+                'order' => self::SORT_DESC
+            )
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_host_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Eventgridhosts.php b/modules/monitoring/library/Monitoring/DataView/Eventgridhosts.php
new file mode 100644
index 0000000..9d9acc9
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Eventgridhosts.php
@@ -0,0 +1,7 @@
+<?php
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Eventgridhosts extends Eventgrid
+{
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Eventgridservices.php b/modules/monitoring/library/Monitoring/DataView/Eventgridservices.php
new file mode 100644
index 0000000..faa1065
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Eventgridservices.php
@@ -0,0 +1,7 @@
+<?php
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Eventgridservices extends Eventgrid
+{
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Eventhistory.php b/modules/monitoring/library/Monitoring/DataView/Eventhistory.php
new file mode 100644
index 0000000..cd947f5
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Eventhistory.php
@@ -0,0 +1,60 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class EventHistory extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'id',
+            'instance_name',
+            'host_name',
+            'host_display_name',
+            'service_description',
+            'service_display_name',
+            'object_type',
+            'timestamp',
+            'state',
+            'output',
+            'type'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'timestamp' => array(
+                'order' => self::SORT_DESC
+            )
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('host_display_name', 'service_display_name');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Flappingevent.php b/modules/monitoring/library/Monitoring/DataView/Flappingevent.php
new file mode 100644
index 0000000..bc79497
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Flappingevent.php
@@ -0,0 +1,27 @@
+<?php
+/* Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Flappingevent extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'flappingevent_id',
+            'flappingevent_event_time',
+            'flappingevent_event_type',
+            'flappingevent_reason_type',
+            'flappingevent_percent_state_change',
+            'flappingevent_low_threshold',
+            'flappingevent_high_threshold',
+            'host_name',
+            'service_description'
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array('flappingevent_id');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Hostcomment.php b/modules/monitoring/library/Monitoring/DataView/Hostcomment.php
new file mode 100644
index 0000000..74fc2ef
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Hostcomment.php
@@ -0,0 +1,45 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Host comment view
+ */
+class Hostcomment extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'comment_author',
+            'comment_author_name',
+            'comment_data',
+            'comment_expiration',
+            'comment_internal_id',
+            'comment_is_persistent',
+            'comment_name',
+            'comment_timestamp',
+            'comment_type',
+            'host_display_name',
+            'host_name',
+            'object_type'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Hostcontact.php b/modules/monitoring/library/Monitoring/DataView/Hostcontact.php
new file mode 100644
index 0000000..ecfed2f
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Hostcontact.php
@@ -0,0 +1,17 @@
+<?php
+/* Icinga Web 2 | (c) 2018 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Hostcontact extends Contact
+{
+    public function getColumns()
+    {
+        return [
+            'contact_name',
+            'contact_alias',
+            'contact_email',
+            'contact_pager'
+        ];
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Hostdowntime.php b/modules/monitoring/library/Monitoring/DataView/Hostdowntime.php
new file mode 100644
index 0000000..f5e4e80
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Hostdowntime.php
@@ -0,0 +1,50 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Host downtime view
+ */
+class Hostdowntime extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'downtime_author',
+            'downtime_author_name',
+            'downtime_comment',
+            'downtime_duration',
+            'downtime_end',
+            'downtime_entry_time',
+            'downtime_internal_id',
+            'downtime_is_fixed',
+            'downtime_is_flexible',
+            'downtime_is_in_effect',
+            'downtime_name',
+            'downtime_scheduled_end',
+            'downtime_scheduled_start',
+            'downtime_start',
+            'host_display_name',
+            'host_name',
+            'object_type'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Hostgroup.php b/modules/monitoring/library/Monitoring/DataView/Hostgroup.php
new file mode 100644
index 0000000..b204fcd
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Hostgroup.php
@@ -0,0 +1,34 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Host group data view
+ */
+class Hostgroup extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'hostgroup_alias',
+            'hostgroup_name'
+        );
+    }
+
+    public function getSortRules()
+    {
+        return array(
+            'hostgroup_alias' => array(
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name', 'host_name', 'service_description', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Hostgroupsummary.php b/modules/monitoring/library/Monitoring/DataView/Hostgroupsummary.php
new file mode 100644
index 0000000..9ed2eb9
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Hostgroupsummary.php
@@ -0,0 +1,81 @@
+<?php
+/* Icinga Web 2 | (c) 2015 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Data view for the host group summary
+ */
+class Hostgroupsummary extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'hostgroup_alias',
+            'hostgroup_name',
+            'hosts_down_handled',
+            'hosts_down_unhandled',
+            'hosts_pending',
+            'hosts_severity',
+            'hosts_total',
+            'hosts_unreachable_handled',
+            'hosts_unreachable_unhandled',
+            'hosts_up',
+            'services_critical_handled',
+            'services_critical_unhandled',
+            'services_ok',
+            'services_pending',
+            'services_total',
+            'services_unknown_handled',
+            'services_unknown_unhandled',
+            'services_warning_handled',
+            'services_warning_unhandled'
+        );
+    }
+
+    public function getSearchColumns()
+    {
+        return array('hostgroup', 'hostgroup_alias');
+    }
+
+    public function getSortRules()
+    {
+        return array(
+            'hostgroup_alias' => array(
+                'order' => self::SORT_ASC
+            ),
+            'hosts_severity' => array(
+                'columns' => array(
+                    'hosts_severity',
+                    'hostgroup_alias ASC'
+                ),
+                'order' => self::SORT_DESC
+            )
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'host_contact', 'host_contactgroup', 'host_name',
+            'hostgroup',
+            'service_description',
+            'servicegroup_name'
+        );
+    }
+
+    public function getFilterColumns()
+    {
+        if ($this->filterColumns === null) {
+            $filterColumns = parent::getFilterColumns();
+            $diff = array_diff($filterColumns, $this->getColumns());
+            $this->filterColumns = array_merge($diff, [
+                'Hostgroup Name'    => 'hostgroup_name',
+                'Hostgroup Alias'   => 'hostgroup_alias'
+            ]);
+        }
+
+        return $this->filterColumns;
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Hoststatus.php b/modules/monitoring/library/Monitoring/DataView/Hoststatus.php
new file mode 100644
index 0000000..6440fe5
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Hoststatus.php
@@ -0,0 +1,129 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class HostStatus extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array_merge($this->getHookedColumns(), array(
+            'host_acknowledged',
+            'host_acknowledgement_type',
+            'host_action_url',
+            'host_active_checks_enabled',
+            'host_active_checks_enabled_changed',
+            'host_address',
+            'host_address6',
+            'host_alias',
+            'host_check_command',
+            'host_check_execution_time',
+            'host_check_latency',
+            'host_check_source',
+            'host_check_timeperiod',
+            'host_current_check_attempt',
+            'host_current_notification_number',
+            'host_display_name',
+            'host_event_handler_enabled',
+            'host_event_handler_enabled_changed',
+            'host_flap_detection_enabled',
+            'host_flap_detection_enabled_changed',
+            'host_handled',
+            'host_hard_state',
+            'host_in_downtime',
+            'host_ipv4',
+            'host_is_flapping',
+            'host_is_reachable',
+            'host_last_check',
+            'host_last_notification',
+            'host_last_state_change',
+            'host_last_state_change_ts',
+            'host_long_output',
+            'host_max_check_attempts',
+            'host_modified_host_attributes',
+            'host_name',
+            'host_next_check',
+            'host_notes_url',
+            'host_notifications_enabled',
+            'host_notifications_enabled_changed',
+            'host_obsessing',
+            'host_obsessing_changed',
+            'host_output',
+            'host_passive_checks_enabled',
+            'host_passive_checks_enabled_changed',
+            'host_percent_state_change',
+            'host_perfdata',
+            'host_problem',
+            'host_severity',
+            'host_state',
+            'host_state_type',
+            'host_unhandled',
+            'instance_name'
+        ));
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'host', 'host_contact', 'host_contactgroup',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns($search = null)
+    {
+        if ($search !== null
+            && (@inet_pton($search) !== false || preg_match('/^\d{1,3}\.\d{1,3}\./', $search))
+        ) {
+            return array('host', 'host_address', 'host_address6');
+        } else {
+            if ($this->connection->isIcinga2()) {
+                return array('host', 'host_display_name');
+            } else {
+                return array('host', 'host_display_name', 'host_alias');
+            }
+        }
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'host_display_name' => array(
+                'order' => self::SORT_ASC
+            ),
+            'host_severity' => array(
+                'columns' => array(
+                    'host_severity',
+                    'host_last_state_change_ts DESC'
+                ),
+                'order' => self::SORT_DESC
+            ),
+            'host_address' => array(
+                'columns' => array(
+                    'host_ipv4'
+                ),
+                'order' => self::SORT_ASC
+            ),
+            'host_last_state_change' => array(
+                'columns' => array(
+                    'host_last_state_change_ts'
+                ),
+                'order' => self::SORT_DESC
+            )
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Hoststatussummary.php b/modules/monitoring/library/Monitoring/DataView/Hoststatussummary.php
new file mode 100644
index 0000000..a857466
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Hoststatussummary.php
@@ -0,0 +1,40 @@
+<?php
+/* Icinga Web 2 | (c) 2015 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Data view for host status summaries
+ */
+class Hoststatussummary extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'hosts_down_handled',
+            'hosts_down_unhandled',
+            'hosts_pending',
+            'hosts_total',
+            'hosts_unreachable_handled',
+            'hosts_unreachable_unhandled',
+            'hosts_up',
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'host', 'host_alias', 'host_display_name', 'host_name',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Instance.php b/modules/monitoring/library/Monitoring/DataView/Instance.php
new file mode 100644
index 0000000..98ef1d6
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Instance.php
@@ -0,0 +1,33 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * View representation for instances
+ */
+class Instance extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'instance_id',
+            'instance_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'instance_name' => array(
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Notification.php b/modules/monitoring/library/Monitoring/DataView/Notification.php
new file mode 100644
index 0000000..90755de
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Notification.php
@@ -0,0 +1,59 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Notification extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'host_display_name',
+            'host_name',
+            'notification_contact_name',
+            'notification_output',
+            'notification_reason',
+            'notification_state',
+            'notification_timestamp',
+            'object_type',
+            'service_description',
+            'service_display_name',
+            'service_host_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'notification_timestamp' => array(
+                'order' => self::SORT_DESC
+            )
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'hostgroup_name',
+            'instance_name',
+            'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('host_display_name', 'service_display_name');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Notificationevent.php b/modules/monitoring/library/Monitoring/DataView/Notificationevent.php
new file mode 100644
index 0000000..82dd212
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Notificationevent.php
@@ -0,0 +1,29 @@
+<?php
+/* Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Notificationevent extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'notificationevent_id',
+            'notificationevent_reason',
+            'notificationevent_start_time',
+            'notificationevent_end_time',
+            'notificationevent_state',
+            'notificationevent_output',
+            'notificationevent_long_output',
+            'notificationevent_escalated',
+            'notificationevent_contacts_notified',
+            'host_name',
+            'service_description'
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array('notificationevent_id');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Programstatus.php b/modules/monitoring/library/Monitoring/DataView/Programstatus.php
new file mode 100644
index 0000000..d611c72
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Programstatus.php
@@ -0,0 +1,44 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * View for programstatus query
+ */
+class Programstatus extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'id',
+            'status_update_time',
+            'program_start_time',
+            'program_end_time',
+            'is_currently_running',
+            'process_id',
+            'daemon_mode',
+            'last_command_check',
+            'last_log_rotation',
+            'notifications_enabled',
+            'disable_notif_expire_time',
+            'active_service_checks_enabled',
+            'passive_service_checks_enabled',
+            'active_host_checks_enabled',
+            'passive_host_checks_enabled',
+            'event_handlers_enabled',
+            'flap_detection_enabled',
+            'failure_prediction_enabled',
+            'process_performance_data',
+            'obsess_over_hosts',
+            'obsess_over_services',
+            'modified_host_attributes',
+            'modified_service_attributes',
+            'global_host_event_handler',
+            'global_service_event_handler',
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Runtimesummary.php b/modules/monitoring/library/Monitoring/DataView/Runtimesummary.php
new file mode 100644
index 0000000..bf80226
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Runtimesummary.php
@@ -0,0 +1,38 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * View for runtimesummary query
+ */
+class Runtimesummary extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'check_type',
+            'active_checks_enabled',
+            'passive_checks_enabled',
+            'execution_time',
+            'latency',
+            'object_count',
+            'object_type'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'active_checks_enabled' => array(
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Runtimevariables.php b/modules/monitoring/library/Monitoring/DataView/Runtimevariables.php
new file mode 100644
index 0000000..b3624b7
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Runtimevariables.php
@@ -0,0 +1,34 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * View for runtimevariables query
+ */
+class Runtimevariables extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'id',
+            'varname',
+            'varvalue'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'id' => array(
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Servicecomment.php b/modules/monitoring/library/Monitoring/DataView/Servicecomment.php
new file mode 100644
index 0000000..78c1333
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Servicecomment.php
@@ -0,0 +1,48 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Service comment view
+ */
+class Servicecomment extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'comment_author',
+            'comment_author_name',
+            'comment_data',
+            'comment_expiration',
+            'comment_internal_id',
+            'comment_is_persistent',
+            'comment_name',
+            'comment_timestamp',
+            'comment_type',
+            'host_display_name',
+            'host_name',
+            'object_type',
+            'service_description',
+            'service_display_name',
+            'service_host_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Servicecontact.php b/modules/monitoring/library/Monitoring/DataView/Servicecontact.php
new file mode 100644
index 0000000..55c9950
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Servicecontact.php
@@ -0,0 +1,8 @@
+<?php
+/* Icinga Web 2 | (c) 2018 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Servicecontact extends Hostcontact
+{
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Servicedowntime.php b/modules/monitoring/library/Monitoring/DataView/Servicedowntime.php
new file mode 100644
index 0000000..43d895e
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Servicedowntime.php
@@ -0,0 +1,50 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Servicedowntime extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'downtime_author',
+            'downtime_author_name',
+            'downtime_comment',
+            'downtime_duration',
+            'downtime_end',
+            'downtime_entry_time',
+            'downtime_internal_id',
+            'downtime_is_fixed',
+            'downtime_is_flexible',
+            'downtime_is_in_effect',
+            'downtime_name',
+            'downtime_scheduled_end',
+            'downtime_scheduled_start',
+            'downtime_start',
+            'host_display_name',
+            'host_name',
+            'object_type',
+            'service_description',
+            'service_display_name',
+            'service_host_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Servicegroup.php b/modules/monitoring/library/Monitoring/DataView/Servicegroup.php
new file mode 100644
index 0000000..9909a68
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Servicegroup.php
@@ -0,0 +1,31 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Servicegroup extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'servicegroup_alias',
+            'servicegroup_name'
+        );
+    }
+
+    public function getSortRules()
+    {
+        return array(
+            'servicegroup_alias' => array(
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name', 'host_name', 'hostgroup_name', 'service_description'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Servicegroupsummary.php b/modules/monitoring/library/Monitoring/DataView/Servicegroupsummary.php
new file mode 100644
index 0000000..9dc3ee0
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Servicegroupsummary.php
@@ -0,0 +1,75 @@
+<?php
+/* Icinga Web 2 | (c) 2015 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Data view for service group summaries
+ */
+class Servicegroupsummary extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'servicegroup_alias',
+            'servicegroup_name',
+            'services_critical_handled',
+            'services_critical_unhandled',
+            'services_ok',
+            'services_pending',
+            'services_severity',
+            'services_total',
+            'services_unknown_handled',
+            'services_unknown_unhandled',
+            'services_warning_handled',
+            'services_warning_unhandled'
+        );
+    }
+
+    public function getSearchColumns()
+    {
+        return array('servicegroup', 'servicegroup_alias');
+    }
+
+    public function getSortRules()
+    {
+        return array(
+            'servicegroup_alias' => array(
+                'order' => self::SORT_ASC
+            ),
+            'services_severity' => array(
+                'columns' => array(
+                    'services_severity',
+                    'servicegroup_alias ASC'
+                ),
+                'order' => self::SORT_DESC
+            )
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'services_severity',
+            'host_contact', 'host_contactgroup', 'host_name',
+            'hostgroup_name',
+            'service_contact', 'service_contactgroup', 'service_description',
+            'servicegroup'
+        );
+    }
+
+    public function getFilterColumns()
+    {
+        if ($this->filterColumns === null) {
+            $filterColumns = parent::getFilterColumns();
+            $diff = array_diff($filterColumns, $this->getColumns());
+            $this->filterColumns = array_merge($diff, [
+                'Servicegroup Name'    => 'servicegroup_name',
+                'Servicegroup Alias'   => 'servicegroup_alias'
+            ]);
+        }
+
+        return $this->filterColumns;
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Servicestatus.php b/modules/monitoring/library/Monitoring/DataView/Servicestatus.php
new file mode 100644
index 0000000..e80c6f0
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Servicestatus.php
@@ -0,0 +1,180 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class ServiceStatus extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array_merge($this->getHookedColumns(), array(
+            'host_acknowledged',
+            'host_action_url',
+            'host_active_checks_enabled',
+            'host_address',
+            'host_address6',
+            'host_alias',
+            'host_check_source',
+            'host_display_name',
+            'host_handled',
+            'host_hard_state',
+            'host_in_downtime',
+            'host_ipv4',
+            'host_is_flapping',
+            'host_last_check',
+            'host_last_hard_state',
+            'host_last_hard_state_change',
+            'host_last_state_change',
+            'host_last_time_down',
+            'host_last_time_unreachable',
+            'host_last_time_up',
+            'host_long_output',
+            'host_modified_host_attributes',
+            'host_name',
+            'host_notes_url',
+            'host_notifications_enabled',
+            'host_output',
+            'host_passive_checks_enabled',
+            'host_perfdata',
+            'host_problem',
+            'host_severity',
+            'host_state',
+            'host_state_type',
+            'host_unhandled_service_count',
+            'instance_name',
+            'service_acknowledged',
+            'service_acknowledgement_type',
+            'service_action_url',
+            'service_active_checks_enabled',
+            'service_active_checks_enabled_changed',
+            'service_attempt',
+            'service_check_command',
+            'service_check_source',
+            'service_check_timeperiod',
+            'service_current_check_attempt',
+            'service_current_notification_number',
+            'service_description',
+            'service_display_name',
+            'service_event_handler_enabled',
+            'service_event_handler_enabled_changed',
+            'service_flap_detection_enabled',
+            'service_flap_detection_enabled_changed',
+            'service_handled',
+            'service_hard_state',
+            'service_host_name',
+            'service_in_downtime',
+            'service_is_flapping',
+            'service_is_reachable',
+            'service_last_check',
+            'service_last_hard_state',
+            'service_last_hard_state_change',
+            'service_last_notification',
+            'service_last_state_change',
+            'service_last_state_change_ts',
+            'service_last_time_critical',
+            'service_last_time_ok',
+            'service_last_time_unknown',
+            'service_last_time_warning',
+            'service_long_output',
+            'service_max_check_attempts',
+            'service_modified_service_attributes',
+            'service_next_check',
+            'service_notes',
+            'service_notes_url',
+            'service_notifications_enabled',
+            'service_notifications_enabled_changed',
+            'service_obsessing',
+            'service_obsessing_changed',
+            'service_output',
+            'service_passive_checks_enabled',
+            'service_passive_checks_enabled_changed',
+            'service_perfdata',
+            'service_problem',
+            'service_severity',
+            'service_state',
+            'service_state_type',
+            'service_unhandled'
+        ));
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'service_display_name' => array(
+                'order' => self::SORT_ASC
+            ),
+            'service_severity' => array(
+                'columns' => array(
+                    'service_severity',
+                    'service_last_state_change_ts DESC'
+                ),
+                'order' => self::SORT_DESC
+            ),
+            'service_last_state_change' => array(
+                'columns' => array(
+                    'service_last_state_change_ts'
+                ),
+                'order' => self::SORT_DESC
+            ),
+            'host_severity' => array(
+                'columns' => array(
+                    'host_severity',
+                    'host_last_state_change DESC',
+                    'host_display_name ASC',
+                    'service_display_name ASC'
+                ),
+                'order' => self::SORT_DESC
+            ),
+            'host_display_name' => array(
+                'columns' => array(
+                    'host_display_name',
+                    'service_display_name'
+                ),
+                'order' => self::SORT_ASC
+            ),
+            'host_address' => array(
+                'columns' => array(
+                    'host_ipv4',
+                    'service_display_name'
+                ),
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'host',
+            'host_contact',
+            'host_contactgroup',
+            'hostgroup',
+            'hostgroup_alias',
+            'hostgroup_name',
+            'service',
+            'service_contact',
+            'service_contactgroup',
+            'service_host',
+            'servicegroup',
+            'servicegroup_alias',
+            'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('service', 'service_display_name');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Servicestatussummary.php b/modules/monitoring/library/Monitoring/DataView/Servicestatussummary.php
new file mode 100644
index 0000000..abd3593
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Servicestatussummary.php
@@ -0,0 +1,45 @@
+<?php
+/* Icinga Web 2 | (c) 2015 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Data view for service status summaries
+ */
+class Servicestatussummary extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'services_critical',
+            'services_critical_handled',
+            'services_critical_unhandled',
+            'services_ok',
+            'services_pending',
+            'services_total',
+            'services_unknown',
+            'services_unknown_handled',
+            'services_unknown_unhandled',
+            'services_warning',
+            'services_warning_handled',
+            'services_warning_unhandled'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'host', 'host_alias', 'host_display_name', 'host_name',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Statechangeevent.php b/modules/monitoring/library/Monitoring/DataView/Statechangeevent.php
new file mode 100644
index 0000000..0b01aff
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Statechangeevent.php
@@ -0,0 +1,32 @@
+<?php
+/* Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class Statechangeevent extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'statechangeevent_id',
+            'statechangeevent_state_time',
+            'statechangeevent_state_change',
+            'statechangeevent_state',
+            'statechangeevent_state_type',
+            'statechangeevent_current_check_attempt',
+            'statechangeevent_max_check_attempts',
+            'statechangeevent_last_state',
+            'statechangeevent_last_hard_state',
+            'statechangeevent_output',
+            'statechangeevent_long_output',
+            'statechangeevent_check_source',
+            'host_name',
+            'service_description'
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array('statechangeevent_id');
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Statussummary.php b/modules/monitoring/library/Monitoring/DataView/Statussummary.php
new file mode 100644
index 0000000..36efccb
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Statussummary.php
@@ -0,0 +1,111 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+class StatusSummary extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'hosts_up',
+            'hosts_up_not_checked',
+            'hosts_pending',
+            'hosts_pending_not_checked',
+            'hosts_down',
+            'hosts_down_handled',
+            'hosts_down_unhandled',
+            'hosts_down_passive',
+            'hosts_down_not_checked',
+            'hosts_unreachable',
+            'hosts_unreachable_handled',
+            'hosts_unreachable_unhandled',
+            'hosts_unreachable_passive',
+            'hosts_unreachable_not_checked',
+            'hosts_active',
+            'hosts_passive',
+            'hosts_not_checked',
+            'hosts_not_processing_event_handlers',
+            'hosts_not_triggering_notifications',
+            'hosts_without_flap_detection',
+            'hosts_flapping',
+            'services_ok',
+            'services_ok_not_checked',
+            'services_pending',
+            'services_pending_not_checked',
+            'services_warning',
+            'services_warning_handled',
+            'services_warning_unhandled',
+            'services_warning_passive',
+            'services_warning_not_checked',
+            'services_critical',
+            'services_critical_handled',
+            'services_critical_unhandled',
+            'services_critical_passive',
+            'services_critical_not_checked',
+            'services_unknown',
+            'services_unknown_handled',
+            'services_unknown_unhandled',
+            'services_unknown_passive',
+            'services_unknown_not_checked',
+            'services_active',
+            'services_passive',
+            'services_not_checked',
+            'services_not_processing_event_handlers',
+            'services_not_triggering_notifications',
+            'services_without_flap_detection',
+            'services_flapping',
+
+
+            'services_ok_on_ok_hosts',
+            'services_ok_not_checked_on_ok_hosts',
+            'services_pending_on_ok_hosts',
+            'services_pending_not_checked_on_ok_hosts',
+            'services_warning_handled_on_ok_hosts',
+            'services_warning_unhandled_on_ok_hosts',
+            'services_warning_passive_on_ok_hosts',
+            'services_warning_not_checked_on_ok_hosts',
+            'services_critical_handled_on_ok_hosts',
+            'services_critical_unhandled_on_ok_hosts',
+            'services_critical_passive_on_ok_hosts',
+            'services_critical_not_checked_on_ok_hosts',
+            'services_unknown_handled_on_ok_hosts',
+            'services_unknown_unhandled_on_ok_hosts',
+            'services_unknown_passive_on_ok_hosts',
+            'services_unknown_not_checked_on_ok_hosts',
+            'services_ok_on_problem_hosts',
+            'services_ok_not_checked_on_problem_hosts',
+            'services_pending_on_problem_hosts',
+            'services_pending_not_checked_on_problem_hosts',
+            'services_warning_handled_on_problem_hosts',
+            'services_warning_unhandled_on_problem_hosts',
+            'services_warning_passive_on_problem_hosts',
+            'services_warning_not_checked_on_problem_hosts',
+            'services_critical_handled_on_problem_hosts',
+            'services_critical_unhandled_on_problem_hosts',
+            'services_critical_passive_on_problem_hosts',
+            'services_critical_not_checked_on_problem_hosts',
+            'services_unknown_handled_on_problem_hosts',
+            'services_unknown_unhandled_on_problem_hosts',
+            'services_unknown_passive_on_problem_hosts',
+            'services_unknown_not_checked_on_problem_hosts'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'host', 'host_alias', 'host_display_name', 'host_name',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Unhandledhostproblems.php b/modules/monitoring/library/Monitoring/DataView/Unhandledhostproblems.php
new file mode 100644
index 0000000..4f5f392
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Unhandledhostproblems.php
@@ -0,0 +1,28 @@
+<?php
+/* Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Data view for unhandled host problems
+ */
+class Unhandledhostproblems extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'hosts_down_unhandled'
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'host', 'host_alias', 'host_display_name', 'host_name',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}
diff --git a/modules/monitoring/library/Monitoring/DataView/Unhandledserviceproblems.php b/modules/monitoring/library/Monitoring/DataView/Unhandledserviceproblems.php
new file mode 100644
index 0000000..3af4502
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Unhandledserviceproblems.php
@@ -0,0 +1,28 @@
+<?php
+/* Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Data view for unhandled service problems
+ */
+class Unhandledserviceproblems extends DataView
+{
+    public function getColumns()
+    {
+        return array(
+            'services_critical_unhandled'
+        );
+    }
+
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'instance_name',
+            'host', 'host_alias', 'host_display_name', 'host_name',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'service', 'service_description', 'service_display_name',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+}