Is there a way we can pull logs for failed login attempts to the Milestone server from any of the log files or using MIP SDK? we are getting the successful login attempts using the audit logs but what I need is unsuccessful attempts.Thanks!

Failed login attempts are not logged as you have observed, only the succesful logins are logged. It is not possible to introduce this logging functionality by use of the MIP SDK.