Adding Multiple user to Group in FIM portal

"YOU Can get what you want if you help enough other people to get what they Want".

The Powershell way of doing thing,Feel Free to Tweak it as per your need

__Powershell : Update Database.

When you working  as IT PRO you will not have all application installed in production servers and have some limitation in installing the application, Guess what will happen when you asked to  update 10000 or 2000 records in SQL database and you have to  update the correct value each time in table.I have spent couple of sleep less night in updating SQL table, So here is a power shell way of updating the  table. It will take 10 to 15 min to execute it and finish your work and landed home safely on time.

1. Save the input file in CSV (comma delimited)

2. Lets your  Select Query looks like

Select EmpNO,Name,Lastname,Department,Roles,Country from Employee

3.Import the CSV in  Blue Shell

4. Next Steps is the use of Pipe Line

5. Check your SQL txt in your profile and update the database.

I am done with my Blue Shell todays, Time to sleep.  Have a FUN Friday, Weekend is gona started soon Cheers

New series : HOW to create new attribute for user in FIM Portal

The below is the Link : Hope it will help you in creating new attribute in Portal.

New series : HOW to create new attribute for user in FIM Portal

Stop Wishing.Start Doing

Unable to RUN ManagementAgent

I hit the Error message,Unable to RUN Management Agent.

To solve this you have to Refresh the Schema of the Management Agent with correct password

System.Management.Automation : Powershell & C#

There are blogs mentioning how to add reference System.Management.Automation in your C# code, But all system are not properly configured. I found the DLL  System.Management.Automation  in C:\Windows\winsxs\msil_system.management.automation_

Just you stuck in finding your DLL this may be the folder you have to look in
C:\Windows\winsxs\msil_system.management.automation_

Reference Blog :
http://blogs.msdn.com/b/saveenr/archive/2010/03/08/how-to-create-a-powershell-2-0-module-and-cmdlet-with-visual-studio-2010-screencast-included.aspx
http://www.cibengineering.com/blog/system-management-automation/
http://www.codeproject.com/Articles/18229/How-to-run-PowerShell-scripts-from-C

Happy Weekend, I am done with my Learning Today.

Self-Improvement: The First Step – Write down your weaknesses.

Powershell June 7th Meet Microsoft Bangalore

Synchronization Rule

The strategy of group creation in AD can be defined in Sync Rule, It is very important to know how to customize the DN so the group can be sync to respective OU in AD.

FIM Administrator can customize the DN in Outbound Sync Rule, so the group can be create to respective OU in AD.

For example.

IIF(Eq(groupLocation,"Bangalore"),"CN="+mailNickname+",OU=Groups,OU=Bangalore,DC=XXX,DC=com",IIF(Eq(groupLocation,"Pune"),"CN="+ mailNickname +",OU=Groups,OU=Pune,DC=XXX,DC=com",Null())) àDN