I am being ask by Audit to provide a daily report of the Admin accounts
for B2B/Sterling File Gateway. I have looked through all the reports I
can pull and can't see where I can just get admin accounts. Here are
the requirements from Audit
For the report we would need the employee ID, first name, last name and
access level for each user in the application. Ideally we would want
the report to be scheduled to run on a daily basis and sent to our
SailPoint mailbox. Once we have the file name of the report we can set
up the mailbox.
If a direct connection to the database for read only access is an
option, that would be preferred and we would need a query to pull in
the fields listed above, instead of running a report and send a file.