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

Data Pattern Software?

I have a spreadsheet that I have to review daily that consist of IP addresses and a timestamps.  I pivot table this data so I can see all the date/time values for each IP address  Then based off that I determine what might be a pattern.  For example, I've got a date time stamp that keeps reflecting outbound activity every 10 minutes.  Naturally, this would raise suspicion and need to be checked.  

I'm using 10 minutes as an example but it might even be something that happening every 5 minutes, then it takes a break and 15 minutes later it trys again every five minutes...I'm looking for patterns.  I'm curious if thier is an Add-In or software that can assist me with this because the worksheet becomes rather large. and sifting through it takes a lot of time.   Nothing replaces the human eye, however I think with something like this it would help greatly.
0
itsmevic
Asked:
itsmevic
  • 4
  • 2
1 Solution
 
RyanProject Engineer, ElectricalCommented:
Couldn't you just look at an average/count by IP address?

If you don't have a lot of IP addresses, you could graph activity as a histogram?  Series by IP, Y axis by count in a time frame, x axis by time frames.
0
 
itsmevicAuthor Commented:
testing this.
0
 
itsmevicAuthor Commented:
Histogram's do not like IP Addresses i.e. it doesn't like the dot.  Take the dot out and the report generates without issue.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
RyanProject Engineer, ElectricalCommented:
I'm confused. Does the histogram idea work or not?
Yes, you may have to massage the data a little bit, although I'm not sure what method you used, as Excel shouldn't care what format the labels(IP addresses) are in, but removing the dots doesn't invalid the method of the answer.
0
 
itsmevicAuthor Commented:
"Histogram's do not like IP Addresses."   It does not work.
0
 
itsmevicAuthor Commented:
Histogram will not work in this case because it's not accepting IP format
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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