Arch Linux

* Display all installed packages
"pacman -Q"

* Display installed packages in a tree format (dependancy based)
These scripts should provide a starting point:
http://bbs.archlinux.org/viewtopic.php?t=10283 (by skoal)
http://bbs.archlinux.org/viewtopic.php?t=10339 (by Spider.007)

* Display all installed files (basically a -Ql on all installed packages)
"pacman -Ql" does this.

* Check for missing files
* Check for unowned files
These scripts should provide a start:
http://bbs.archlinux.org/viewtopic.php?id=45939 (by Spider.007)
http://bbs.archlinux.org/viewtopic.php?id=43548

You are right the tree format isn't implemented either...
So it should be:
V * Display all installed packages
X * Display installed packages in a tree format (dependancy based)
V * Display all installed files (basically a -Ql on all installed packages)
V? * Check for missing files (similar to above except tests for file)
X * Check for unowned files (similar to skeeterbug's script in another thread, but done in C/C++ and optimized to work on a cached pacman database listing)

Now I know people have been trying to make tools for this... Me too: Ben Dibbens = ibendiben... I know of all the options, I just thought it would be nice if sometime these features were a part of pacman...
As you can see in the topics, the demand is there...

I am confused by these V/X notations, and also more generally by your posts.
But Allan made a better sumup of the situation imo. We have scripts for getting tree format, and scripts for checking missing/unowned files.
So the goal here is to come up with two perfect scripts, based on these existing ones, and submit them to pacman-dev ML so that they can be included in either pacman or pacman-contrib packages.
It goes without saying that help is welcome :)

Progress? Otherwise I want to close bug reports that aren't going to go anywhere.

The only thing that is not covered on the list is a script that lists files that are in the pacman db but not on the computer, and that are on the computer but not in the pacman db. There are a couple of versions on the forums which never made their way to the pacman-dev list like I asked...

Closing. Most requests implemented in pacman/pacman-contrib. Scripts are available on forums for remainder. Tidy them and submit them to the pacman-dev list for formal inclusion.