Save and store the Report of All Assets from CSPM (or use built in, or export to AWS/GCP)

[ActionAnalytics]

Describe the issue Hackathon fun ticket - be creative, have fun

Report/Dashboard showing over time deployment activities for all Workload Environments.

Additional context

• Related ticket shows "current posture" = snapshot now, this ticket is about historic log activity in an easy to consume format
• Sample scenario: A rogue ex-team member still with access goes and deploys a C&C VM in AWS, runs it for 2 days, and then tears it down. We would like to have logs of the deployments that we could query to see that kind of activity.
• CSPM might not have the logging/dashboard/time-series capacity, but it may have the capacity to save snapshots on a chron and we could hook up a location / DB to save it to

Definition of done

• a Report/Dashboard showing over time assets state activities for all Workload Environments
• Must show time series data of assets on Tuesday, vs assets on Wednesday
• Focus on a dashboard of choice (Excel, Metabase, PowerBI, ElasticSearch) - don't worry about automation, just drop in the data twice or three time, and demo that stuff is changing
• Prefer central CSPM approach in order to reuse across CSPs, second CSP specific implementation
• Can be filtered by Project-set and time

[kdesao-devops]

We have created a Quicksight and a metabase dashboard to do a demo and respond to the needs expressed in this ticket.

A demo has been presented to the team and we have decided to move on with the automation of the Quicksight solution. follow up ticket