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

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.

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
Answer this question or Comment on this question for clarity