How to report in the K1000, on KInventory running time
Please help:
I have been noticing that some of our clients are having slowness issues we suspect may be related to the "inventory.exe" run time. In order to investigate the significance of such concerns, I want to be able to monitor a device agent log value found in a pop-up window from the " *** Upload SAM Catalog Data *** (bottom of page of any machine details - [http://k1000/adminui/machine.php?ID=01]). The specific value of concern is the "Elapsed Time:" value.
Can anyone help me with how I can report on this for our K1000 clients. Normal clients seem to complete this operation in 100-200 seconds. I am noticing some running more like 20 mins occasionally (1200+ seconds).
Thanks for all assistance in advance!
- Tom -
I have been noticing that some of our clients are having slowness issues we suspect may be related to the "inventory.exe" run time. In order to investigate the significance of such concerns, I want to be able to monitor a device agent log value found in a pop-up window from the " *** Upload SAM Catalog Data *** (bottom of page of any machine details - [http://k1000/adminui/machine.php?ID=01]). The specific value of concern is the "Elapsed Time:" value.
Can anyone help me with how I can report on this for our K1000 clients. Normal clients seem to complete this operation in 100-200 seconds. I am noticing some running more like 20 mins occasionally (1200+ seconds).
Thanks for all assistance in advance!
- Tom -
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
aragorn.2003
9 years ago
Top Answer
Did you mean such a SQL report?
select k.NAME, m.NAME, m.IP, m.USER_FULLNAME, kl.START_TIME, kl.STOP_TIME, TIME_TO_SEC(TIMEDIFF(kl.STOP_TIME, kl.START_TIME)) as DiffTimeInSec
from KBOT as k, KBOT_LOG as kl, MACHINE as m
where k.ID = kl.KBOT_ID
and kl.MACHINE_ID = m.ID
and k.NAME like '%Inventory%'
order by kl.START_TIME DESC
Comments:
-
Thanks aragorn.2003.
Yes, a SQL report works and I was able to run exactly what you provided and am now easily able to find items which might be of concern (slow). Your response was a big help and much appreciated. - TDelaney 9 years ago