SQL Query: Most recent server entry, by server and disk
<p>I have a db that is storing server free disk space by disk every hour.</p>

<p>My query currently gets things in the following format:</p>

<pre><code>Name        DriveSpace  Date        Time

Server1 F:  123123123   2016-02-24  07:00:00
Server2 F:  123123123   2016-02-24  07:00:00
Server3 F:  123123123   2016-02-24  07:00:00
Server1 G:  123123123   2016-02-24  07:00:00
Server2 G:  123123123   2016-02-24  07:00:00
Server3 G:  123123123   2016-02-24  07:00:00
Server1 H:  123123123   2016-02-24  07:00:00
Server2 H:  123123123   2016-02-24  07:00:00
Server3 H:  123123123   2016-02-24  07:00:00
Server1 F:  123123123   2016-02-24  12:00:00
Server2 F:  123123123   2016-02-24  12:00:00
Server3 F:  123123123   2016-02-24  12:00:00
Server1 G:  123123123   2016-02-24  12:00:00
Server2 G:  123123123   2016-02-24  12:00:00
Server3 G:  123123123   2016-02-24  12:00:00
Server1 H:  123123123   2016-02-24  12:00:00
Server2 H:  123123123   2016-02-24  12:00:00
Server3 H:  123123123   2016-02-24  12:00:00
</code></pre>

<p>I want to get the following:</p>

<pre><code>Server1 F:  freespace   2016-02-24  12:00:00
Server1 G:  freespace   2016-02-24  12:00:00
Server1 H:  freespace   2016-02-24  12:00:00
Server2 F:  freespace   2016-02-24  12:00:00
Server2 G:  freespace   2016-02-24  12:00:00
Server2 H:  freespace   2016-02-24  12:00:00
Server3 F:  freespace   2016-02-24  12:00:00
Server3 G:  freespace   2016-02-24  12:00:00
Server3 H:  freespace   2016-02-24  12:00:00
</code></pre>

<p>So basically:</p>

<p>I want the latest entry per disk, per server.
So all the latest updates on the disks of server 1, server 2 and server 3</p>