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
Delete Users in Bulk
- 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
1/ Save the list of users as a plain text file;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
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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.Alan Kirk wrote:1/ Save the list of users as a plain text file;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
2/ Specify that file as the data source;
3/ Use the DeleteClient(ClientName); function in the Metadata tab.
- 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
This behaviour can be easily prevented by using a config parameter available from version 10.2.2 FP5 onwards.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.
Kamil Arendt
-
- 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
Thank you so much all