Zurück
-
Titel
How to return the count of events by agent for a specific date range -
Beschreibung
Is there a way to return the number of events (just the count and not the event details) per agent for a specific date range? -
Lösung
WORKAROUND:
The following SQL query should return the needed data by changing the date to suit your needs. As this is a manual SQL query, it is not supported and provided here for informational purposes:SELECT ServerName AS 'Server Name', Count(*) AS Total FROM Topology.Server WITH(NOLOCK) Inner Joindbo.AuditEvent_IX_AgentID On Topology.Server.ServerID = dbo.AuditEvent_IX_AgentID.AgentIDWHERE _date_hh BETWEEN '2019-02-01' AND '2019-05-31' AND ServerName like '%' Group By ServerNameSTATUS:Enhancement Request VSTS157022 has been submitted to be considered for a future release of Change Auditor. -
Fehler-ID
VSTS157022