<p>I don't think any database services "internal traffic" is available to AWS services directly.</p>

<p>That being said, you should be able to dump all sql queries to a log file on S3 and also extract all database/table combinations to a text file as well.</p>

<p>It then becomes a text processing exercise that you can possibly solve with AWS Athena</p>

CC BY-SA 4.0
2019-11-03T00:59:25.853Z
2019-11-03T00:59:25.853Z
jdog
<p>Is it possible to have AWS-RDS (or another aws service) generate a report on databases that haven't been interacted with (write/read) after a certain period of time?</p>

<p>My background is in QA and I'm relatively new to the DevOps game, sorry if this is a basic question, couldn't find it in search.</p>

CC BY-SA 4.0
2019-11-03T12:10:42.237Z
What about checking AWS CloudWatch? If there is no activity then there is no interaction.
030
<databases><amazon-cloudwatch><amazon-rds>
AWS RDS- Determine what Database Tables aren't interacted with?
TinCan
# AWS RDS- Determine what Database Tables aren't interacted with?

(Asked by: username_0 on 2019-11-01)

Is it possible to have AWS-RDS (or another aws service) generate a report on databases that haven't been interacted with (write/read) after a certain period of time?

My background is in QA and I'm relatively new to the DevOps game, sorry if this is a basic question, couldn't find it in search.

**Tags:** databases, amazon-cloudwatch, amazon-rds

> **Comments:**
> **username_1**: What about checking AWS CloudWatch? If there is no activity then there is no interaction.  

---

## 1 answers

### Answer by username_2 on 2019-11-03. Score: 1

I don't think any database services "internal traffic" is available to AWS services directly.

That being said, you should be able to dump all sql queries to a log file on S3 and also extract all database/table combinations to a text file as well.

It then becomes a text processing exercise that you can possibly solve with AWS Athena


---

