Need to generate a report for servers where VMware Tools patching has failed in KACE SMA
I’m new to Kace and also this forum. Currently, I’m looking for instructions on how to generate a report for VMware Tools patching that has failed on all servers in Kace SMA. Could anyone kindly advise me on how to generate that report, please? I think I will need enter the sql query to generate the report as shown in the screen shot below ,please help me to get that
Answers (1)
Top Answer
This is not as simple as you thin it might be, so first let us try to establish exactly what you want in your report?
You will clearly have some patch updates relating to VMWare
You will clearly have some Windows servers that need to get those patches and
You will have patch schedules that are needed to push the patches to the servers
This means that there are a fair few number of SQL tables that will be involved in the report.
But what exactly do you need the report to tell you???
Do you want to know, by patch, which servers have the patch and those that do not?
Do you want to know which servers have had the patches deployed to theme and the schedule has failed?
I guess we also need to know about your patch deployment schedules as well to understand how to build the report.........
Please share with us more information and we will try to help
Comments:
-
I want the report to tell me which servers have VMware Tools installed. I would like to generate an SQL query to pull that information from KACE SMA. - rajeshwaranm 9 months ago
-
I found my answer from following post https://www.itninja.com/question/kace-sql-customized-report-add-agent-connection-date-and-time
SELECT MACHINE.NAME AS SYSTEM_NAME,
MACHINE.IP,
SOFTWARE.DISPLAY_NAME,
SOFTWARE.DISPLAY_VERSION
FROM ORG1.MACHINE
JOIN ORG1.MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID)
JOIN ORG1.SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID)
WHERE SOFTWARE.DISPLAY_NAME LIKE '%VMware Tools%'
ORDER BY SYSTEM_NAME; - rajeshwaranm 9 months ago
