/build/static/layout/Breadcrumb_cap_w.png

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





0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: Hobbsy 1 month ago
Red Belt
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 1 month 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 4 weeks 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