Posted on 2011-03-20
From a table that contains user logs i need to get info from two columns: contain client_id and log_description.
The user_id column is a 4 word column.
The log description column contains alot of user activity listed in separate rows (including: time logged on, server connected to, IP address, connect/disconnect, action carried out, etc)
how can i find out users (userID column) that have connected and disconnected (log_description column) more than 10 times?
i believe i need to filter the log_description column to search for keywords (%connect% / %disconnect%) and associate that with the userid column. then display results as # of connections.