Is there an alternative to the VERY EXPENSIVE auditing option

[eo]

We require timely stats on our BOExi r2 system. In the past (CE10) we used the Auditing database for this purpose. This is now licenced, and from what I hear is very expencive. I know that there is a 3rd party tool available (APOS KPI - which seemed good on paper as it will also allow us to do very valuable impact analysis) - but as yet, we have had no luck with this tool. It seems to be extremely overhead intensive, and it takes ages (so far over two days and still running) to do a single scan. I am talking to APOS directly re this, so my statements above at this stage merely initial impressions of the tool.

My question however is, does anyone know of alternatove tools that will allow us to provide such stats of BOExi r2?

EO
Hertfordshire, England

 

[ShortyA]

Hi,
I have used APOS on a couple of installations and if it is run as a service instead of an application the overheard shouldn't impact your production service. If you set your run frequency too high then it will increase but APOS will be able to recommend a suitable refresh frequency for your needs.

On both installations the data and reports have been useful to identify licencing bottlenecks and report run times. Would recommend them but driven by your bus reqs!

 

[eo]

Excuse my ignorance, but how do I run it as a service?

Just a note to add. The KPI Hours appl kicked off at 18:00 last night. The AP_Objects table contained 55608 items. It is now 11:14, and there is only 58648 records. It just seems as if it is updating the data extremely slowly.

Any advise highly appreciated.

EO
Hertfordshire, England

 

[ShortyA]

Two things pop up here. Firstly, from what I remember of the KPI product when you run it from the Start Menu there is an option to Install KPI as an application and one to run as a service. I don't have a copy of the user guide to hand at the moment but it definitely can be run as a service and thus with lower overhead (perhaps with a command line switch). The only time I have run it as an application is to do troubleshooting when you can see exactly what the application is collating ie which part it is having trouble on.

The second is that to troubleshoot why it is having problems I believe that in the ini file there is an option to turn on debugging. Stop the application, set the ini file to allow debugging and then start the appl again for 5-10 mins, stop it and check debug log.

Another way to move this forward is perhaps to look at all of the KPI table counts to see if they are all growing slowly.

hope this helps.

ShortyA