Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Tue May 23, 2017 1:45 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Advanced search
PostPosted: Thu May 11, 2006 4:19 pm 
Offline
User avatar

Joined: Sun Apr 09, 2006 4:16 pm
Posts: 41
Location: Spain
Hi,

It would be great if we could do an advanced search when searching for devices or graphs. That is, now we can only search one string: "switch 1", or "win server", or "router"; it would be useful if we could search:

"procurve" OR "catalyst" => result= all procurve and catalyst switches
"site A" AND "switch" ==> result= switches installed in site A
"site A" AND NOT "catalyst" ==> result= switchs in site A, but not catalyst

I hope I have explained properly :-)

Regards,

Cesar


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 14, 2006 7:11 am 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22461
Location: Muenster, Germany
You may use "SQL wildcards" and other SQL query stuff within the search field. Wildcards are working, I'm using them often. Other operators should work, but I didn't check yet
Reinhard

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 14, 2006 11:22 am 
Offline
Developer/Forum Admin
User avatar

Joined: Mon Nov 17, 2003 6:35 pm
Posts: 5945
Location: Michigan, USA
Because of string quoting, I don't think other operators will work.

_________________
Tony Roman
Experience is what causes a person to make new mistakes instead of old ones.
There are only 3 way to complete a project: Good, Fast or Cheap, pick two.
With age comes wisdom, what you choose to do with it determines whether or not you are wise.


Top
 Profile  
 
 Post subject:
PostPosted: Sun May 14, 2006 11:38 am 
Offline
User avatar

Joined: Sun Apr 09, 2006 4:16 pm
Posts: 41
Location: Spain
Thanks a lot! It works great....


lvm wrote:
You may use "SQL wildcards" and other SQL query stuff within the search field. Wildcards are working, I'm using them often. Other operators should work, but I didn't check yet
Reinhard


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 28, 2007 2:49 am 
Offline

Joined: Sun May 27, 2007 7:06 am
Posts: 11
What is exactly the solution to make multiple search (with AND, OR)?
Give me an example for a query please. Because I intended with "AND", "&" "%" and other and nothing work.

Thanks for your reply


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 29, 2007 2:17 pm 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22461
Location: Muenster, Germany
AND, OR are not supported. Cacti performs a LIKE operation, not a REGEXP operation. So wildcards only are supported (see http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like)
% matches several characters
_ matches a single character
You may combine multiple wildcarding sequences, e.g.
host%- traf% bandwid%
Reinhard

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: filtering base on sub-tree
PostPosted: Thu Aug 02, 2007 10:16 pm 
Offline

Joined: Mon Jul 02, 2007 8:19 pm
Posts: 6
I just noticed that the filter by host is so limited. Could it be editted to filter by sub-tree in the preview mode?

NMS Devices
|____ nms1
|____ nms2
Wan Routers
|____ router1
|____ router2

If i check it in the preview mode, it only has filtering by host. I'm really not good in php.I want to see all the graphs under the Wan Router Tree. Pls. someone check it out if its possible to filter by sub-tree.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 03, 2007 8:50 am 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22461
Location: Muenster, Germany
This is not possible ATM.
Reinhard

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: Re: Advanced search
PostPosted: Sat May 13, 2017 10:47 am 
Offline

Joined: Sun Mar 06, 2016 3:22 pm
Posts: 5
In version 1.1.5 it does not work.
% and _ does not return anything.
For example:
    Traffic%lagg
    %cpu%
    CPU_Temp

Part of graph names:
    ...Traffic - lagg0...
    ...- CPU Temp...


Top
 Profile  
 
 Post subject: Re: Advanced search
PostPosted: Mon May 15, 2017 12:50 am 
Offline
Cacti User
User avatar

Joined: Mon Jan 05, 2015 10:10 am
Posts: 289
1.1.5 supports regular expressions. So, you can do the following on the graphs page:

Quote:
(catalyst|cattlecar)


And both all matching items will show.

_________________
Before history, there was a paradise, now dust.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group