This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
Smart Reporting Remedy
This scenario comes in picture when an employee leaves an organisation and Client wants all the private reports created by him to be changed to new Report developer.
Here are the queries we need to execute to change the private report ownership from 407237 (IpId) to 458689.
update Reportheader set ipowner = 458689 where ipowner = '407237'
update Reportheader set ipcreator = '458689' where ipcreator = '407237'
update accesslevel set accessgroupid = '458689' where accessgroupid = '407237'