Project participants - last logged in date

I am trying to write the sql to genreate a report to list all users who belong to a project (via the cooridinators, members, guests groups) and who have loggedin in the past six months or not loggedin in the past six months.If you have any sql (oracle only please) that would be a start.Thanks.Mohsin Jessa

Find more posts tagged with

Comments

Greg_Griffiths_(ggriffiths_-_(deleted))

To get this to work you will need to do the following :1. Get all the userids from KUAF for all your users2. Look in the DAUDIT (or DAUDITNEW if 95) for the LOGIN event, assuming that you are auditing that, this can be filtered by user id3. filter the output by AUDITDATE

Pfizer_Developers

Hi Greg,Thanks for the response.I was hoping to avoid scanning the audit table(s).ThanksMohsin