/build/static/layout/Breadcrumb_cap_w.png

k1000 database tables

Hello all,


I am trying to learn how to create reports for scripting. 

we have some scripts that runs on schedule and some time we manually run them from "run now".

Management would like to know which computers received these scripts. 


I talked to kace support today and couldn't get all my answers. 

so the question is ; I learn some scripts results are kept in kbot and kbot_logs tables specially if they are scheduled scripts. If so where are the tables for run now (on demand) script tables? 


thanks in advance.


Asked 9 months ago 0 views
0 Comments   [ + ] Show comments

Answers (2)

Posted by: jencam 9 months ago
Orange Belt
0

Thanks for your reply. 

found out these tables are used for run-on-demand records "MACHINE, KBOT, KBOT_RUN, KBOT_RUN_MACHINE "

Comments:
  • Now we know that, what reports do you need to build? - Hobbsy 9 months ago
    • thank for your reply. I was able to create my reports. - jencam 9 months ago
Posted by: Hobbsy 9 months ago
Red Belt
-1

If KACE support are struggling….

so from what I can see the run now scripts are also stored in the KBOT_LOG table. For reporting you can link to the KBOT table to get the Name and to the MACHINE table to get the device names.

so you should be able to pull a report that says what run now scripts were run on devices at what times.

 
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