VERIFIED SOLUTION i
X

List of active plans in a Sagent repository

UPDATED: August 30, 2018


Use following query to find out list of active plans in a Sagent repository:
 
select object_id, object_name from sarp_plan where tombstone = 0 and staged = 0 and object_id not in (select object_id from sarp_trash);

PS: Active plans of Sagent repository means the plans which are not being marked for deletion i.e. plans which should be present in the 'plans bin' and not part of 'Recycle bin'. The result of this query excludes the staged plans (opened in Design Studio).

Downloads

  • No Downloads