IVE Reporting

[amonte1_]

I have the need to be able to generate VPN Usage reports (by user) on a Montly basis. Has anyone done anything or used anything to create reports from this box? The log filtering doesn't seem to provide (or hold) enough information. I know there are a couple of 3rd party products, like Sawmill that may work, also looking into a SIM to process/archive all of the log data.

Thanks,

Tony

[ben_]

What especially do you need, just logins and logouts or more?

The only thing I did was to hold statistics of concurrent usrs usage by realm/role or a login / logoutreport per realm/role.
The first part is just a parser, logging into the IVE Webinterface, parsing the content of the logged in userpage,
the second thing is based on syslogmessages from the IVE filtered by login + logout, read from a syslogd that writes all received messages in to a fifo from that my script reads...

[amonte1_]

Hi Ben,

Thanks for the reply. I'm looking for a report By user showing the amount of time connected to the VPN box either per Role or Realm.

TAC gave me one recommendation of using a product from nwgtechnologies. I'll probably need to check this out.

Thanks,

Tony

[ben_]

Either this or you filter syslog messages by all possible Login- / Logoutmessages and store them into a Database.

Another possibility could be to check out using a radius server for accounting?

[ssl_boy_]

Hi,

Check out a company called Sawmill, they do a nice little log processing tool which is very cost effective and gives some nice reports.

HTH

Kendal

[Kevin_]

Also look at NWG Technologies (http://www.nwgtechnologies.com/products/product2.html). They have SSL ClearView Reporter which is really excellent.