I was able to create a report on specific devices added within the last 7 days which is perfect. Is there a way to add who added this device?
In the "Select Method" drop down select Advanced Database Query (SLQ,SWQL) instead of Dynamic Query Builder.
USE THIS
NOT THIS
Marnell,
I can't take credit for this SQL report, I found this on Thwack some time ago. This is a SQL report that we run every Saturday. As a bonus the report who removed a node along with who added a node.
SELECT TOP (200)
[TimeLoggedUtc] ,[AccountID] ,[ActionTypeID] ,[AuditEventMessage]
FROM SolarWindsOrion.[dbo].[AuditingEvents]
where ActionTypeID = '25' or ActionTypeID = '26'
order by TimeLoggedUtc desc;
Just to add that the event for adding a node seems to be ActionTypeID = '24', so just add that to the query above:-
SELECT TOP 200
TimeLoggedUtc,
AccountID,
ActionTypeID,
AuditEventMessage
FROM Orion.AuditingEvents
where ActionTypeID = '25' or ActionTypeID = '26' or ActionTypeID = '24'
How would be able to create this on the gui?
I used this to create my original report
This works, but does not give me the any of the information from the report I created. I just need to add who added the device added onto my current report
