I have received a number of questions both from customers and in the community about custom AEM reports, including more information. In this post I will give you some tips how to write custom AEM reports. I wrote another post<\/a> about author reports in general for Ops Mgr 2007.<\/p>\n I write my AEM reports in Microsoft Visual Studio 2008. When you start Visual Studio you can choose to start a new Report Server Project. When you blank project has opened you should start with creating a shared data source, specify your Operations Manager data warehouse database. Then add a new item, a report, under the Reports folder in the Solution Explorer window.<\/p>\n The example report below is a “per user” report, which will show you all AEM events for a specified username. I have included some numbers, with total number of users, total number of events, average number of events per user and total number of events for the specified user. I have also included info about the last event for the specified user and a table with all events for the specified user.<\/p>\n In my example report I use four dataset.<\/p>\n List usernames<\/p>\n SELECT DISTINCT AemUserName FROM [CM].[vCMAemRaw] Rw All info for the first table in the example<\/p>\n SELECT (SELECT COUNT(CrashID) FROM CM.vCMAemRaw) AS TotalEvents, (SELECT COUNT(DISTINCT AemUserRowID) FROM CM.vCMAemRaw) AS TotalUsers, (SELECT (SELECT COUNT(CrashID) FROM CM.vCMAemRaw ) \/ (SELECT COUNT(DISTINCT AemUserRowID) FROM CM.vCMAemRaw)) AS TotalAverage, (SELECT COUNT(CrashID) FROM [CM].[vCMAemRaw] Rw Note that I use a parameter, @UserName. Last problem for the specified user<\/p>\n SELECT top 1 CrashTime FROM [CM].[vCMAemRaw] Rw Info for the “all events for user” table<\/p>\n SELECT CrashTime, AemComputerName,BucketType,Parameter1,Parameter2,CompanyName, AemUserName FROM [CM].[vCMAemRaw] Rw When you have added the fields from all datasets to your report, you can simple deploy it to your reporting server. The base SQL query I used is<\/p>\n select * from [CM].[vCMAemRaw] Rw Thanks to Kevin Holman for that one. I think that with the base SQL query for AEM you can build all kind of AEM reports that your organization needs. And when doing that, check out all new cool gauges in Visual Studio 2008.<\/p>\n Monitoring desktop client hardware, operating system and application faults can be of great value in terms of reducing total cost of ownership (TCO) through identification of widespread faults in the monitored environment. In Operations Manager 2007, there are actually three components for monitoring the client experience: Agentless Exception Monitoring (AEM) Customer Experience Improvement Program (CEIP) … Continue reading ![\"\"](\"http:\/\/contoso.se\/files\/AEMReport02.jpg\")
<\/p>\n\n
\nINNER JOIN dbo.AemComputer Computer ON Computer.AemComputerRowID = Rw.AemComputerRowID
\nINNER JOIN dbo.AemUser Usr ON Usr.AemUserRowId = Rw.AemUserRowId
\nINNER JOIN dbo.AemErrorGroup EGrp ON Egrp.ErrorGroupRowId = Rw.ErrorGroupRowId
\nINNER JOIN dbo.AemApplication App ON App.ApplicationRowId = Egrp.ApplicationRowId<\/p><\/blockquote>\n
\nINNER JOIN dbo.AemComputer Computer ON Computer.AemComputerRowID = Rw.AemComputerRowID
\nINNER JOIN dbo.AemUser Usr ON Usr.AemUserRowId = Rw.AemUserRowId
\nWHERE AemUserName=@UserName<\/a>) AS UserTotal<\/p><\/blockquote>\n
\nINNER JOIN dbo.AemComputer Computer ON Computer.AemComputerRowID = Rw.AemComputerRowID
\nINNER JOIN dbo.AemUser Usr ON Usr.AemUserRowId = Rw.AemUserRowId
\nINNER JOIN dbo.AemErrorGroup EGrp ON Egrp.ErrorGroupRowId = Rw.ErrorGroupRowId
\nINNER JOIN dbo.AemApplication App ON App.ApplicationRowId = Egrp.ApplicationRowId
\nWHERE AemUserName = @UserName ORDER BY CrashTime desc<\/p><\/blockquote>\n
\nINNER JOIN dbo.AemComputer Computer ON Computer.AemComputerRowID = Rw.AemComputerRowID
\nINNER JOIN dbo.AemUser Usr ON Usr.AemUserRowId = Rw.AemUserRowId
\nINNER JOIN dbo.AemErrorGroup EGrp ON Egrp.ErrorGroupRowId = Rw.ErrorGroupRowId
\nINNER JOIN dbo.AemApplication App ON App.ApplicationRowId = Egrp.ApplicationRowId
\nWHERE AemUserName = @UserName<\/p><\/blockquote>\n
\ninner join dbo.AemComputer Computer on Computer.AemComputerRowID = Rw.AemComputerRowID
\ninner join dbo.AemUser Usr on Usr.AemUserRowId = Rw.AemUserRowId
\ninner join dbo.AemErrorGroup EGrp on Egrp.ErrorGroupRowId = Rw.ErrorGroupRowId
\nInner join dbo.AemApplication App on App.ApplicationRowId = Egrp.ApplicationRowId<\/p><\/blockquote>\n![\"\"](\"http:\/\/contoso.se\/files\/AEMReport03.jpg\")
<\/p>\n","protected":false},"excerpt":{"rendered":"