Refine your search:

When searching for lost forwarders a host with an all caps name is returned as lost when the same host with a lower case name is reporting. Not certain how host names are being changed, but is there a way to make the search insensitive to case for the host name?

Indexer is 4.1.2 and forwarders (lightweight) are 4.0.9 and 4.0.10.

| metadata type=hosts | tags | rename tag::host as tags |eval age = Round((now() - lastTime)/86400)| search age > 1 age < 60 host=srv* NOT tags=offline | sort age d | convert ctime(lastTime) | fields host,age,lastTime,tags

asked 13 May '10, 16:44

rgcox1's gravatar image

rgcox1
912113
accept rate: 66%


2 Answers:

Travis's answer is one part of the solution. In addition to "eval host=lower(host)" a pipe to "stats max(lastTime) as ltime by host" had to be added.

| metadata type=hosts | tags | rename tag::host as tags|eval host=lower(host) |stats max(lastTime) as ltime by host|eval age = Round((now() - ltime)/86400)| search age > 1 age < 60 host=srv* NOT tags=offline | sort age d | fields host,age
link

answered 26 May '10, 15:44

rgcox1's gravatar image

rgcox1
912113
accept rate: 66%

Adding | eval host= lower(host) would cause all the host names to be lower case in your search string. Would that help?

| metadata type=hosts | eval host= lower(host) | tags | rename tag::host as tags |eval age = Round((now() - lastTime)/86400)| search age > 1 age < 60 host=srv* NOT tags=offline | sort age d | convert ctime(lastTime) | fields host,age,lastTime,tags

Travis.

link

answered 13 May '10, 17:40

thall79's gravatar image

thall79
47626
accept rate: 27%

No. The metadata record with the older lasttime still exists, so is still reported.

(13 May '10, 19:26) rgcox1
Post your answer
toggle preview

Follow this question

Log In to enable email subscriptions

RSS:

Answers

Answers + Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×14

Asked: 13 May '10, 16:44

Seen: 744 times

Last updated: 26 May '10, 15:44

Copyright © 2005-2012 Splunk Inc. All rights reserved.