KACE (K1000) and SQL

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Lanctus

Thread Starter
Joined
Jul 20, 2017
Messages
615
Hello everyone. My company uses the Kace Systems Management Appliance, and I need a little help. SQL is not strongly in my wheelhouse.
The May 8th MS update has thrown a wrench in the works (the RDC CredSSP issue), and I need to create a report to find the machines that have not been patched by this yet (there are many and they're scattered).
I am not proficient enough to create the SQL that is required, and Kace is not user-friendly on finding machines that are NOT patched.

An example of the report I am trying to create is attached. I need guidance on how the SQL should look for what I'm needing to do. Any and all help is welcome!
 

Attachments

Xsage

Dave
Joined
Jan 8, 2016
Messages
313
Been holding off on this one, but as not one it having a go...

I know SQL, but I don't know Kace.

If you know the column names used in the table, we should be able to work it out between us.
 

Lanctus

Thread Starter
Joined
Jul 20, 2017
Messages
615
Been holding off on this one, but as not one it having a go...

I know SQL, but I don't know Kace.

If you know the column names used in the table, we should be able to work it out between us.
I very much appreciate your responding to this. I've had to move on to other projects at this point, unfortunately. Thank you anyway.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top