AutoM8 Question - Picking up Switch Interfaces it should not be

[cksrealm]

Hi all,
I have an autom8 rule (Graph Rule) to match any device containing a certain text in the hostname which works great, the next part of it matches to see if the current Interface status is Up/Up as well as some text in the interface description (aka ifAlias). This is done with the attached rule set.

Screenshot 2023-08-14 132507.jpg (43.53 KiB) Viewed 1896 times

However when I run it its picking up interface that are Up/Down. Any idea what I have done wrong here.

Screenshot 2023-08-14 132507.jpg (43.53 KiB) Viewed 1896 times

[Osiris]

You really need to add parenthesis around the or's. Otherwise the logic is wrong

[cksrealm]

Have tried that and then I get no matches at all.

[Osiris]

Show me what it looks like when you tried

[cksrealm]

See below.

Screenshot 2023-08-16 102513.jpg (159.67 KiB) Viewed 1693 times

[Osiris]

The first guy inside the bracket should not have an AND.

[cksrealm]

Tried that and still getting no matches at all?

[Osiris]

Show that screen capture?

[cksrealm]

Screenshot 2023-08-17 092426.jpg (103.27 KiB) Viewed 1643 times

[Osiris]

Approximately line 858 in lib/api_automation.php there is a SQL statement, add a cacti_log($row_query); of that statement and the go the sthe rule page. It should post the SQL. Grab it from the cacti.log and post it.

[cksrealm]

This section?
$rule_name = db_fetch_cell_prepared('SELECT name
FROM automation_graph_rules
WHERE id = ?',
array($rule['id']));

[TheWitness]

Right here, I actually added it for you.

[TheWitness]

I dropped this feature request in on your behalf:

https://github.com/Cacti/cacti/issues/5463

[cksrealm]

Got this in the logs.
2023-08-21 11:57:57 - CMDPHP SELECT * FROM (SELECT h.hostname AS automation_host, host_id, h.disabled, h.status, snmp_query_id, snmp_index , MAX(CASE WHEN field_name='ifAdminStatus' THEN field_value ELSE NULL END) AS 'ifAdminStatus', MAX(CASE WHEN field_name='ifAlias' THEN field_value ELSE NULL END) AS 'ifAlias', MAX(CASE WHEN field_name='ifDescr' THEN field_value ELSE NULL END) AS 'ifDescr', MAX(CASE WHEN field_name='ifHighSpeed' THEN field_value ELSE NULL END) AS 'ifHighSpeed', MAX(CASE WHEN field_name='ifHwAddr' THEN field_value ELSE NULL END) AS 'ifHwAddr', MAX(CASE WHEN field_name='ifIndex' THEN field_value ELSE NULL END) AS 'ifIndex', MAX(CASE WHEN field_name='ifIP' THEN field_value ELSE NULL END) AS 'ifIP', MAX(CASE WHEN field_name='ifName' THEN field_value ELSE NULL END) AS 'ifName', MAX(CASE WHEN field_name='ifOperStatus' THEN field_value ELSE NULL END) AS 'ifOperStatus', MAX(CASE WHEN field_name='ifSpeed' THEN field_value ELSE NULL END) AS 'ifSpeed', MAX(CASE WHEN field_name='ifType' THEN field_value ELSE NULL END) AS 'ifType' FROM host_snmp_cache AS hsc LEFT JOIN host AS h ON (hsc.host_id=h.id) LEFT JOIN host_template AS ht ON (h.host_template_id=ht.id) WHERE snmp_query_id=4 AND ( `h`.`description` LIKE '%c93%' OR `h`.`description` LIKE '%c38%' OR `h`.`description` LIKE '%c29%') GROUP BY host_id, snmp_query_id, snmp_index ORDER BY automation_host, CAST(snmp_index AS unsigned)) AS a WHERE ( a.`ifOperStatus` LIKE '%Up%' AND a.`ifAdminStatus` LIKE '%Up%' ( AND a.`ifAlias` LIKE '%//%' OR a.`ifAlias` LIKE '%Wireless%' OR a.`ifName` LIKE '%Stack%' ))

[TheWitness]

What does that query return? It looks kind of right.