(imported topic written by dgibson91)
Is there any way to copy all private reports and filters from one user to another? Some users want to start using their AD accounts to login, but don’t want to recreate all their reports and filters. I would settle for some way to export the reports and filters.
(imported comment written by dgibson91)
I managed to move reports, emails, filters, and favorites from BES Users to AD Users by editing the SQL tables directly.
I made a stored procedure to execute the changes. The tables are modified so it looks like the new user created the reports and filters. After executing this, the old user should have on reports.
WARNING: This is a quick and dirty solution and contains no error checking. Use at your own risk.
USE [BESReporting] GO CREATE procedure [dbo].[MoveLocalToAD] @OldUserName nvarchar(128), @NewUserName nvarchar(128) as begin DECLARE @OldUserID uniqueidentifier DECLARE @NewUserID uniqueidentifier select @OldUserID = UserID from users where LoginName = @OldUserName select @NewUserID = UserID from USER_NAMES where DisplayName = @NewUserName Print @OldUserID Print @NewUserID Update WebReports Set Creator = @NewUserID WHERE Creator = @OldUserID Update WebReports Set LastEditedBy = @NewUserID WHERE LastEditedBy = @OldUserID UPDATE USER_EMAILS SET UserID = @NewUserID where UserID = @OldUserID UPDATE SAVED_FILTERS SET CreatorID = @NewUserID where CreatorID = @OldUserID UPDATE SAVED_COLUMN_HEADINGS_FILTERS SET Username = @NewUserName where Username = @OldUserName UPDATE FAVORITE_WEBREPORTS SET UserID = @NewUserID where UserID = @OldUserID end
Parameters should look like this when you call the procedure.
exec MoveLocalToAD
'oldaccount',
'ADACCOUNT'