Add brackets in "if":
if ( ifType->value == 1 && ifType->value == 1 ) return %(true,$1,ifName->value);
if ( ifType->value == 1 && ifType->value == 1 ) return %(true,$1,ifName->value);
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts MenuSELECT s.name FROM (
SELECT
substr(t.table_name,7) AS id,
t.table_name AS name
FROM information_schema.tables t
WHERE
t.table_schema='mtest'
AND t.table_name LIKE 'idata_%') AS s
WHERE s.id NOT IN (
SELECT id FROM nodes
UNION SELECT id FROM clusters
UNION SELECT id FROM access_points
UNION SELECT id FROM sensors
UNION SELECT id FROM mobile_devices
);
SELECT s.id,s.name FROM (SELECT substr(t.table_name,7) AS id, t.table_name AS name FROM information_schema.tables t WHERE t.table_schema='mtest' AND t.table_name LIKE 'idata_%') AS s WHERE s.id NOT IN (SELECT id FROM nodes UNION SELECT id FROM clusters);
Quote from: MarcusH on October 07, 2019, 08:54:23 AM
Thanks for clearing that one up, if it is by design i'll try to stick with it and i kind of got a liking for changing interfaces via object details now![]()
Quote from: vir_db on September 12, 2019, 12:34:03 PM
Thanks Viktor,
just another issue: seems that the upgrade brok the grafana plugin. I can get alerts, but I cannot collect any graphs (for ex. CPU Usage)