In 24 years of inspecting this is the first time I found standing water in a roof vent. I assume it was clogged with something, but I will let a plumber figure that out.
good catch
Was there a vent installed, or just a boot for a vent? What was in the attic?
You cant tell from that angle but there was a pipe attached, although a short pipe.