Need help using parameters in the update sql of a Kace Rule

I am hoping you can point me in the right direction.

I am needing a little assistance with the following Rule Query.

In image 1 we are selecting records and in image 2 we update the filed based on that query.

But I want to update a field using a returned value from the select query (instead of hardcoding them) and I cannot get them to the update query.

Can you help or point me to someone who can?

Thanks a million, in advance.










0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: Nico_K 3 weeks ago
Red Belt

I think you mean a custom field in the service desk?
If yes, you should review this article: https://support.quest.com/kb/4291788 it describes how to use a mysql-Query to populate the custom fields with stuff which is in the DB already.

If you mean other fields, please be more specific.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


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