Skip to main content

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'