/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


How to report in the K1000, on KInventory running time

05/07/2015 1368 views
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 -
Answer Summary:
0 Comments   [ + ] Show comments

Comments

  • This content is currently hidden from public view.
    Reason: Removed by member request For more information, visit our FAQ's.

Answer Chosen by the Author

1
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
Answered 05/12/2015 by: aragorn.2003
Red Belt

  • 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.

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