When a cookbook has been uploaded to chef server ?

report.sql

-- su - opscode-pgsql
-- psql -d opscode_chef
-- https://github.com/opscode/chef-server-schema/tree/master/deploy
SELECT c.name,
       v.major || '.' || v.minor || '.' || v.patch AS version,
       v.updated_at,
       v.created_at
FROM cookbooks AS c
JOIN cookbook_versions AS v
  ON c.id = v.cookbook_id
ORDER BY c.name, version;

SELECT r.name, 
       r.created_at,
       r.updated_at

FROM roles r
ORDER BY r.name;

SELECT e.name, 
       e.created_at,
       e.updated_at

FROM environments e
ORDER BY e.name;

SELECT d.name, 
       d.created_at,
       d.updated_at

FROM data_bags d
ORDER BY d.name;

SELECT d.data_bag_name,
       d.item_name,
       d.created_at,
       d.updated_at

FROM data_bag_items d
ORDER BY d.data_bag_name, d.item_name;