QUERY: Get all nodes with actions from audit in a timespan

select distinct public."DbAuditLogsToNodes"."NodeID"
from public."DbAuditLogs"
left outer join public."DbAuditLogsToNodes" on public."DbAuditLogsToNodes"."AuditLogID" = public."DbAuditLogs"."Id"
where public."DbAuditLogs"."Date" > '2024-07-22 22:00:46.850768' and public."DbAuditLogs"."Date" < '2024-07-23 23:47:46.850768'


Revision #1
Created 30 July 2024 15:12:35 by Quinn Godfrey
Updated 30 July 2024 15:12:45 by Quinn Godfrey