Smart Reporting - Private Report ownership Change

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    Smart Reporting



    QUESTION:

    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.


    ANSWER:


    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'

      

     

      

     

     


    Article Number:

    000155391


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles