/build/static/layout/Breadcrumb_cap_w.png

Software Library Download Logs

Is there anyway to be able to view who has downloaded what software from the Software Library? And if so, can a report be generated for that information?

Thank you.

0 Comments   [ + ] Show comments

Answers (3)

Posted by: rmeyer 13 years ago
Second Degree Blue Belt
0
It is in the database somewhere, because you can see what each person have downloaded/installed via the software portal

You can see all downloaded/installed via software portal here: http://kbox/adminui/kbot_run_list.php if you don't clean it up and search on it, but you should be able to create a report since it's in the DB
Posted by: dchristian 13 years ago
Red Belt
0
Take a look at the USER_HISTORY table.

I think it has the information that your looking for.
Posted by: afzal 13 years ago
Fourth Degree Green Belt
0
You can user the following SQL , but it may duplicate some recoreds if user has clicked 'Download' or 'Install' Button multiple times. because it is 'Portal Request Logs'

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'
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ