Adult diagnosis - experiences informing work

Hi

I'm looking at getting a formal diagnosis, after speaking to a psychologist who can help me with it. I mostly want it for myself, my own understanding, and not feeling like a "fraud" in the ND community. 

However, I would love for a diagnosis to allow me to gain some kind of understanding of me by my work place (at least my managers). 

What experiences have you guys had with informing your work places of your diagnosis? I have read a post where someone had a very negative experience. I am wondering what other experiences people have had. Especially where adjustments had been made to accommodate. 

Cheers

Dave