SCSM Review Activity Comments

Question

We have a user who approved a Review Activity through email and the user used a smiley face when they approved. The SQL DBs did not like the smiley face and we keep having warnings on the server because of this. I found the basemanagedentityid for the RA. My question is does anyone have a SQL Query that I can run so I can access the approval comments section and delete the smiley that was used so we stop getting these warnings in event viewer?

Thank you in advance,
Zach

Answer 1

Hi @Zach Flesher ,

it's not the best way and not supported to modify the details directly in the SCSM database.

A better option might be to use PowerShell and the SMlets to get the job done.
In this blog post you will find details to get the object: https://lazywinadmin.com/2016/03/powershellscsm-get-review-activities.html

With a little work it should be possible to get this modified to your requirements -> Modifying the comment of the review.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Hi @Andreas Baumgarten ,

I have already modified the comments directly from the RA activity we think is the affected ticket. But we are still having a warning regarding the ticket on the SQL server.

Thank you for the help.

Zach

Answer 3

Hi @Zach Flesher ,

if the reviewer voted and put a smily in the "vote comment" this is not stored in the comment of the Review Activity object.
The vote decision and the comment are stored in the Reviewer object which is related to the Review Activity class and to the User class (the reviewing user) .

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten