Networks with DHCP Ranges Never Used Since X Time [ Edited ]

[#1]

Here a dashboard which give you the list of networks that containes DHCP ranges never used since X time.

This give you the opportunity to notice some place with no client anymore.

<form>
  <label>Networks with DHCP ranges never used</label>
    <fieldset submitButton="false">
    <input type="time" token="time">
      <label>Time</label>
      <default>
        <earliest>-6month</earliest>
        <latest>now</latest>
      </default>
    </input>
    </fieldset>
  <row>
    <panel>
      <table>      
        <search>
          <query>sourcetype=ib:dhcp:network index=ib_dhcp ranges > 0
            | stats sum(dhcp_utilization) by NETWORK | rename sum(dhcp_utilization) as DHCP_USAGE 
            | where DHCP_USAGE=0
            | table NETWORK
            | rename NETWORK as Network</query>
        </search>
        <earliest>$time.earliest$</earliest>
        <latest>$time.latest$</latest>
      </table>
    </panel>
  </row>
</form>