A method for analyzing and reporting gateway configurations and rules includes receiving configuration data from gateway devices providing access to an enterprise network. The gateway devices may be associated with multiple vendors. At least one computer processor parses the configuration information associated with each of the gateway devices to identify configuration output data for each of the gateway devices. The configuration output data for each of the gateway devices is stored in a single data structure. The configuration output data stored in the single data structure is indexed to generate one or more optimized data tables.