Export Spotfire user list

TIBCO Spotfire Community » TIBCO Spotfire » TIBCO Spotfire Administration » Export Spotfire user list

Last post Fri, Jul 15 2011 3:46 AM by tpetkantchin. 7 replies.

Page 1 of 1 (8 items)
	Sort Posts: Previous Next

Wed, Jun 30 2010 6:18 AM

VladimirB
Joined on Wed, Jun 30 2010
Posts 5

Export Spotfire user list

Reply Contact

Is there a way to export the user list from the administrator console in Spotfire? Either on the web interface or the client the user list is and image and cannot be even copied and pasted.

Thu, Jul 1 2010 7:56 AM In reply to

EranS
Joined on Mon, Oct 12 2009
Israel
Posts 355

Re: Export Spotfire user list

Reply Contact

Hi Vladimir,

I am not aware of an application method to export users and groups.

But, you can query the repository DB (Oracle or SQL).

In the schema created for spotfire administration you can find tables: USERS, GROUPS and GROUP_MEMBERS.

SQL these 3 or a combination to find out who is registered and to which groups.

Best Regards,

Eran

Thu, Jul 1 2010 8:04 AM In reply to

VladimirB
Joined on Wed, Jun 30 2010
Posts 5

Re: Export Spotfire user list

Reply Contact

Thans Eran, I'm aware of the DB tables, but unfortunately, due to how our IT is organized, I have no access to them. I guess I will have to request the info to the IT support team.

Tue, Jul 27 2010 7:05 AM In reply to

jens
Joined on Wed, Jul 14 2010
Gothenburg, Sweden
Posts 57

Re: Export Spotfire user list

Reply Contact

Hi,

There is actually a way of exporting a list of users - using the old DecisionSite Administrator that is still available in TIBCO Spotfire Server 3.2. Just go to http<s>://<spotfire server>:<port>/spotfire/administrator and select the Users tab.

Please note that the DecisionSite Administrator is considered deprecated, lacks some functionality and will be removed in a future release.

Best Regards,
Jens

Tue, Jul 27 2010 8:26 AM In reply to

VladimirB
Joined on Wed, Jun 30 2010
Posts 5

Re: Export Spotfire user list

Reply Contact

Thanks Jens, it works perfectly.

I hope they include this in the standard admin console before they remove DecisionSite.

Thu, Jul 29 2010 6:04 AM In reply to

Christof
Joined on Mon, Feb 18 2008
Germany
Posts 1,081

Re: Export Spotfire user list

Reply Contact

Pleae submit this to our support (http://support.tibco.com) as enhancement request.

Thanks,

Christof

-----------------------------------
Dr. Christof Gaenzler
Sr Solutions Consultant
TIBCO Spotfire

Mon, May 9 2011 6:06 AM In reply to

jens
Joined on Wed, Jul 14 2010
Gothenburg, Sweden
Posts 57

Re: Export Spotfire user list

Reply Contact

An enhanced version of this feature is now included in the Administration Manager in TIBCO Spotfire 3.3 (when running against a TIBCO Spotfire Server 3.3).

Filed under: Administration Manager, import users

Fri, Jul 15 2011 3:46 AM In reply to

tpetkantchin
Joined on Mon, Mar 14 2011
Posts 8

Re: Export Spotfire user list

Reply Contact

For the list of users I go to the Spotfire DB and I use

SELECT
USER_NAME
FROM         dbo.USERS INNER JOIN
                      dbo.GROUP_MEMBERS ON dbo.USERS.USER_ID = dbo.GROUP_MEMBERS.MEMBER_USER_ID INNER JOIN
                      dbo.GROUPS ON dbo.GROUP_MEMBERS.GROUP_ID = dbo.GROUPS.GROUP_ID
GROUP BY
USER_NAME

Page 1 of 1 (8 items)

Spotfire's interactive information visualization and analytic solutions give users a remarkable experience for quickly and easily querying data and reporting results for superior business intelligence. From portfolio management and customer retention programs to key processes such as CRM, marketing, research, bioinformatics, yield and asset management and design for manufacturing, enterprises around the world rely on Spotfire's business analytics software to improve operational performance.