Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Networks with DHCP Ranges Never Used Since X Time
[ Edited ]Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-03-2017 06:57 PM - edited 12-05-2017 04:30 AM
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>