https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134699#M4119 <P>You could increase the window and use values() instead. Something like this:</P> <PRE><CODE>... | streamstats global=f window=5 list(documentId) as docids by user | where mvindex(docids,0)-mvindex(docids,1)=1 AND mvindex(docids,1)-mvindex(docids,2)=1 AND ... </CODE></PRE> Tue, 23 Sep 2014 13:01:33 GMT Ayn 2014-09-23T13:01:33Z https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134696#M4116 <P>Hi,</P> <P>I'm trying to discover if a public URL is being misused by analsying the access logs. Basically, the URL contains a base string and an ID number (integer). We would like to see if someone is trying to download more data than we would like by guessing the ID number. Something like this should trigger an alert:</P> <PRE><CODE>/content/documents/10241 /content/documents/10242 /content/documents/10243 /content/documents/10244 </CODE></PRE> <P>We know the user and the ID is extracted as a field called documentId</P> Mon, 22 Sep 2014 11:46:30 GMT https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134696#M4116 echalex 2014-09-22T11:46:30Z https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134697#M4117 <P>You could do this with streamstats.</P> <PRE><CODE>... | streamstats global=f window=2 latest(documentId) as nextdocid, earliest(documentid) as thisdocid by user | where nextdocid-thisdocid=1 </CODE></PRE> Mon, 22 Sep 2014 12:04:35 GMT https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134697#M4117 Ayn 2014-09-22T12:04:35Z https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134698#M4118 <P>Hi, yes that is an interesting idea. Thanks for that. The problem I see with that is it would only check for a sequence of two documentIds, which would give me what I think of as a false positive. I would like to detect it when someone is trying at least five or so URLs in a short period. Probably even more.</P> Tue, 23 Sep 2014 12:04:50 GMT https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134698#M4118 echalex 2014-09-23T12:04:50Z https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134699#M4119 <P>You could increase the window and use values() instead. Something like this:</P> <PRE><CODE>... | streamstats global=f window=5 list(documentId) as docids by user | where mvindex(docids,0)-mvindex(docids,1)=1 AND mvindex(docids,1)-mvindex(docids,2)=1 AND ... </CODE></PRE> Tue, 23 Sep 2014 13:01:33 GMT https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134699#M4119 Ayn 2014-09-23T13:01:33Z https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134700#M4120 <P>That actually seems like a good option. Thanks!</P> Tue, 23 Sep 2014 14:48:58 GMT https://community.splunk.com/t5/Security/Detect-events-with-sequential-values/m-p/134700#M4120 echalex 2014-09-23T14:48:58Z