= Dhcp Reservations =
Todo: Implement sorting capabilities in the App.

== 2015-09-20 ==
Added a view to the DB so that we can sort on the IP address easily:

{{{#!highlight sql
CREATE VIEW IpPoolABCD AS
SELECT *, CAST(PARSENAME(IpAddress,4) AS INT) AS A,
          CAST(PARSENAME(IpAddress,3) AS INT) AS B,
          CAST(PARSENAME(IpAddress,2) AS INT) AS C,
          CAST(PARSENAME(IpAddress,1) AS INT) AS D
FROM IpPool
}}}
To sort via the IP address now do the following:

{{{#!highlight sql
SELECT IpAddress, Reserved
FROM IpPoolABCD
ORDER BY A, B, C, D
}}}