B0b_shiska
asked on
select statements
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.
Please advice.
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.
Please advice.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you provide some sample data and the expected output?