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?
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.
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.