Log Storage Table in Pyramid Repository Database
I want to make the system logs and scheduled job logs visible to users by creating a dashboard in Pyramid. Is there a table in the Pyramid repository database that stores these logs? If so, could you please provide the table name or let me know where I can find it?
1 reply
-
Hi ,
As of Pyramid 2023, as part of the install routine, we shipped a Pyramid Usage Model, which mapped certain tables from our repository containing the logs to a Pyramid Direct Query model. This then allows you to use Pyramid to analyze Pyramid! Look for something like this:
The Database Server is in this case PostgreSQL (Could be other systems depending on your installation), database is called pyramidg2 (although this could have been changed on installation) and model is Usage. If you can't find it, speak to your admin as you may not have access to the Server, database or Model depending on your Role.
If it is not there, then this post explains how to set it up from scratch:
https://community.pyramidanalytics.com/t/m2a7cd/pyramid-usage-model-and-analysis
and this one goes into more detail about the Measures:
https://community.pyramidanalytics.com/t/184nyf/pyramid-usage-model
Hope that helps!
Ian