Monday 23 June 2014

FIM Error 1068 :the dependency service or group failed to start.


It is simple as the name suggests the dependency service is not started; You have to start all the dependency service first before you starting your FIMSynchronizationService.


Do not start any services by trial and error method process, as I tried to figured out what is wrong in my LAB.







 Know all of your dependency service password,If not take the help of SQL Admin to know the password of the SQL services
.
Find the service you can't start in services.msc, right click and open properties. Go to dependency and make sure all those are started. 99% of the time one of those services hasn't started.

Cheers.. !!!, I was able to start my FIMSynchronizationService.


Happy Troubleshooting and Good Night

Saturday 21 June 2014

PowerShell : How to sent mail using gmail SMTP

#---------------------------------------------------------------------------------------
$From = "Any.Singha@gmail.com"
$To = "Any.Singha@gmail.com"
$SMTPServer = "smtp.gmail.com"
$SMTPPort = "587"
$Username = "Any.Singha@gmail.com"
$Password = "XXXX" # Give your password
$subject = "Welcome to Powershell Group Meet Bangalore"
$body = "Hi, All Welcome"

$smtp = New-Object System.Net.Mail.SmtpClient($SMTPServer, $SMTPPort);

$smtp.EnableSSL = $true
$smtp.Credentials = New-Object System.Net.NetworkCredential($Username, $Password);
$smtp.Send($From, $To, $subject, $body);
#-----------------------------------------------------------------------------------

Sunday 15 June 2014

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

Thursday 12 June 2014

__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

Saturday 7 June 2014

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

ServiceNow onboarding Sailpoint