/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

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
Answered 07/21/2011 by: rmeyer
Second Degree Blue Belt

Please log in to comment
0
Take a look at the USER_HISTORY table.

I think it has the information that your looking for.
Answered 07/21/2011 by: dchristian
Red Belt

Please log in to comment
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'
Answered 09/22/2011 by: afzal
Fourth Degree Green Belt

Please log in to comment