• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

This Probably Isn't Technically Possible But will Ask Anyway (Excel Macro 2010, VBSCRPT - Pulling Patterns)

Hey there Experts!

     I'm curious if a macro, add-in or third party type software can be invoked in a spreadsheet that will detect time patterns.  

For example, I'm looking at IP's, there are date time stamps associated with each IP .  My pivot table is broken down by IP address and under that the dates and times.  What I"m looking for is patterns....

Let's say under IP 1.1.1.1 I have a date/time stamp of 08/24/2012 13:52 and then 3 minutres later another 13:55 and 3 minutes later 13:58 and then 2 minutes later 13:60 and then it repeats...trying to target behavior like that.  Is there anything remotely out there that can assist me in identifying this behavior or is the human eye going to be the only work-around in this scenerio?

Example of my Pivot Table data:

0.0.0.0 <--IP Address
8/24/2012 13:52  <---Dates and Tims
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:57
8/24/2012 13:58
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 14:00
8/24/2012 14:00
8/24/2012 14:00
1.1.1.1
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
0
itsmevic
Asked:
itsmevic
  • 2
3 Solutions
 
PaulHendCommented:
Yes! I would save the file to a text document and then run this:
for i in $(find|grep .txt); do grep "search" "$i";
0
 
Elton PascuaCommented:
I guess a start would be to identify the patterns you're looking for and then code to satisfy the patterns.

As you know, software programs we write make decisions based on algorithms. Can you classify what you're looking for like:

1. X logged per minute.
2. X logged per 24 hours.
3. X logged per 15 minute intervals. etc etc
4. X logged per week
0
 
PaulHendCommented:
I know that what was said was confusing, but I would recommend exporting the data to a text document and then running a simple script to extract the relevant data that you need to see.  The plain text document is very playable and will allow you to have more of a free access to the information that trying to do it via a macros in Excel.

Can you get access to a Linux machine?  I ask because a lot of what you'd need to extract this data is native on a Linux distribution.

-PaulHend
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now