2 Replies Latest reply on Feb 19, 2013 5:54 PM by tgoyette

    Creating a report showing FTP traffic

    tgoyette

      eFI am trying to create a report in Report writer that shows the source and destination IP addresses of conversations using port 21. The challenge is that I only want to show a source / destination pair once and not everytime a conversation between th pair occurs. For example over the span of a week an FTP job may occur between 10.10.10.1 and 10.10.20.1 50 times.  I only want it displayed once in the report not 50 times. I cannot figure out how to wrire a report in report writer nor can I figure out how to generate and execute an SQL script to accomplish the same thing.   Any help would be apprecriated.