Delete a bunch of user accounts

security CMC
1

Hello,

At some point, we imported some SAP roles which contain thousands of users. We have about 3,500 user accounts in BO. But of those, about 2,700 have never logged on, and I would like to delete these 2,700 accounts.

If I have the list of users (derived from Query Builder), is there a way to script/batch the deletion of these accounts? Or any other clever suggestions?

BO 4.1 SP3. SAP and AD authentications enabled.

Thanks!
mike

mikefraser :us: (BOB member since 2008-05-12)

2

You could do it with the SDK. SAP has examples on how to retrieve Users and work with them. You already have the query to get the Users you want so you can just plug that in and iterate through them.

I would suggest going on the cautious side and adding them to a User Group rather than deleting them. You could then export the group to a BIAR file for a backup. I’d deny logon permissions to the group and then delete after 2-4 weeks. That way you catch anybody that was accidentally thrown in the group and you don’t have to restore them.

ChrisW1204 :us: (BOB member since 2011-04-21)

3

I would love to use the SDK for this. But I don’t know the first thing about the SDK or how it is installed/configured, and I’ve not been able to find any documentation for complete noobs. Can somebody please point me in the right direction? Thanks!

mikefraser :us: (BOB member since 2008-05-12)

4

The “SDK” forum has alot of that information in the Sticky posts. The samples from SAP do most of what I suggested.

ChrisW1204 :us: (BOB member since 2011-04-21)

5

I’ve just deleted c10k users by using the bulk upload tool.

In CMC - USers & Groups - Manage - Import user group.

List all of your users in a csv file with the data items as follows

Group name (of your choice and identifiable as those requiring deletion i.e. ‘Deletions’)
User ID
Full Name
Password

This functionality is usually to create users but if they already exists it simply adds them to the group you have specified and disables them.
Once this is done, you can go the the group, select multiple users, right click and delete. Then they are gone altogether.

Hope that helps.

We are using BOXI 4.0 and about to go to 4.1 so I’m assuming this will be the same.

Lynnieshell :uk: (BOB member since 2012-09-18)