First published on TECHNET on Feb 20, 2009
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.
AEM DW Views:
CM.vCMAemRaw
· 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
CM.vCMAemErrorGroupDaily
· 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
· ErrorGroupRowID can be joined with AEMErrorGroup table to get Application Error details
CM.vCMAemApplicationDaily
· 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
· ApplicationRowID can be joined with AEMApplication table to get application details
CM.vCMAemDaily
· Shows the date/time that daily aggregations happened
AEM DW Tables:
AemApplication
Contains name/version for applications that we have errors from
AemComputer
Contains computer names that we have received errors from…also shows date/time that last error was received.
AemErrorGroup
Contains details of specific application errors that we have received
AemSystemErrorGroup
· Contains basic info about system errors (BucketType, User, Computer, time)
· Details of the system error are not included
AemUser
Contains user names that we have received errors from…also shows date/time that last error was received.
