Delete Users in Bulk

Post Reply
yyround
Posts: 27
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: PA2.0.8
Excel Version: MS 2016

Delete Users in Bulk

Post by yyround »

Hi guys,

any one know of a way to delete users in bulk?

I noticed that about 30 users have left our department and would like to remove them from the system, is there a quick way for me to delete them in bulk? does it have to be done through a TI? If yes, can I ask for a copy of the code?

Thanks in advance.

Gaby
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Delete Users in Bulk

Post by Alan Kirk »

yyround wrote:Hi guys,

any one know of a way to delete users in bulk?

I noticed that about 30 users have left our department and would like to remove them from the system, is there a quick way for me to delete them in bulk? does it have to be done through a TI? If yes, can I ask for a copy of the code?

Thanks in advance.

Gaby
1/ Save the list of users as a plain text file;
2/ Specify that file as the data source;
3/ Use the DeleteClient(ClientName); function in the Metadata tab.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Delete Users in Bulk

Post by TrevorGoss »

Alan Kirk wrote:
yyround wrote:Hi guys,

any one know of a way to delete users in bulk?

I noticed that about 30 users have left our department and would like to remove them from the system, is there a quick way for me to delete them in bulk? does it have to be done through a TI? If yes, can I ask for a copy of the code?

Thanks in advance.

Gaby
1/ Save the list of users as a plain text file;
2/ Specify that file as the data source;
3/ Use the DeleteClient(ClientName); function in the Metadata tab.
Alan's solution will work, but if you are authenticating via BI, it is possible for the deleted clients to "come back" so to speak, simply by logging back into the TM1 service. Provided they have the credentials (AD, for example) of course.
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Delete Users in Bulk

Post by qml »

TrevorGoss wrote:Alan's solution will work, but if you are authenticating via BI, it is possible for the deleted clients to "come back" so to speak, simply by logging back into the TM1 service. Provided they have the credentials (AD, for example) of course.
This behaviour can be easily prevented by using a config parameter available from version 10.2.2 FP5 onwards.
Kamil Arendt
yyround
Posts: 27
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: PA2.0.8
Excel Version: MS 2016

Re: Delete Users in Bulk

Post by yyround »

Thank you so much all :)
Post Reply