So folks we have around 30/40 sql server failover cluster insatnce with each having only 2 nodes in server.Eevry we have to server access we need to riase request for both nodes as we donot which oen is active or passive.So i was think of craeting sp which would execute on each FCI node and dump which node is active of passive in table .Then other sp would update similar table on centrailized server throuh link server and then would ran 3 sp on centrailized server which would send emal to our gorup letting us know which is active or pasive node.I iniatllay wanted to include ip but extracting IP is not easy in sql server i guess without using xp_cmdshell which is exepcted to be turned oFF i our eniveornment.We cannot use 3 party apid tools of monitoing which might have reduce our task...
So folkd let me know if my apporcahed is good or it can be refined too