How to export users from FIM portal with dispaly name, domain, account name title, office Location, Manager, Employee ID, Manager id and whatever attribute its there in FIM Portal from powershell

Hi There,

How to export users from FIM portal with dispaly name, domain, account name title, office Location, Manager, Employee ID, Manager id and whatever attribute its there in FIM Portal from powershell or any method.

Even am ot able to export FIM SQl Database.

Please help on this.

Thanks very much in Advance.

Thanks

Veerappa

May 5th, 2015 1:41am

Hi,

take a lookat the Export-FIMConfig cmdlet from the FIMAutomation snapin:

https://technet.microsoft.com/en-us/library/ff394179.aspx

Example: Export-FIMConfig customConfig /Person[DisplayName=Administrator]]

You may find this PS-Module also helpful as it converts the Output to a better Format, and has some neat additional cmdlets, based on the FIMAutomation cmdlets.

https://fimpowershellmodule.codeplex.com/

/Peter

Free Windows Admin Tool Kit Click here and download it now
May 5th, 2015 3:34am

Just to add to Peter -- don't attempt to query the FIM Service Database through -T-SQL -- it is very complex and not supported
May 5th, 2015 8:52pm

Hi 

if all your attributes is synched across MV as well

you can query as select attribut1,... from mms_metaverse where condition 1....

its not recommended to interact with db directly, But only with search i havent had any complaints.

but not with fim service db though.

if you want only from portal David's methods the right one to follow.

Regards

Dhaya

Free Windows Admin Tool Kit Click here and download it now
May 19th, 2015 5:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics