I'll soon be putting together some AEM (Agentless Exception Monitoring) reports, so I figured I'd familiarize myself with the how AEM data is stored in the Date Warehouse. Surprisingly, not all of the useful data is stored in Views....you have to go to the tables for the good stuff.
If I've missed anything, please let me know.
· Contains raw data for application errors
· ErrorGroupRowID can be joined with AEMErrorGroup table to get Application Error details
· AEMUserRowID can be joined with AEMUser table to get the user name
· AEMComputerRowId can be joined with AEMComputer table to get computername
· Daily aggregation of application errors (by error)
· Shows daily numbers for specific application errors
· Shows how many times each application error was seen per day, and a count of users/computers
· ApplicationRowID can be joined with AEMApplication table to get application details
· Daily aggregation of application errors (by application)
· Shows daily numbers for specific applications
· Shows how many times each application had an error, how many different errors it had, how many user/computers had errors
· Shows the date/time that daily aggregations happened
Contains name/version for applications that we have errors from
Contains computer names that we have received errors from…also shows date/time that last error was received.
Contains details of specific application errors that we have received
· Contains basic info about system errors (BucketType, User, Computer, time)
· Details of the system error are not included
Contains user names that we have received errors from…also shows date/time that last error was received.
Hello Jimmy -
Thanks for this interesting article. Can you please direct me where I can get these reports from ? I can't find it on your blog.