it will talk to all those PCs, the PS3 I am not sure about, as it is a MS product, I know it works with the xbox.
some discussion on PS3 and HMS here, http://www.avsforum.com/avs-vb/showthread.php?t=959767
and apparently a working solution here, http://www.whsplus.com/2009/04/25/ps3-media-server-for-whs/
"No matter where you go, there you are."
"If you can't do something smart, Do something right"
"There are three kinds of people in the world, those who can count, and those who can't"