How can I get diffrence time of 2 ip address?

diamond diamond

Hi all,

I have a table with 3 column(source ipaddress, destination ipaddress, start time), which every source ipaddress assign many record of every destination like below.

source ip         destination ip       stime
0.0.0.2             0.0.0.4               5
0.0.0.1             0.0.0.3                4
0.0.0.2             0.0.0.4               7
0.0.0.2             0.0.0.4                10
0.0.0.2              0.0.0.3              4

I want to get diffrence of stime between 2 ip addresses like 0.0.0.2 and 0.0.0.4. I must compute diffrence stime of first and second record of these ip adresses like : (7-5) and second record with third (10-7).

Let me know how can I do?

I should do for every source ip address with destination ip addresses.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
OK, try this revised version of the program. The data is, of course, just for testing:

using System;
using System.Data;
using System.Linq;
using System.IO;

class Program
{
static void Main()
{
DataTable dt = new DataTable();
dt.Columns.Add("source ip");
dt.Columns.Add("destination ip");
dt.Columns.Add("stime", typeof(int));
dt.Rows.Add("0.0.0.2", "0.0.0.4", 5);
dt.Rows.Add("0.0.0.1", "0.0.0.3", 4);
dt.Rows.Add("0.0.0.2", "0.0.0.4", 7);
dt.Rows.Add("0.0.0.2", "0.0.0.4", 10);
dt.Rows.Add("0.0.0.2", "0.0.0.3", 4);
dt.Rows.Add("0.0.0.2", "0.0.0.3", 9);
dt.Rows.Add("0.0.0.2", "0.0.0.3", 11);

var query = from DataRow dr in dt.Rows
let source = dr["source ip"].ToString()
let dest = dr["destination ip"].ToString()
group dr by new {source, dest} into g
select g;

using (StreamWriter sw = new StreamWriter("diamond.txt"))
{
foreach(var g in query)
{
if(g.Count() > 1)
{
sw.Write(String.Format("{0,-15} {1,-15} ", g.Key.source, g.Key.dest));
int time1 = Convert.ToInt32(g.ElementAt(0)["stime"]);
int time2;

for(int i = 1; i < g.Count(); i++)
{
time2 = Convert.ToInt32(g.ElementAt(i)["stime"]);
if (i > 1) sw.Write(new string(' ', 34));
sw.WriteLine(String.Format("{0}", time2 - time1));
time1 = time2;
}
}
}
}
}
}

The file should contain the following:

0.0.0.2 0.0.0.4 2
3
0.0.0.2 0.0.0.3 5
2
0
diamond diamond12y ago
Thankssss Vulpes.

you are same as an angel
0
diamond diamond12y ago
Hi Vulpes,

I want save in an txt file like below:

source ip destination ip difference

0.0.0.2     0.0.0.4            2
                                    5

0.0.0.2     0.0.0.30         10
                                   5
                                   6

,

....

I need urgently, if you have an idea, please share with me.

Thanks
0
Vulpes12y ago
Can you give me an example of how you'd like the output file to look.
0
diamond diamond12y ago
Thanks Vulpes,
I should say that my data is very large, and the above data is an example. I want similar records of 2 ip addresses get save in lists, then automatic is computed difference of stimes and save in txt file for all ip addresses. for example records of 2 ip adresses are 12 records and I have compute their difference stimes

Thanks in advance,
0
diamond diamond12y ago
Thanks so much Vulpes, every time I 'm in trouble you help me.

Let me test it, and if I had a question, I ask you.

Thankssss again
0
Vulpes12y ago
It sounds like you need to group the records by source and destination ip, maintaining the same order as you do so. You can then work out the time differences between successive records.

Here's some sample code:

using System;
using System.Data;
using System.Linq;

class Program
{
static void Main()
{
DataTable dt = new DataTable();
dt.Columns.Add("source ip");
dt.Columns.Add("destination ip");
dt.Columns.Add("stime", typeof(int));
dt.Rows.Add("0.0.0.2", "0.0.0.4", 5);
dt.Rows.Add("0.0.0.1", "0.0.0.3", 4);
dt.Rows.Add("0.0.0.2", "0.0.0.4", 7);
dt.Rows.Add("0.0.0.2", "0.0.0.4", 10);
dt.Rows.Add("0.0.0.2", "0.0.0.3", 4);

var query = from DataRow dr in dt.Rows
let source = dr["source ip"].ToString()
let dest = dr["destination ip"].ToString()
group dr by new {source, dest} into g
select g;

foreach(var g in query)
{
Console.WriteLine(g.Key);
if (g.Count() == 1)
{
Console.WriteLine("Only one record in this group");
}
else
{
int time1 = Convert.ToInt32(g.ElementAt(0)["stime"]);
int time2;

for(int i = 1; i < g.Count(); i++)
{
time2 = Convert.ToInt32(g.ElementAt(i)["stime"]);
Console.WriteLine("{0} - {1} = {2}", time2, time1, time2 - time1);
time1 = time2;
}
}

Console.WriteLine();
}

Console.ReadKey();
}
}

The output is:

{ source = 0.0.0.2, dest = 0.0.0.4 }
7 - 5 = 2
10 - 7 = 3

{ source = 0.0.0.1, dest = 0.0.0.3 }
Only one record in this group

{ source = 0.0.0.2, dest = 0.0.0.3 }
Only one record in this group
0
diamond diamond12y ago
Thanks, yes I use datatable but I have duplicate source ipaddress and destination ip addresses. if I want to sort, I should choose all rows of one source ip address with one destination ip address. I think with sort it gets difficult.
0
Dhirendra Misra12y ago
Hello Diamond,

I think you you would be getting the result at datatable or DataSet.

If so you can make use of dataview and get sorted resultset then use foreach to traver each record and then calculate the difference.

Details on dataview can be found here:
http://www.dotnetperls.com/dataview

Hope it will help you.
0