Need to Bulk Update Email Addresses in 7.0

Question

Is there or what is the best way to bulk change Email Addresses from @prod.com to @test.com in Identity Manager 7.0 system?

Barry Jackson · Answer

Hi, 
 Well it depends on what sets the email address in the first place.... 
 
 If the value is calculated using a template (value calculation) then the template would need to be changed and then recalculated for all objects 
 If it is a static value that is set from some input (e.g. HR feed) the it needs to be changed in that feed and the feed re-applied 
 If it is a static value that is set on Person some other way and just needs to be changed then you could use DataImporter to update the values 
 
 HTH, Barry.

Barry Jackson · Answer

Hi Blane, 
 Well honestly DataImporter is way easier but if you want to do it from the SQL console then 'exec dbo.QBM_PJobCreate_HOUpdate ' is the V7/V8 equivalent. 
 HTH, Barry.

Barry Jackson · Answer

Here you go: Declare @procid varchar(38) select @procid= newid() Declare @objkeys dbo.QBM_YParameterList -- Update exec dbo.QBM_PJobCreate_HOUpdate 'ADSAccount','isnull(UID_Person,'''') <> '''' AND isnull(UID_TSBAccountDef,'''') <> '''' And isGroupAccount=0 ',@GenProcID=@procid,@ObjectKeysAffected=@objkeys, @p1='IsGroupAccount',@v1=1