morphicstates

Comments

  • I posted a query in this thread that answers your question if it hasn't already been answered.
  • Really late, but I ran into the same problem. The following can be pasted into Data Source > Advanced DataBase Query (SQL, SWQL). Select SQL. The WHERE and SORT clauses can be modified to fit your needs. SELECT Audit.[AuditEventID] ,Audit.[TimeLoggedUtc] ,Audit.[AccountID] ,Audit.[ActionTypeID]…
  • Who UnManaged the Application... SELECT Audit.[AuditEventID] ,Audit.[AccountID] ,ActionType.[ActionTypeDisplayName] ,Audit.[AuditEventMessage] ,Node.[DNS] ,Node.[IP_Address] ,App.[Name] ,App.[Unmanaged] ,App.[UnmanageFrom] ,App.[UnmanageUntil] FROM [NetPerfMon].[dbo].[AuditingEvents] Audit LEFT JOIN…
  • Who UnManaged the Node... SELECT Audit.[AuditEventID] ,Audit.[TimeLoggedUtc] ,Audit.[AccountID] ,Audit.[ActionTypeID] ,ActionType.[ActionTypeDisplayName] ,Audit.[AuditEventMessage] ,Audit.[NetworkNode] ,Audit.[NetObjectID] ,Node.[DNS] ,Node.[IP_Address] ,Node.[UnManaged] ,Node.[UnManageFrom] ,Node.[UnManageUntil] FROM…