Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for uptime comparison in filters #366

Open
lyricnz opened this issue Jun 24, 2024 · 1 comment
Open

Support for uptime comparison in filters #366

lyricnz opened this issue Jun 24, 2024 · 1 comment
Labels
enhancement New feature or request

Comments

@lyricnz
Copy link
Contributor

lyricnz commented Jun 24, 2024

So that a schedule can include: "uptime > 1 hours" (using resource.LaunchTime)

@lyricnz
Copy link
Contributor Author

lyricnz commented Jul 22, 2024

There's no direct metadata on RDS instances that provide the start-time. We may be able to use RDS events to get this:

aws rds describe-events --output text
VENTS  2024-07-22T01:36:00.540000+00:00        Recovery of the DB instance has started. Recovery time will vary with the amount of data to be recovered.       arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES recovery
EVENTS  2024-07-22T01:36:30.718000+00:00        Recovery of the DB instance has started. Recovery time will vary with the amount of data to be recovered.       arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES recovery
EVENTS  2024-07-22T01:38:34.439000+00:00        DB instance restarted   arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES availability
EVENTS  2024-07-22T01:38:38.608000+00:00        DB instance restarted   arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES availability
EVENTS  2024-07-22T01:38:53.891000+00:00        Recovery of the DB instance is complete.        arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES recovery
EVENTS  2024-07-22T01:39:51.622000+00:00        DB instance started     arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES notification
EVENTS  2024-07-22T01:40:42.776000+00:00        Creating automated snapshot     arn:aws:rds:ap-southeast-2:658730722470:snapshot:rds:cloudsnooze-mysql-one-2024-07-22-01-40     rds:cloudsnooze-mysql-one-2024-07-22-01-40      db-snapshot
EVENTCATEGORIES creation
EVENTS  2024-07-22T01:40:42.776000+00:00        Backing up DB instance  arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES backup
EVENTS  2024-07-22T01:44:25.249000+00:00        Automated snapshot created      arn:aws:rds:ap-southeast-2:658730722470:snapshot:rds:cloudsnooze-mysql-one-2024-07-22-01-40     rds:cloudsnooze-mysql-one-2024-07-22-01-40      db-snapshot
EVENTCATEGORIES creation
EVENTS  2024-07-22T01:44:25.669000+00:00        Finished DB Instance backup     arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES backup
EVENTS  2024-07-22T01:53:35.068000+00:00        DB instance stopped     arn:aws:rds:ap-southeast-2:658730722470:db:cloudsnooze-mysql-one        cloudsnooze-mysql-one   db-instance
EVENTCATEGORIES notification

@lyricnz lyricnz added the enhancement New feature or request label Aug 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant