This is probably simple but I think I'm brain dead today. I modified one of the audit reports to show user logons for the past 7 days. It works fine. But now I want to narrow the results to certain users. I don't want to use a prompt since this will run weekly at midnight. Any ideas on a filter for this?
have you tried conditional filtering? With a condition like
Case when (?prompt? = '7 days') then ('....')
when (?prompt? = 'Weekly') then ('....')
else ('...')
end
Thanks. I wrote a filter to handle the weekly part and it works fine using the add_days function. I'm looking to write one to handle the other piece. I'm using the audit package. I only want a subset of the users not all of them. I.e. monitor just say the group A users who logged in not the IT admins. I found a workaround by using prompts and specifying certain users in the report schedule. It would be nice to be able to write a filter for it.