The Open Source version of hyperic monitors just about anything in the universe, and anything that is not monitored out of the box can be monitored by creation of a super simple plugin (a single xml file usually).
If the environment is relatively small (<20 machines) you can use the prepackaged internal db, but if it is larger then you may need to look into an external db. As it is project based I guess it is small in which case you will be fine with the internal db. The agents that run on the machines you want to monitor are very lightweight.
All documented here:
Out of the box supported
SQL Based Plugins
Pretty Much all other plugins