Again, it depends on what your managers wants in his reports.

For keeping track of available "raw" storage that is allocated to a volume group,
lsvg vgName will give the best high level view - total size in PP, PP size, # PP used, # PP free, # PP stale (generally zero) summarized, and basically the sizes also calculated in terms of MByte for all combined disks in a volume group.
To use
lspv hdiskX a disk must be part of a volume group. This data is similiar to the lsvg vgName command, but is limited to the specific disk. To keep track of disks that are completely 'free'/unused,
lspv woth no argument should suffice. In any case the contents of the disk(s) with no volume group name behind them are potential candidates for being added to a volumn group.
I suspect the
lsvg vgName, e.g.
lsvg rootvg is the command you will want. Rather than look for a specific tool (although you might want to check on what nmon collects, and whether sar collects such data) I would probably write a sed/awk or perl program to extract the data on a 'regular' basis (daily, weekly, or monthly) with CSV output for easy import to a spreadsheet.
If you wanted to get fancier you could consider putting it into a database that the spreadsheet program could query for the data. I"d only do something like that because I wanted to learn a new trick, or I had use for the methods in a broader sense.
Maybe someone has the basics of a script already. ??