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:
Cancel
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.
Please log in to comment

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.
Please log in to comment

Answers

Answer this question or Comment on this question for clarity
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share