How do I get a report on Event History in AppManager? (NETIQKB54380)

  • 7754380
  • 02-Feb-2007
  • 08-Oct-2010

Environment

AppManager 6.x
AppManager 7.0.x

Situation

How do I get a report on Event History in AppManager?
How do I determine who updated or closed an event in AppManager?

Resolution

Run the following Microsoft SQL Server statement in SQL Query Analyzer against the AppManager repository to return all rows stored in the EventHistory table in the repository:

select  machinename,
 EventID,
 Operation,
 dateadd(second,ModificationTime,'1/1/1970 0:0:0')as Time,
 suser_sname(UserID) as UserName
   from EventHistory
   Order by  
 MachineName,
 EventID,
 Time Asc

Results from this query will be returned in the SQL Query Analyzer and used for informational purposes only.


Additional Information

Formerly known as NETIQKB54380

To gather details regarding event history, event auditing must be enabled in AppManager.  For information about how to enable event auditing, see the AppManager documentation or Help in the Operator Console.