He asked how I was is the more usual idiomatic form. He asked how I am is a possibility, but it suggests a more continuous sense of "I am".
He asked how am I is not grammatical, punctuated like that. He asked, "How am I?" is a soliloquy, in which he poses the question to himself.