0

Let's Say i have two Tables, let's call them

PC-Info 
| ID | Hostname  | Location          |
|:---|----------:|:-----------------:|
| 1  | Hostname1 | This Room         |
| 2  | Hostname2 | That Room         |
| 3  | Hostname3 | The other Room    |
| 4  | Hostname4 | Somewhere Offsite |    

And

IsUp
| Timestamp  | Hostname1   | Hostname2   |
|:-----------|------------:|:-----------:|
| 19.02.2017 | up          | down        |
| 20.02.2017 | down        | down        |
| 21.02.2017 | down        | up          |
| 22.02.2017 | up          | down        |

What would a query in Access look like to get the last time the host was "up", bundeled with the other Info? Or is this database flawed from the ground up?

Since the amount of hosts ist fixed and the timestamps will increase over time, I thought it was the better idea to have fixed columns and add rows per timestamp.

1

I would have....

| Hostname | Timestamp | Status |
|----------|-----------|--------|
| Host1    | 19.02.2017| up     |
| Host2    | 19.02.2017| down   |
| Host3    | 19.01.2017| down   |

Then you could have another table...

| ID | Hostname | Location       |
|----|----------|----------------|
| 1  | Host1    | Living Room    |
| 2  | Host2    | Bedroom        |

When you run queries, it's easy to find all of Host1's activities, or you could easily find all the activities for 19.02.2017. Yes you have a million rows, but that doesn't matter.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.