Sandra - it can tell the spd info, good manufacturers put the part number into it, so you can find out what module you have, but not the exact chip. it also reports the timing of the memory running at.
Ctspd - it only tells the spd info, good for quick check. it tells the cas latency, ras-to-cas delay, ras percharge at 66, 100, 133Mhz, spd version, dimm manufacturer, dimm part number, etc.
Look at the module - good manufacturers put a sticker on it with the part number. for example, genuine Micron made module has a sticker with logo and part number, Crucial module is the exact genuine Micron made module with an additional sticker with Crucial logo and Crucial part number.
Look at the chips - this is the only way to find out what exact chips are on a module. ram chip manufacturers have decoder or datasheet for you to check on their websites. this is the only way to find out the real speed of the chips on a module.