#1 2011-01-12 09:36:10

**_boraunal_**

Export Users

Hi All,

As far as I know there is no way to export the users defined in a Connect server. Do you know any workaround for this problem?

Best,

**_Purnima_**

Re: Export Users

There is a way to get list of all the users for an account . You will get the list in form of XML. Use the XML API  http://[server name]/api/xml?action=principal-list.

This is not the neatest solution, but you will get the list of users with their email address and login id.

**_Laseru_**

Re: Export Users

You can run this query against the database to export the list of users that have active accounts but also they have activity in 2011. Don't know why but the editing is not saved, before the first "from" should be a space
------------------------------------------------------------------------------------------------------------------------------
select breeze
GO

select distinct [first_name], [last_name], [login], [email]from
(
select * from REPORTING_DIM_USERS where [disabled] is null and [most_recent_session] is not null
union all
     select u.* from
                    (
                      select dim_users_user_id, max(date_activity_finished) as date_activity_finished from [reporting_dim_activity_details] where DATEPART(year,[date_activity_finished])=2011
group by dim_users_user_id
                     )
     as tmp

     inner join REPORTING_DIM_USERS U on tmp.dim_users_user_id = u.user_id
)

as toate where [disabled] is null

---------------------------------------------------------

Last edited by **_Laseru_** (2011-03-02 23:05:07)