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 ,
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

Answer this question or Comment on this question for clarity