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.
Dan
IMAGE 1
IMAGE 2
Answers (1)
Top Answer
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.
