VERIFIED SOLUTION i
X

How to retrieve plans from deleted users in Sagent

UPDATED: November 21, 2017


To retrieve plans from deleted users in Sagent, try following steps:
  • Execute query: Select DISTINCT update_user from sarp_plan;
  • If the deleted username is found, then execute query: select DISTINCT OBJECT_NAME from sarp_plan where update_user = 'USERNAME Found from Step 2';

(If we get the deleted  user name in select DISTINCT update_user from sarp_plan, then we can use the other query to get plans created by that user using query: select DISTINCT OBJECT_NAME from sarp_plan where update_user = 'USERNAME'

Before deleting any user(s), take care of the following:
  • Always create backups Sagent database repositories.
  • Publish (assign) plan(s) from user being deleted to other users or groups within Sagent admin.

Environment Details


 

Downloads

  • No Downloads