Programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists

I need to programatically get all SharePoint items in our SharePoint 2010 site's libraries and lists. By programatically I mean using a power shell, SQL query or even a webpart

Libraries can be Asset Libraries, Document Libraries, Form Libraries, Picture Libraries, Report Libraries, Slide Libraries and Wiki Page Libraries.

List can be Links, useful Links and "I need to" Lists.

For each item inside a library or list, I need to find its name, type, created by (user) and modified by (user) fields.

I will need to recursively find all SharePoint sites and for each site, find the information I need.