<?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 Issue on using event types as constraints for Data model in Knowledge Management</title>
    <link>https://community.splunk.com/t5/Knowledge-Management/Issue-on-using-event-types-as-constraints-for-Data-model/m-p/690373#M10094</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I am working in a distributed environment with a SHC of 3 search heads and I am mapping vpn logs to fill certain datasets of my custom version of the Authentication data model (not accelerated for the moment).&lt;/P&gt;&lt;P&gt;The datasets I added to the default authentication Data Model are "&lt;SPAN&gt;Failed_Authentication&lt;/SPAN&gt;","&lt;SPAN&gt;Successful_Authentication" and "Login_Attempt", as you can see below:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="2024-06-11 18_55_22-Edit Objects_ Authentication _ Splunk 9.2.1.png" style="width: 215px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31267iAF92DA58B9800B8A/image-dimensions/215x391?v=v2" width="215" height="391" role="button" title="2024-06-11 18_55_22-Edit Objects_ Authentication _ Splunk 9.2.1.png" alt="2024-06-11 18_55_22-Edit Objects_ Authentication _ Splunk 9.2.1.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Then, I created an eventtype (with some associated tags) to match specific conditions for an authentication success, as shown below:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1eventtype.png" style="width: 932px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31268i1A8B6059E73A4811/image-dimensions/932x101?v=v2" width="932" height="101" role="button" title="1eventtype.png" alt="1eventtype.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;sourcetype=XX action=success signature IN ("Agent login","Login","Secondary authentication","Primary authentication") OR (signature="Session" AND action="success")&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Then, I used the Eventtype as a constraint for the dataset "Authentication.&lt;SPAN&gt;Successful_Authentication&lt;/SPAN&gt;" as shown below:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31269iDDB9B89A36A35220/image-size/medium?v=v2&amp;amp;px=400" role="button" title="5.png" alt="5.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;To test if the constraint is working or not:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;I used the pivoting button offered by the GUI and it returns me some results!&lt;/LI&gt;&lt;LI&gt;I run in the search app the following SPL and it also returns some results:&amp;nbsp;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;index=vpn* tag=authentication eventtype=auth_vpn_success​&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;However, if I try to retrieve the same information by using the following SPL (by using tstat), it returns no results:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt; |tstats summariesonly=f count from datamodel=Authentication where nodename=Authentication.Successful_Authentication&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Even by running another SPL(based on tstat) to retrieve the eventtypes of the Authentication Data Model it returns no results:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;| tstats count from datamodel=Authentication  by eventtype&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I tried to troubleshoot the issue with 2 different tests:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Not using the field eventtypes as Dataset constraint.&amp;nbsp;&lt;/LI&gt;&lt;LI&gt;Creating another eventtype and using a different Data Model (Change).&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;1) I created a dataset constraint for "Authentication.&lt;SPAN&gt;Failed_Authentication" which is not using either tag or eventtypes, as follow:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="4-2auth-failureconstaint_dataset.png" style="width: 807px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31270iE2960FBEF5B5247D/image-dimensions/807x228?v=v2" width="807" height="228" role="button" title="4-2auth-failureconstaint_dataset.png" alt="4-2auth-failureconstaint_dataset.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;action=failure&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;And both of the aforementioned tstats SPLs are working now!&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;2) I created another eventtype related to a change log type, as follow:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="7.png" style="width: 833px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31271i5E246479A87A0145/image-dimensions/833x100?v=v2" width="833" height="100" role="button" title="7.png" alt="7.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;index=vpn* sourcetype=XX AND "User Accounts modified."&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And I added it as a constraint&amp;nbsp; for the dataset "&lt;SPAN&gt;All_Changes.&lt;/SPAN&gt;&lt;SPAN&gt;Account_Change" :&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31272i703D26684CC2B35C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="8.png" alt="8.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;And by running the 2 aforementioned tstat SPLs&amp;nbsp; they return me some results!&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In conclusion, I suspect there is an issue related to either the tag=authentication (maybe some conflict with other default apps?) or the Authentication Data Model (related to custom datasets I added?).&lt;/P&gt;&lt;P&gt;Do you have any clue of what I could have done wrong ?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Kind Regard,&lt;/P&gt;&lt;P&gt;Z&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 11 Jun 2024 17:50:38 GMT</pubDate>
    <dc:creator>Zanusha443</dc:creator>
    <dc:date>2024-06-11T17:50:38Z</dc:date>
    <item>
      <title>Issue on using event types as constraints for Data model</title>
      <link>https://community.splunk.com/t5/Knowledge-Management/Issue-on-using-event-types-as-constraints-for-Data-model/m-p/690373#M10094</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I am working in a distributed environment with a SHC of 3 search heads and I am mapping vpn logs to fill certain datasets of my custom version of the Authentication data model (not accelerated for the moment).&lt;/P&gt;&lt;P&gt;The datasets I added to the default authentication Data Model are "&lt;SPAN&gt;Failed_Authentication&lt;/SPAN&gt;","&lt;SPAN&gt;Successful_Authentication" and "Login_Attempt", as you can see below:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="2024-06-11 18_55_22-Edit Objects_ Authentication _ Splunk 9.2.1.png" style="width: 215px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31267iAF92DA58B9800B8A/image-dimensions/215x391?v=v2" width="215" height="391" role="button" title="2024-06-11 18_55_22-Edit Objects_ Authentication _ Splunk 9.2.1.png" alt="2024-06-11 18_55_22-Edit Objects_ Authentication _ Splunk 9.2.1.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Then, I created an eventtype (with some associated tags) to match specific conditions for an authentication success, as shown below:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1eventtype.png" style="width: 932px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31268i1A8B6059E73A4811/image-dimensions/932x101?v=v2" width="932" height="101" role="button" title="1eventtype.png" alt="1eventtype.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;sourcetype=XX action=success signature IN ("Agent login","Login","Secondary authentication","Primary authentication") OR (signature="Session" AND action="success")&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Then, I used the Eventtype as a constraint for the dataset "Authentication.&lt;SPAN&gt;Successful_Authentication&lt;/SPAN&gt;" as shown below:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="5.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31269iDDB9B89A36A35220/image-size/medium?v=v2&amp;amp;px=400" role="button" title="5.png" alt="5.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;To test if the constraint is working or not:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;I used the pivoting button offered by the GUI and it returns me some results!&lt;/LI&gt;&lt;LI&gt;I run in the search app the following SPL and it also returns some results:&amp;nbsp;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;index=vpn* tag=authentication eventtype=auth_vpn_success​&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;However, if I try to retrieve the same information by using the following SPL (by using tstat), it returns no results:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt; |tstats summariesonly=f count from datamodel=Authentication where nodename=Authentication.Successful_Authentication&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Even by running another SPL(based on tstat) to retrieve the eventtypes of the Authentication Data Model it returns no results:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;| tstats count from datamodel=Authentication  by eventtype&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I tried to troubleshoot the issue with 2 different tests:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Not using the field eventtypes as Dataset constraint.&amp;nbsp;&lt;/LI&gt;&lt;LI&gt;Creating another eventtype and using a different Data Model (Change).&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;1) I created a dataset constraint for "Authentication.&lt;SPAN&gt;Failed_Authentication" which is not using either tag or eventtypes, as follow:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="4-2auth-failureconstaint_dataset.png" style="width: 807px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31270iE2960FBEF5B5247D/image-dimensions/807x228?v=v2" width="807" height="228" role="button" title="4-2auth-failureconstaint_dataset.png" alt="4-2auth-failureconstaint_dataset.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;action=failure&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;And both of the aforementioned tstats SPLs are working now!&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;2) I created another eventtype related to a change log type, as follow:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="7.png" style="width: 833px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31271i5E246479A87A0145/image-dimensions/833x100?v=v2" width="833" height="100" role="button" title="7.png" alt="7.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;index=vpn* sourcetype=XX AND "User Accounts modified."&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And I added it as a constraint&amp;nbsp; for the dataset "&lt;SPAN&gt;All_Changes.&lt;/SPAN&gt;&lt;SPAN&gt;Account_Change" :&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/31272i703D26684CC2B35C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="8.png" alt="8.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;And by running the 2 aforementioned tstat SPLs&amp;nbsp; they return me some results!&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In conclusion, I suspect there is an issue related to either the tag=authentication (maybe some conflict with other default apps?) or the Authentication Data Model (related to custom datasets I added?).&lt;/P&gt;&lt;P&gt;Do you have any clue of what I could have done wrong ?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Kind Regard,&lt;/P&gt;&lt;P&gt;Z&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 11 Jun 2024 17:50:38 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Knowledge-Management/Issue-on-using-event-types-as-constraints-for-Data-model/m-p/690373#M10094</guid>
      <dc:creator>Zanusha443</dc:creator>
      <dc:date>2024-06-11T17:50:38Z</dc:date>
    </item>
  </channel>
</rss>

