Calculating Number of Events in the IPDB
Questions I get always seem to come in clusters...
A number of people have recently asked me how they can calculate the exact number of events stored in the enVision IPDB. You can use the lsdata command line utility to do this. To simply get the total events in the IPDB, run this command from the ..\bin folder on the appliance:
lsdata -statistics totalsOnly -time start now -devices *
If you wanted to see that broken out by individual device types, use this command:
lsdata -statistics totalsByDeviceType -time start now -devices *
You can also manipulate the output and slice and dice it by changing the -time and -devices parameters. For example, you could show all the events collected from Agentless Windows Servers during the month of July:
lsdata -statistics totalsOnly -time 20080701 20080731 -devices winevent_nic
Feel free to experiment with the lsdata command. Use the ? character as a parameter if you need help on any part of it.