Reporting shared networks DHCP utilization

[#1]

Hello guys,

I'm currently working on Infoblox reporting system. Do you know if it's possible to get easily the DHCP utilization for each shared network ? The goal is to send an alert when the DHCP utilization for the shared network is higher than 90%.

For the moment, I have this search where I manually insert the networks included inside the shared network:

sourcetype = ib:dhcp:network index = ib_dhcp address=172.24.91.0 OR address=172.24.35.0 | timechart avg(dhcp_utilization) BY address

Thanks a lot, 

Have a nice day,