<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Log file validation based on serverhost and source in Splunk Search</title>
    <link>https://community.splunk.com/t5/Splunk-Search/Log-file-validation-based-on-serverhost-and-source/m-p/690228#M235097</link>
    <description>&lt;P&gt;Hi Team,&lt;BR /&gt;For a business requirement, I need to validate log file generated for last an hour with combination of host and source in below order:&lt;/P&gt;&lt;TABLE border="1" width="96.52509652509653%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="50%"&gt;Host&amp;nbsp;&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;Source&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server001&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath1.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server002&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath2.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server003&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath3.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server004&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath4.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server005&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath5.txt&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I knew, inputlookup keyword is single column based; however, I need it two columns to check the log file. Can you please suggest what is the best to accomplish my requirement?&lt;/P&gt;&lt;P&gt;Thanks in advance!&lt;/P&gt;</description>
    <pubDate>Mon, 10 Jun 2024 12:20:01 GMT</pubDate>
    <dc:creator>ganeshkumarmoha</dc:creator>
    <dc:date>2024-06-10T12:20:01Z</dc:date>
    <item>
      <title>Log file validation based on serverhost and source</title>
      <link>https://community.splunk.com/t5/Splunk-Search/Log-file-validation-based-on-serverhost-and-source/m-p/690228#M235097</link>
      <description>&lt;P&gt;Hi Team,&lt;BR /&gt;For a business requirement, I need to validate log file generated for last an hour with combination of host and source in below order:&lt;/P&gt;&lt;TABLE border="1" width="96.52509652509653%"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="50%"&gt;Host&amp;nbsp;&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;Source&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server001&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath1.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server002&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath2.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server003&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath3.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server004&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath4.txt&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="50%"&gt;server005&lt;/TD&gt;&lt;TD width="46.52509652509652%"&gt;c\:...\logpath5.txt&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I knew, inputlookup keyword is single column based; however, I need it two columns to check the log file. Can you please suggest what is the best to accomplish my requirement?&lt;/P&gt;&lt;P&gt;Thanks in advance!&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 12:20:01 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/Log-file-validation-based-on-serverhost-and-source/m-p/690228#M235097</guid>
      <dc:creator>ganeshkumarmoha</dc:creator>
      <dc:date>2024-06-10T12:20:01Z</dc:date>
    </item>
    <item>
      <title>Re: Log file validation based on serverhost and source</title>
      <link>https://community.splunk.com/t5/Splunk-Search/Log-file-validation-based-on-serverhost-and-source/m-p/690229#M235098</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/265032"&gt;@ganeshkumarmoha&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I suppose that you need to check if you' received events from each host with that source, is it correct?&lt;/P&gt;&lt;P&gt;if this is your requirement and if the source column has a fixed part that you can use for checking (e.g. the file name without path), please tru something like this:&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;&amp;lt;your_search&amp;gt;
| rex field=source "\\(?&amp;lt;Source&amp;gt;logpath\d*.txt)$"
| rename host AS Host
| stats count BY host Source
| append [ | inputlookup your_lookup.csv | eval count=0 | fields Host Source count ]
| stats sum(count) AS total BY Host Source
| where total=0 &lt;/LI-CODE&gt;&lt;P&gt;Ciao.&lt;/P&gt;&lt;P&gt;Giuseppe&lt;/P&gt;</description>
      <pubDate>Mon, 10 Jun 2024 12:54:43 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/Log-file-validation-based-on-serverhost-and-source/m-p/690229#M235098</guid>
      <dc:creator>gcusello</dc:creator>
      <dc:date>2024-06-10T12:54:43Z</dc:date>
    </item>
    <item>
      <title>Re: Log file validation based on serverhost and source</title>
      <link>https://community.splunk.com/t5/Splunk-Search/Log-file-validation-based-on-serverhost-and-source/m-p/690604#M235193</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/265032"&gt;@ganeshkumarmoha&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;good for you, see next time!&lt;/P&gt;&lt;P&gt;Ciao and happy splunking&lt;/P&gt;&lt;P&gt;Giuseppe&lt;/P&gt;&lt;P&gt;P.S.: Karma Points are appreciated &lt;span class="lia-unicode-emoji" title=":winking_face:"&gt;😉&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 13 Jun 2024 11:41:59 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/Log-file-validation-based-on-serverhost-and-source/m-p/690604#M235193</guid>
      <dc:creator>gcusello</dc:creator>
      <dc:date>2024-06-13T11:41:59Z</dc:date>
    </item>
  </channel>
</rss>

