Getting Max of an attribute value from Entity Collection - C# Discussion Boards

3-Feb-12 5:55

Hi,

I need to output netstat -ao to a SQL database. I have seen many sites/forums on ways to capture this info using the Process method as well as the IPGlobalProperties methods native to .NET.

While the IPGlobalProperties methods work very well there is no method that I have found that can get the process pid associated with each open port.

I have stripped EASY SOCKET V3 found here http://files.codes-sources.com/fichier.aspx?id=11430&f=easy_socket\iphelper.cs[^]but am not sure how to get the information out. The stripped code compiles but when I run the code from a c# Console application the console pops up and then closes almost immediately.

The stripped code is here http://pastebin.com/yVzrqcJX[^] if anyone is able to help.

Thank you in advance.

PIEBALDconsult3-Feb-12 7:40

PIEBALDconsult

3-Feb-12 7:40

CCodeNewbie wrote:
ways to capture this info using the Process method

Did that work? If not, what happened?

Luc Pattyn3-Feb-12 7:46

3-Feb-12 7:46

I have no problem executing NETSTAT and capturing its output through the Process class, with redirected outputs, done properly (i.e. with 2 extra threads, using Read, not ReadTillEnd or whatever it is called). Works fine, e.g. on .NET 2.0 and Vista.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

CCodeNewbie3-Feb-12 9:45

3-Feb-12 9:45

Do you get PIDs with your netstat? Can you pull each item individually? What I mean is could you do something like (please pardon the pseudo-code)

foreach entry in netstat
proto = protocol
LocalIP = Local Address
LocalPort = LocalIPPort
RemoteIP = Foreign Address
RemotePort = RemoteIPPort
State = State
PID = ProcessID

I was trying to use a streamreader writing to a stringbuiler.appendline but I kept getting the whole list instead of individual entries

PIEBALDconsult3-Feb-12 11:25

PIEBALDconsult

3-Feb-12 11:25

Perhaps use a Regular Expression:

C:\Projects\Utilities>regex "^(?'Proto'\S+)\s+(?'LocalIP'[^:]+): ( ?'LocalPort'\S+)\s+(?'ForeignIP'[^:]+): ( ?'ForeignPort'\S+)\s+(?'State'\S+)\s+(?'PID'\S+)$" "TCP    10.37.47.44:40091      hcc-l-sqld-001:1952    ESTABLISHED     8808"
0 = TCP    10.37.47.44:40091      hcc-l-sqld-001:1952    ESTABLISHED     8808
Proto = TCP
LocalIP = 10.37.47.44
LocalPort = 40091
ForeignIP = hcc-l-sqld-001
ForeignPort = 1952
State = ESTABLISHED
PID = 8808

Only tested a little bit with a very simple utility.

Edit: Some spacing added to avoid smilies. Mad | :mad:

modified 3-Feb-12 17:39pm.

Luc Pattyn3-Feb-12 15:40

3-Feb-12 15:40

No there is no guarantee that you will get results line by line; all you can hope for is to get all the output almost in real-time. In reality I think you normally get one or more entire lines at a time. You could easily capture it all into one string, then apply string.Split() on '\n' (and ignore '\r' that you are likely to get as well).

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

Re: Help with p/invoking iphlpapi.dll - Going in circles

jschell4-Feb-12 9:47

jschell

4-Feb-12 9:47

CCodeNewbie wrote:
I was trying to use a streamreader writing to a stringbuiler.appendline but I kept getting the whole list instead of individual entries

Building a string out of multiple lines will of course give you just a string.

Instead you use StreamReader to do one of the following
1. Process each line as it is read.
2. Put each line into a collection like a list.

CCodeNewbie5-Feb-12 2:05

Re: Help with p/invoking iphlpapi.dll - Going in circles

5-Feb-12 2:05

Thanks for all you comments/ideas but I am still struggling although making progress.

@PIEBALDconsult, I really like the regex idea but can't figure out how to pipe the ouput into you code.

@Luc, jschell - prior to investigating iphlpapi I was trying the Process method and have now gone back to that thanks to your suggestions. Th issues I am having though
- I still can't get the individual items to writeline or to a list
- I can't work out why connections[1]-[6] aren't populated.
- I need to connections[1].split(':') to split the host and the local port
- I need to connections[3].split(':') to split the host and the local port
- I can't get rid of the newlines between the split entries.

My code follows:

Process Ns = new Process();
ProcessStartInfo startInfo = new ProcessStartInfo("netstat");
startInfo.Arguments = "-ao";
startInfo.UseShellExecute = false;
startInfo.RedirectStandardOutput = true;
startInfo.CreateNoWindow = true;
Ns.StartInfo = startInfo;
Ns.Start();
for (int i = 0; i < 4; i++)
    Ns.StandardOutput.ReadLine();
while (true)
{
    string Line = (Ns.StandardOutput.ReadLine());
    string[] split = Line.Split(' ');
    foreach (string s in split)
    {
        List<string> connections = new List<string>();
        connections.Add(s);
        if (s != "" || s != Environment.NewLine)
        {
            Console.WriteLine("Protocol:", connections[0]);
            Console.WriteLine("LocalIP:", connections[1]);
            Console.WriteLine("LocalPort:", connections[2]);
            Console.WriteLine("RemoteIP:", connections[3]);
            Console.WriteLine("RemotePort:", connections[4]);
            Console.WriteLine("State:", connections[5]);
            Console.WriteLine("PID:", connections[6]);
        }
    }
}

Luc Pattyn5-Feb-12 3:25

Re: Help with p/invoking iphlpapi.dll - Going in circles

5-Feb-12 3:25

All you'll get from me are a few pointers:

0. programs tend to do what you ask them to do, which might be different from what you think you asked for.

1. Part of your code is working fine, another part is not. You should inspect intermediate values to determine which parts are which. That is called debugging.

2. When a .NET class or method isn't doing what you expected from it, then it is time to read the documentation.

3. There are several ways to fix what is wrong, some will suggest using Regex. I'm not one of them.

4. I'm baffled by your use of List<string> connections; it seems like a fancy way of turning an array into a list, then using it as if it were an array. I'm not saying anything is wrong here, however it is peculiar.

5. BTW: if (s != "" || s != Environment.NewLine) is utterly wrong for many reasons, one of them being ReadLine() normally doesn't return something that contains a NewLine string.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

CCodeNewbie6-Feb-12 5:57

6-Feb-12 5:57

OK, I'm lost...

Having not worked out how to get the members of the "string Line" array, despite trying "string [] Line" I have succumbed to reducing the string though string manipulation. What I can't figure out is how to get rid of the newline-like spaces between the split strings so that I can add those strings to a List<>.

Can anyone help? Please?

Process Ns = new Process();
            ProcessStartInfo startInfo = new ProcessStartInfo("netstat");
            startInfo.Arguments = "-ao";
            startInfo.UseShellExecute = false;
            startInfo.RedirectStandardOutput = true;
            startInfo.CreateNoWindow = true;
            Ns.StartInfo = startInfo;
            Ns.Start();
            for (int i = 0; i < 4; i++)
                Ns.StandardOutput.ReadLine();
            while (true)
            {
                string Line = (Ns.StandardOutput.ReadLine().Trim());
                string[] s = Line.Split(':');
                foreach (string a in s)
                {
                    string[] t = a.Split(' ');
                    foreach (string b in t)
                    {
                        string u = b.Replace(" ","");// can't get rid of the spaces here
                        if (b != Environment.NewLine)
                        {
                            Console.WriteLine(b.ToString());
                            Console.ReadLine();
                        }
                    }
                }
            }

Thank you.

Luc Pattyn6-Feb-12 6:25

6-Feb-12 6:25

Some questions:

1. half of the code shown is about getting some process results; is that working? if it is, why still show it? if not, what is happening?

2. the other half is about dealing with some strings you got. The least you should do is show some of them so people can make suggestions.

3. why was there "P/Invoking" in the subject line?

Some facts:

1. once you do string[] t = a.Split(' '); there will not be any space in array t, therefore the one comment you have shown does not make sense.

2. the spaces are there to make the NETSTAT output look tabular; by splitting or otherwise removing the spaces, you are throwing away information. Therefore that is the wrong approach.

3. You still have a silly test for Environment.NewLine! Do you actually understand what you are doing, or are you just throwing some code together at random?

Some advice:

1. When a problem is too big to solve, split it into smaller, more manageable problems; then tackle those, one by one.

2. What you really want is replace all consecutive spaces by a single space. Then life suddenly gets easy. So work on that.

3. Do read the replies you get.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

CCodeNewbie6-Feb-12 9:23

6-Feb-12 9:23

Have you tried loading the code into a VS2005 or later console app?

Qustions:

1) The process part runs perfectly and the output to console is as per a cmd-based netstat.

Process Ns = new Process();
ProcessStartInfo startInfo = new ProcessStartInfo("netstat");
startInfo.Arguments = "-ao";
startInfo.UseShellExecute = false;
startInfo.RedirectStandardOutput = true;
startInfo.CreateNoWindow = true;
Ns.StartInfo = startInfo;
Ns.Start();
for (int i = 0; i < 4; i++)
    Ns.StandardOutput.ReadLine();
while (true)
{
    string Line = (Ns.StandardOutput.ReadLine().Trim());
    Console.Writeline(Line);

produces
TCP-----robin:epmap---------robin.abc.xyz: 0-----LISTENING-----------948 (hyphens represent "spaces") as you quite rightly say, in tabular format.

what I am trying to do is separate each field (i.e. TCP / robin / epmap / robin.abc.xyz / 0 / LISTENING / 948 so that I can write each entry into a SQL db. with columns protocol/localhost/localport/remotehost/remoteport/state/PID.

2) it would probably be easier to see what the problem is if you copied and pasted the code into a console application (I am running VS2005 on WinXP), but as you may see from the above output, there are "spaces" in between the fields. Despite my best efforts in doing this:

string Line = (Ns.StandardOutput.ReadLine().Trim());
                string[] s = Line.Split(':');
                foreach (string a in s)
                {
                    string[] t = a.Split(' ');
                    foreach (string b in t)
                    {
                        string u = b.Replace("        ","");
                        {
                            Console.WriteLine(b.ToString());
                            Console.ReadLine();
                        }
                    }
                }

I get this:

TCP

robin

epmap

robin.abc.xyz

0

LISTENING

948

(shown here as appears in the debug console)

Only problem is that they are not spaces, tabs, newlines or anything else that I can edit out. I have to assume that the are whitespace that is actually part of the field but I need to get rid of it and don't know how (despite ~24 hours of research)

3) After days of research, nearly every net search I did on c# netstat pointed to using p/invoke to be able to get the netstat details with PID mappings, thus my referral to http://files.codes-sources.com/fichier.aspx?id=11430&f=easy_socket\iphelper.cs[^]

Facts:

1) I am doing a split so that I can separate out the fields, if there is a better way please point me to it. There does seem to be some sort of "padding" in the array as you can see from the above output.

2) The spaces contain no valuable information and need to be removed so they can be written into a db. I don't want/need to display them in a console or a form.

3) I know the previously posted code contained a newline test. The code was uploaded after I reached my wits end trying to figure out how to get rid of the "padding". I should probably have edited that line out.

Advice

1) The problem is "how do I get these pieces of information into a usable state?" I don't have the knowledge/experience in solving that problem and many hours on msdn, this site and dozens of others has not yielded a solution. That's why I asked.

2) If I knew how to do that, or could find a site that says something other that
string u = b.Replace(' ',string.Empty), string u = b.Replace(" ","") or some combination of those that actually worked, I wouldn't be asking the question.

3) I do actually read the replies. I spent hours yesterday and today trying to work out/research how to extract the individual members of the string [] Line array but could not get anything other that Console.Writeline(s[0]) to display. I expect I was initialising the array incorrectly but eventually gave up and went back to basic string manipulation to try and get a result. Unfortunately the replies are sometimes above my head (which leads me to ask more questions) or a just someone's best guess.

I hope the above has sufficient detail for you and look forward to your reply.

Thank you Luc.

Luc Pattyn6-Feb-12 9:55

6-Feb-12 9:55

CCodeNewbie wrote:
Have you tried loading the code into a VS2005 or later console app?

Nope. That is your job. However I can read code and see what it does, and where it is wrong.

2.
I can assure you the white space in NETSTAT's output consists of regular space characters, ASCII 0x20, Unicode 0x0020.
The only surprise you may get, depending on how you do things, is a single unexpected carriage-return character per line (ASCII 0x0D, or '\r'). And that is because on Windows a newline operation may consist of carriagereturn + linefeed, and you might splitting on (and swallowing) linefeeds, leaving the carriage-returns in place.

3.
How many array elements do you expect from the following:

string[] parts="ABBBC".Split('B');

Now check it.
And if you were to replace every B in the above line by a space, would that change anything?

4.
Any idea what the following code does:

string s="some    silly   text   of   arbitrary                                           length";
s=s.Replace("        "," ");
s=s.Replace("    "," ");
s=s.Replace("  "," ");
s=s.Replace("  "," ");
s=s.Replace("  "," ");
s=s.Replace("  "," ");
string[] words=s.Split(' ');

And why the last few Replace statements are there at all?

5.
in

TCP    0.0.0.0:135            SOMENAME:0             LISTENING       1288

which one is the major separator, the colon or the space? work on the major one first.
don't even spend a second of your time on a secondary separator as long as you haven't fully mastered the major separator.

6.
This is my last entry in this thread. Text, explanations and code by far exceed what this little problem warrants already.

Hmmm | :|

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

CCodeNewbie6-Feb-12 10:35