2 Replies Latest reply: Jun 22, 2012 3:08 AM by Rob Wunderlich RSS

    Where Statement

      I am doing analysis on a web log. The fields I have are:

       

      UserName,

      TimeStamp,

      Action,

      SessionID (Identifier that tracks an active session)

       

      Before a user logs in, we track their UserName as 'NA' and when they log in their UserName switches to their actual login name. However, we also run scripts to test are servers that are also stored with the UserName 'NA'. Could you guys help me come up with the Where statement that would include the UserName 'NA' when there is another UserName within that SessionID and eliminate the UserNames 'NA' when it is the only UserName in that SessionID?

       

      Thanks in advance,

       

      Eric