I need some help. I was able to put together a small SQL to get the information I need except I am unable to pull the Action Type description associated to the Action Type ID? How would I go about pulling that information using the below queries?
SELECT [AuditEventID] AS [Event ID}
, [TimeLoggedUtc] AS [DATE]
, [AccountID] AS [User]
, [ActionTypeID] AS [Action Type ID]
, [AuditMessage] AS [Message]
FROM [SolarwiindsOrion_ABC].[dbo].[AuditingEvents]
WHERE (AccountID LIKE 'jane.doe' OR AccountID LIKE 'john.doe')
AND (ActionTypeID LIKE '6' OR ActionTypeID LIKE '7')
AND TimeLoggedUtc > DATEADD(day, -7, GETDATE())
ORDER BY TimeLoggedUtc