KACE Product Support

We are using Kbox Software Library for the installation of some software packages, we have created and shared the single user account for this purpose. LDAP login not configured due to various reasons.
We have noticed that Portal install logs still able to show the actual User name who is installing the software from Portal. We were using the following Sql to get the Software installation Report periodically.

Select
KBR.Start_Time 'Time',
MACHINE.Name 'Machine Name',
MACHINE.IP 'Machine IP',
KB.Name 'Package Name',
MACHINE.User 'User ID'
from KBOT KB
join KBOT_RUN KBR
on
KBR.KBOT_ID=KB.ID
join KBOT_RUN_MACHINE KBRM
on
KBRM.KBOT_RUN_ID=KBR.ID
join MACHINE MACHINE
on
MACHINE.ID=KBRM.Machine_ID
where KBR.Description ='portal request' and Date(KBR.Start_Time) between '2010-04-01' and '2011-12-31'

However after some time we have noticed that this is not accurate because some time user clicks the 'Install' button multiple time or sometime installation fails due to some resons but these logs still shows the installation.
Just a quick thought, Is there any relation between the database tables so we can integrate the portal request logs with computer History information and fetch the only successful software installation report.

Thanks ,