/build/static/layout/Breadcrumb_cap_w.png

What table shows the Patch Status of the computer on the K1000

I am looking to create a smart label for computers where their patch status is "Waiting on Demand Deploy" and "Snoozed".  Anyone know what table on the K`1000 records this status?


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: JordanNolan 1 month ago
10th Degree Black Belt
1

Top Answer

I thought those would be it too, but those are for the status of the patches themselves.  I happened to have a call with a Quest agent about another issue and they were able to tell me that the table is:

PATCH_SCHEDULE_RUN_MACHINE

Now that I found this, I made a Smart Label with the query below.  I had setup patching so it deploys and stages and forces installs after 7 days.  So now I could prompt them daily about applying their patchs:

--------------

Select

    MACHINE.NAME As SYSTEM_NAME,

    MACHINE.SYSTEM_DESCRIPTION,

    MACHINE.IP,

    MACHINE.MAC,

    MACHINE.ID As TOPIC_ID

From

    MACHINE Inner Join

    PATCH_SCHEDULE_RUN_MACHINE On PATCH_SCHEDULE_RUN_MACHINE.MACHINE_ID = MACHINE.ID

Where

    PATCH_SCHEDULE_RUN_MACHINE.STATUS = "waiting on-demand deploy"

Posted by: AmberSDNB 1 month ago
Orange Belt
0

I don't use Kace for patching to confirm the data, but I'm guessing either PATCH_MACHINE_STATUS or PATCH_STATUS when I check MySQL.


Comments:
  • May I know how did you check your MYSQL to ensure that PATCH_MACHINE_STATUS or PATCH_STATUS ? - rajeshwaranm 1 month ago
    • You can connect to the Kace SMA using ODBC or with a SQL tool like FlySpeed SQL. To enable access to the ODBC you can follow this article:

      https://support.quest.com/kb/4276308/can-i-access-the-sma-s-database-using-a-third-party-reporting-tool

      I like using FlySpeed because it gives you the ability to build the SQL visually and produces the SQL statement in the native SQL language.

      It took a little poking around before I found PATCH_SCHEDULE_RUN_MACHINE. The table does not have many fields so it was easy to tell this was the table I needed once I located it. - JordanNolan 1 month 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