List of non-empty tables in IPDB.
I understand that the data is not stored in tables – however, when it comes to report..etc, we need to pick a table. (ex; VPN Security or Web Accounting).
Any ideas on how, if at all possible to generate a list of tables which have some data in them?
I think of the IPDB tables as ephemeral. The indexing process makes this a bit untrue, but it's a useful model for working with enVision in my experience.
What is it that you wish to achieve with this list of populated "tables"? If you're trying to choose the right table for reports, that's based upon the devices you wish to query and described in the device configuration guide for each device. Hopefully you're on all the Content 2.0 parsers (hey RSA, Cisco router/switcher 2.0 parsers would be awesome *hint hint*) as that makes the table selection question much simpler.
Thanks David. We are using content 2.0 and I do refer to device config guide for specific tables names. I want to easily view all the tables which have data in them at one shot for all n+ devices types.
This is not related to a use case or business case or its a show stopper – just curious and want know if it is technically possible. Is there a way to use a command line tool or script to query single table ? if thats possible they we can script it to check for all tables……
Gotchya. I'm not aware of any means to accomplish that via a command line or scriptable tool. You may be able to kluge something together by using lsdata to test if there is data within your target time window for a given device type and then map the device type to tables, but that seems like a lot of work for something without a defined use case.
Best of luck!