Analytics: Audit Log for Analytics

[gelluisaac]

Problem

No audit trail for who accessed analytics data, what queries were run, or what exports were generated.

Solution

Implement comprehensive audit logging:

• Query logging
• Access logging
• Export logging
• Dashboard view logging
• Audit log retention

Acceptance Criteria

• Log all analytics API calls
• Log query parameters
• Log export requests
• Log dashboard views
• Audit log retention: 1 year
• Audit log search/filter
• Audit log export

Related Files

• backend/src/middleware/audit-logger.js
• backend/src/database/audit-log.js
• frontend/src/pages/AuditLogViewer.tsx

Priority

HIGH-9

[paulinaapeh8]

@paulinaapeh8 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Trust me I can work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @paulinaapeh8 to this issue.

[karanjadavi]

@karanjadavi has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

can i work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @karanjadavi to this issue.

[jotel-dev]

@jotel-dev has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Pls Assign me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @jotel-dev to this issue.

[boalambo]

@boalambo has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hello maintainer, I would like to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @boalambo to this issue.

[PatrickKish1]

@PatrickKish1 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I can implement the analytics audit log by adding logging for all API calls, query parameters, exports, and dashboard views, with proper retention (1 year), search/filter, and export functionality. I'll update the backend middleware/database and create the frontend AuditLogViewer.tsx

ℹ️ Repo Maintainers: To accept this application, review their application or assign @PatrickKish1 to this issue.