TFS Database - Get list of files in collection -

im trying query tfs database list of files held in collection.

we use tfs our version control vs solutions , im trying print out of files in each collections , whether checked in or not. ive got ones still checked out cant find checked in ones

any appreciated

never mind getting list in tbl_localversion. not ideal should suffice