We have multiple devices that Orion is pulling down the configurations for. We've had some DHCP misconfigurations identified, so I've been asked to extract the DHCP configuration on the switches and firewalls. I've thought about doing this a couple ways, and I'm not sure what would be easiest or even work:
1) parsing the Orion database and doing SQL queries for "dhcpd" string and dumping results into a file
2) automatically dumping only the latest configurations of all devices into a folder and using a PowerShell script to extract the info.
3) create a report using SWQL that looks through configs for "dhcpd" string.
Does anyone have thoughts on which would be the easier process, and do you have any guidance on the approach? Thanks
