The current report I use does not use the filter, however, I need the data in the report. I had to automate it because it has to be as current as possible. The report is ran at 5am everyday as a .csv. The file is saved to an SFG mailbox and then the file is picked up by our provisioning application First Access. First Access uses this report to identify all users' existing accesses (groups, roles, etc.) and then take information from requests by users from First Access to add and/or modifications accounts. First Access will use web services to modify these accounts.
The issue is that the filter is the only reference (from what I could see) to the Inactive column in the mdb. To make the report the most useful, I need to be able to identify if users are Active or Inactive. I didn't see the Inactive column in the ca_contact table referenced anywhere in the schema designer, Universe Design Tool, etc. I didn't want to make a new field (column) when there is an existing column that provides the information I need (did SQL queries on the database to confirm).