/build/static/layout/Breadcrumb_cap_w.png

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 -

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: aragorn.2003 9 years ago
Red Belt
1

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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