While working on a case  came across a link and thought of sharing with all

http://support.microsoft.com/kb/321044

it gives details about how to find out duplicate SPNs or query SPNs