User Defined Collection data is not being purged (4225899)

WORKAROUND

Run the groovy script below in the system to clear stale objects that are X days old.

Set the staleAge to equal the number of days before a Topology object is considered stale.

Set the typeName to the rule scope. Knowledgebase article 4289884 describes how to determine the rule scope for a User Defined Collection.

• Update the typeName field to include the name of the Topology Object to remove (for example if the UDC name is GetSQLServerLogins, then the typename would be def typeName = "DBSS_Cust_GetSQLServerLogins";

def typeName = "DBSS_Cust_GetSQLServerLogins";
def staleAge = 1;
def force = "force";

def dataSvc = server.get("DataService");
def topSvc = server.get("TopologyService");
def objects = server.get("QueryService").queryTopologyObjects(typeName);
println(objects);
def staleTime = System.currentTimeMillis() - (staleAge * 60 * 60 * 1000L);
def staleObjects = [];
objects.each({ if (it.lastUpdated.time < staleTime) staleObjects << it });
println(staleObjects);
def output = new StringBuilder();
output.append("Stale objects:\n");
for (obj in staleObjects) {
	output.append(obj.longName).append('\t');
	output.append(obj.lastUpdated).append('\t')
	output.append('\n');
}

// Delete the objects if force is given
if (force=='force') {
  def batchSize = 100;
  def idx = 0;
  while (idx < staleObjects.size()) {
  	def endPos = Math.min(idx + batchSize, staleObjects.size());
	  def batch = staleObjects.subList(idx, endPos);
  	topSvc.deleteObjects(new HashSet(batch));
	  idx = endPos;
  }
  output.append("\n*** Successfully deleted " + staleObjects.size() + " stale objects. ***");
} else {
  output.append("\n*** No objects deleted (use force argument to actually delete objects) ***");
}
println(output);
return objects.size();

STATUS

Enhancement Request FOGGENERAL-I-191 has been created to add UI functionality to delete stale UDC objects. This will be reviewed by Product Management for consideration in a future release of Foglight.