How to clean up IT Shop programmatically

One option would be to execute the method RemoveFromITShop for each ADSGroup you want to remove from the shop.

Markus,

Ok i will try that.

I'm thinking of creating a process orch with a step to run the method against any adsgroup without $ObjetKeyManager. I can make it a Process Automation without a schedule and just run it once.

Any other ideas on how to run that automation? I'm unable to select multiple in object browser to run the method. It just allows me to run one at a time.

Thanks for the guidance. Lu

You can generate the HandleObject.CallMethod tasks in the job queue for your groups with the following SQL. Just replace 1=0 with a proper where-clause that covers your AD Groups.

Declare @procid varchar(38)
select @procid= newid()
Declare @objkeys dbo.QBM_YParameterList
 
 
-- HandleObject.CallMethod
exec dbo.QBM_PJobCreate_HOCallMethod 'ADSGroup','1=0',0,'RemoveFromITShop', @GenProcID=@procid, @ObjectKeysAffected=@objkeys

You can generate the HandleObject.CallMethod tasks in the job queue for your groups with the following SQL. Just replace 1=0 with a proper where-clause that covers your AD Groups.

Declare @procid varchar(38)
select @procid= newid()
Declare @objkeys dbo.QBM_YParameterList
 
 
-- HandleObject.CallMethod
exec dbo.QBM_PJobCreate_HOCallMethod 'ADSGroup','1=0',0,'RemoveFromITShop', @GenProcID=@procid, @ObjectKeysAffected=@objkeys

That's awesome thanks so much! I will give this a try.