Hi Lukasz,

Great meeting you last week! I am going to CC both the AR System and ITSM Communities since this Developer Community is still pretty new and there are a lot of experts watching those other places.

CC: Remedy AR System and Remedy ITSM

If doing things 'outside' of the application....yea....will need an application method to update the cache....so....would an arcache run be in order?  Drop the existing cache and re-populate it from the data as it exists after you manually manipulate?  How many records are we talking about here?

Maybe making the changes at the DB level aren't the best option?

I was thinking the same thing.

Since you have a query to find the people/permissions maybe export that data from the DB and come up with an AR import process that will trigger workflow.

Or even the Import tool. You could create a new "import" form with some logic to manipulate data, perform duplicate checks, etc. that you import into. Then have a filters that does a Push Fields into the ITSM forms you were planning on updating via SQL.

Funny, that's exactly what I suggested offline