Does any one know how to list the Users in QC who has not logged in more than 6 months using MSSQL query
SELECT * FROM
SELECT DISTINCT USER_NAME, MAX(END_TIME) As 'Last_LogOut'
GROUP BY user_name
WHERE Last_Session.Last_LogOut < '2010-07-01'
... just another Tester ...
I tried executing the query but received error as shown below.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'SESSIONS_HISTORY'.
Pls let me know if i am doing something wrong .
Its working fine , but from GUI u need to select the DB , and run the query .
Apart from that query is very good