The DCS-932L should be able to illuminate a pitch black room 10+ feet in front of the camera's field of view. Your statement implies that moonlight helped illuminate the room, when in fact no external light source is necessary. The DCS-932L IR illuminator (four red lights around the face of the camera) provides 100% of the light needed for night mode.
This is exactly what used to happen. Room is for dogs, no bigger than 10'x12' with the camera mounted about 3 feet from the ground on a wall, not on a corner. I thought that's what the red dots are for but even now, all four red dots are illuminated with a solid green LED and still fails. I say fails because I used to see the black dogs, floor, etc clearly but now everything is pitch black except for their eyes.
If you haven't already tried this, go into the DCS-932L web interface and set the camera to "Always Night Mode" and save the settings via the following path: Setup > Day/Night Mode > Always Night Mode
Tried that. Even went to camera, recycled power after saving settings, and still no improvement.
If the night vision still doesn't work properly in a pitch black room, call D-Link customer support and ask them to issue you an RMA for a replacement unit.
10-4. This seems to be the next logical step, although the retailer will give me a new one first since I'm still in their return period.