Delete BusinessGroup and orphaned ASD items

[bdamian]

I've deleted a BusinessGroup which had Advance Service Blueprint Items in his list but I still seeing those items in the DataBase.

How do I purge these Items from the database?

I'm seeing the items in the "asd_resource" table on the appliance vPostgres database.

Thanks!

D.

[SeanKohler]

Deleting a Business Group doesn't remove Service Blueprints.... because you can then assign the Service Blueprint to another Business Group or Service.

You have to delete a Service Blueprint to delete a Service Blueprint.  (which is accomplished in ASD) So I guess I am a bit confused.

[bdamian]

I'm not trying to delete a service blueprint, I'm trying to delete "items" created with those advance service blueprints.

I have a custom resource created with DynamicTypes and a blueprint who provision this kind of object. So I have a user with this type of objects is his "Item" tab.

Now I delete the business group but the items remain in the database.

How do I clean the database?

Thanks,

D.

[SeanKohler]

Hmmm...

Yeah that is a real problem.

Normally you could just entitle a Disposal resource action, but the business group is not there to entitle such an action to the user, and user sees the items under "owned by Me" I guess, right?

I am not sure the best way to clean the DB.  I am trying to think of something else that might work.  Do you have the original ID of the business group?