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?
Answers (2)
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"
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 8 months 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 8 months ago-
Thanks for you suggestion. - rajeshwaranm 8 months ago