%3CLINGO-SUB%20id%3D%22lingo-sub-365496%22%20slang%3D%22en-US%22%3EAEM%20Views%20and%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365496%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Feb%2020%2C%202009%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EI'll%20soon%20be%20putting%20together%20some%20AEM%20(Agentless%20Exception%20Monitoring)%20reports%2C%20so%20I%20figured%20I'd%20familiarize%20myself%20with%20the%20how%20AEM%20data%20is%20stored%20in%20the%20Date%20Warehouse.%26nbsp%3B%20Surprisingly%2C%20not%20all%20of%20the%20useful%20data%20is%20stored%20in%20Views....you%20have%20to%20go%20to%20the%20tables%20for%20the%20good%20stuff.%3C%2FP%3E%0A%3CP%3EIf%20I've%20missed%20anything%2C%20please%20let%20me%20know.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1538577733%22%20id%3D%22toc-hId-1538577733%22%3EAEM%20DW%20Views%3A%3C%2FH3%3E%0A%3CP%3ECM.vCMAemRaw%3C%2FP%3E%0A%3CP%3E%C2%B7%20Contains%20raw%20data%20for%20application%20errors%3C%2FP%3E%0A%3CP%3E%C2%B7%20ErrorGroupRowID%20can%20be%20joined%20with%20AEMErrorGroup%20table%20to%20get%20Application%20Error%20details%3C%2FP%3E%0A%3CP%3E%C2%B7%20AEMUserRowID%20can%20be%20joined%20with%20AEMUser%20table%20to%20get%20the%20user%20name%3C%2FP%3E%0A%3CP%3E%C2%B7%20AEMComputerRowId%20can%20be%20joined%20with%20AEMComputer%20table%20to%20get%20computername%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86735iB49F86C17B0E2D4B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ECM.vCMAemErrorGroupDaily%3C%2FP%3E%0A%3CP%3E%C2%B7%20Daily%20aggregation%20of%20application%20errors%20(by%20error)%3C%2FP%3E%0A%3CP%3E%C2%B7%20Shows%20daily%20numbers%20for%20specific%20application%20errors%3C%2FP%3E%0A%3CP%3E%C2%B7%20Shows%20how%20many%20times%20each%20application%20error%20was%20seen%20per%20day%2C%20and%20a%20count%20of%20users%2Fcomputers%3C%2FP%3E%0A%3CP%3E%C2%B7%20ApplicationRowID%20can%20be%20joined%20with%20AEMApplication%20table%20to%20get%20application%20details%3C%2FP%3E%0A%3CP%3E%C2%B7%20ErrorGroupRowID%20can%20be%20joined%20with%20AEMErrorGroup%20table%20to%20get%20Application%20Error%20details%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86737i9FA46A81F16C772B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ECM.vCMAemApplicationDaily%3C%2FP%3E%0A%3CP%3E%C2%B7%20Daily%20aggregation%20of%20application%20errors%20(by%20application)%3C%2FP%3E%0A%3CP%3E%C2%B7%20Shows%20daily%20numbers%20for%20specific%20applications%3C%2FP%3E%0A%3CP%3E%C2%B7%20Shows%20how%20many%20times%20each%20application%20had%20an%20error%2C%20how%20many%20different%20errors%20it%20had%2C%20how%20many%20user%2Fcomputers%20had%20errors%3C%2FP%3E%0A%3CP%3E%C2%B7%20ApplicationRowID%20can%20be%20joined%20with%20AEMApplication%20table%20to%20get%20application%20details%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86739i94287418EFA45C59%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ECM.vCMAemDaily%3C%2FP%3E%0A%3CP%3E%C2%B7%20Shows%20the%20date%2Ftime%20that%20daily%20aggregations%20happened%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20167px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86741i2978606EA9D4CF63%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1013579228%22%20id%3D%22toc-hId--1013579228%22%3EAEM%20DW%20Tables%3A%3C%2FH3%3E%0A%3CP%3EAemApplication%3C%2FP%3E%0A%3CP%3EContains%20name%2Fversion%20for%20applications%20that%20we%20have%20errors%20from%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86743i57786CE871B79CEA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAemComputer%3C%2FP%3E%0A%3CP%3EContains%20computer%20names%20that%20we%20have%20received%20errors%20from%E2%80%A6also%20shows%20date%2Ftime%20that%20last%20error%20was%20received.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20451px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86744iF49D190090C95B7B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAemErrorGroup%3C%2FP%3E%0A%3CP%3EContains%20details%20of%20specific%20application%20errors%20that%20we%20have%20received%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86746i929CDF6DE789A0C8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-729231107%22%20id%3D%22toc-hId-729231107%22%3EAemSystemErrorGroup%3C%2FH3%3E%0A%3CP%3E%C2%B7%20Contains%20basic%20info%20about%20system%20errors%20(BucketType%2C%20User%2C%20Computer%2C%20time)%3C%2FP%3E%0A%3CP%3E%C2%B7%20Details%20of%20the%20system%20error%20are%20not%20included%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86748i50FDD3DC2F07CD3E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1822925854%22%20id%3D%22toc-hId--1822925854%22%3EAemUser%3C%2FH3%3E%0A%3CP%3EContains%20user%20names%20that%20we%20have%20received%20errors%20from%E2%80%A6also%20shows%20date%2Ftime%20that%20last%20error%20was%20received.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20339px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86750i7655B95740E07715%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-365496%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20TECHNET%20on%20Feb%2020%2C%202009%20I'll%20soon%20be%20putting%20together%20some%20AEM%20(Agentless%20Exception%20Monitoring)%20reports%2C%20so%20I%20figured%20I'd%20familiarize%20myself%20with%20the%20how%20AEM%20data%20is%20stored%20in%20the%20Date%20Warehouse.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-365496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EJimmyHarper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

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.