Automation: Device Automation Template not working, as expected

[Rno]

Hello,
I try to define some Device Rules on Automation, and I can't make it work.
For this example I have a C2960 Switch, that suppose to match my rule:
Template Name is Cisco Switch:

2024-01-08 11_26_34-Clipboard.png (3.11 KiB) Viewed 5798 times

The query generated by the Automation_find_os is the following:

Code: Select all

SELECT at.*,ht.name
		FROM automation_templates AS at
		INNER JOIN host_template AS ht
		ON ht.id=at.host_template
		WHERE (sysDescr REGEXP "(Cisco IOS Software, C2960X Software \(C2960X\-UNIVERSALK9\-M\), Version 15\.2\(2\)E6, RELEASE SOFTWARE \(fc1\) Technical Support\: http\://www\.cisco\.com/techsupport Copyright \(c\) 1986\-2016 by Cisco Systems, Inc\. Compiled Fri 16\-Dec\-16 21\:27 by prod_rel_team)" OR 'Cisco IOS Software, C2960X Software (C2960X-UNIVERSALK9-M), Version 15.2(2)E6, RELEASE SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c) 1986-2016 by Cisco Systems, Inc. Compiled Fri 16-Dec-16 21:27 by prod_rel_team' LIKE CONCAT("%", sysDescr, "%")) AND (sysName REGEXP "(se\-ch9\-01)" OR 'se-ch9-01' LIKE CONCAT("%", sysName, "%"))

The result is NULL, but the automation_templates table content is:

2024-01-08 11_28_58-Clipboard.png (54.88 KiB) Viewed 5798 times

I'm running the latest dev of cacti 1.2.26.

So why I have nothing ?