diff options
Diffstat (limited to 'frontends/php/include/items.inc.php')
| -rw-r--r-- | frontends/php/include/items.inc.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/frontends/php/include/items.inc.php b/frontends/php/include/items.inc.php index e56eda39..45233964 100644 --- a/frontends/php/include/items.inc.php +++ b/frontends/php/include/items.inc.php @@ -889,6 +889,7 @@ function get_items_data_overview($groupid,$view_style=null) { global $USER_DETAILS; + $available_hosts = get_accessible_hosts_by_user($USER_DETAILS,PERM_READ_ONLY, null, null, get_current_nodeid()); if(is_null($view_style)) $view_style = get_profile('web.overview.view.style',STYLE_TOP); @@ -906,7 +907,7 @@ COpt::profiling_start('prepare data'); ' i.description, t.priority, i.valuemapid, t.value as tr_value, t.triggerid '. ' from hosts h,items i left join functions f on f.itemid=i.itemid left join triggers t on t.triggerid=f.triggerid '. $group_where. - ' h.hostid in ('.get_accessible_hosts_by_user($USER_DETAILS,PERM_READ_ONLY, null, null, get_current_nodeid()).') '. + ' h.hostid in ('.$available_hosts.') '. ' and h.status='.HOST_STATUS_MONITORED.' and h.hostid=i.hostid and i.status='.ITEM_STATUS_ACTIVE. ' order by i.description,i.itemid'); |