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.
Thank you.
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
rmeyer
13 years ago
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
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
Posted by:
afzal
13 years ago
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'
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.
so that the conversation will remain readable.