application-log-reports-reactive-analytics
Reactive icon

Application Log Reports (Reactive Analytics)

Stable version 1.0.3 (Compatible with OutSystems 11)
Uploaded
 on 11 Sep
 by 
3.0
 (1 rating)
application-log-reports-reactive-analytics

Application Log Reports (Reactive Analytics)

Details
Outsystems does not provide analytics for Reactive applications out of the box. Due to the nature of reactive, they can be complex. This application demonstrates how to pull basic analytics from the Service Center logs into a Data Grid Reactive display, so that you can group, sort, export, etc. The most recent update adds sample pages for Application User counts, combining Reactive/Mobile and Traditional in one screen by using an Advanced SQL Query.
Read more

The application requires a Service Center login, since the logs are kept in a separate database from the standard database which holds system and business entities. It uses the standard PlatformLogs extension to access the Log_Mobile_Request entity, which is where Reactive applications send their logs. These logs only record server side actions.

The grid exposes the data in summary fashion, by Instant (date), Application Name, Module Name (espace), Page Name (screen), Action name (endpoint), count, average duration (ms), and count of slow accesses - set to 250 ms by default.

Future or suggested enhancements:

  • Expose the SlowAccess setting as a site property to change the value from 250
  • Use a daily timer to record the days activity into an Entity in the regular database to allow a regular user to have access. Or create a new entity in the Log database that would accumulate multiple days of data


Icon made by Pixel perfect from www.flaticon.com

Release notes (1.0.3)

Updated dependencies, used only trusted or supported dependencies

License (1.0.3)
Reviews (1)
by 
12 Dec (4 days ago)
in version 1.0.3
While this asset can be useful in some situations, it also contains risks.

When we executed it in our environment, the running INSERT SELECT statement caused us to reach the IOPS limit, which resulted in other applications being unable to READ/WRITE to the platform DB, causing errors to occur.

Our platform DB uses AWS SQL Server.
Answer from the owner
12 Dec (4 days ago)
in version 1.0.3
Hi Hideto, thanks for the review. Can you tell me exactly where you ran into this issue? Also, do you have an idea about how many records you have in your logs? The tool is primarily meant to provide an example of how to get this information, so feel free to modify it to meet your needs. In your case, if you have a large number of log records, you could limit the queries by date, and only show the last month, for example, or even include a Start and End date so that you could look at usage over a certain period.

Another option would be to use the basic queries on a timer to save the data daily or weekly in a historical entity, then query the entity for the reports.
Team
Other assets in this category