Do you know how to export Roboserver KCU usage ?

I am trying to export for reporting purpose the Roboserver KCU usage. Currently, it is shown in the management console.
Is it possible to extract the data onto a spreadsheet?

Where in the database you can find the information?

In addition, I am trying to get the KCU usage of each Robots. Does this equation make sense kcupoints/executiontime / 5000

Since 1KCU=5000 points

Please advise

Thanks

During installation, logging databases were created.  Robot execution logs are in ROBOT_RUN database. 
From the documenation included with Kofax RPA:

"You can set up the retention policy for your logs in the RoboServer Log Database by specifying a number of days to keep the logs and a number of messages in the robot run. The logs are cleaned on a daily basis by deleting the oldest messages first. The default values are 10 days and 500 messages." 

We keep our logs for quite a long period of time in order to view trends over time and watch for potential issues.

Statistics include:

RUN ID
HOST
EXECUTIONTIME
HOSTADDRESS
EXECUTIONID
WARNINGCOUNT
ERRORCOUNT
CLIENTADDRESS
EXTRACTEDOBJECTS
ENDTIME
CLIENTHOST
ROBOTNAME
STARTTIME
INPUTOBJECTS
INPUTOBJECTSTRING
QUEUETIME
INFOCOUNT
PROJECTNAME
TOTALTIME
STARTREQUESTEDTIME
BYTES
EMAILS
HTTPREQUESTS
JSINSTRUCTIONS
KCUPOINTS
KCUWAIT
STEPS

Hi Jking

I was able to get the from the DB the roboname, startime, totaltime, kcupoint, kcuwaits....
I want the formula that calculates the roboserver KCU usage per day, hour, minutes....etc
I am looking forward to get more detailed information than what management console dashboard gives


If you look at the above image. At some point in time Roboserver used 5 KCU. I need the breakdown of that information. 
What robot or robots run used the KCU, when? How long?

Thanks

You can query all of the data you need from the ROBOT_RUN database.

Yes I agree with you. But the Robot_Run database does not show KCU usage. 
The Robot_Run database lists only KCUPOINT.
Do you think this formula is correct

Average KCU = Kcupoint /Execution Time / 5000

Formula should divide by 5, not 5000 to get Average KCU

Average KCU = Kcupoint /Execution Time / 5

1KCU=5000 points
So if I understand because execution time is in milliseconds you divided in by 5 instead of 5000?
Does this mean the value of Average KCU will be per seconds?

If I am wrong please explain where did the 5 come from.