Service Catalog Archive/Purge

Idea created by andrew_foster on Jul 6, 2017
    Under review
    • Francois Auvray
    • myfsu01
    • BenParish
    • andrew_foster
    • MartinM
    • viniciushaddad
    • Remy Jobin
    • Nadeem_Ather
    • josetorresv

    For Service Catalog, please add a GUI function to call Archive/Purge parameters.  Doing this via a Stored Procedure is a functional work around, but other CA Products have Archiving/Purge built-in to the GUI.  With a high number of Requests comes an extremely large usm_system_change_detail.  Also, please analyze current index's on usm tables affected by archive/purge.  We have had to add 4 indexes that make the procedure 1000% faster.