SOX user access report email

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
We need to be able to have a report automatically e-mailed once a month (easy part) that includes the basic information listed in the User page (Name, Role, Status, Last Visited, etc) for all users of the database.

Help!
Photo of Randy

Randy

  • 110 Points 100 badge 2x thumb

Posted 6 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
Where is the question mark in your question? It isn't clear if you are inquiring about a specific application you are using or if you have an implementation question. More details are needed to reply as well as a formal question mark..
Photo of Randy

Randy

  • 110 Points 100 badge 2x thumb
Sorry about that.  How do I create the report that lists the users information so that I can set it up to e-mail it out each month?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
It is still not clear what you want. If you are an administrator and click on the Users button QuickBase will list the Users with access to your application and will include the following information: Name, Roll, Status, Last Visited, and Show in User pickers. This isn't a report in the sense that the information is not queried from a table. Nevertheless, is this the type of information you want to email out every month?
Photo of Randy

Randy

  • 110 Points 100 badge 2x thumb
Yes, you are correct.  We have been taking screen shots each month of that page.  They would like that information in a report format that would be sent via email each month.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
There are a variety of approaches you could take. One approach is to use script and dynamically scrape that page's info and throw it into a table and then rely on QuickBase's normal table reporting and notification features. This would require an administrator to click on a button on the dashboard or load a user defined page to gather the info and update it into a table.

This is a generic technique in the sense that any information you have in QuickBase can be gathered using scripting and the API and thrown into a table dynamically. The table you used would not be displayed in the application's navigation menu nor used for normal user input using forms. Instead the table would be only used to received scraped information from the script.