Quick Maximo overview -- expansion made on a great post at http://maximodev.blogspot.com/2013/03/quick-maximo-assessment.html. SQL edited here for the sake of readability -- just gave the Count(*) fields some names

QuickMaximoAssessment

Select 'Asset'          as TableName, (SELECT count(*) FROM asset)          as TheCount from dual union
Select 'AssetAttribute' as TableName, (SELECT count(*) FROM assetattribute) as TheCount from dual union
Select 'AssetTrans'     as TableName, (SELECT count(*) FROM assettrans)     as TheCount from dual union
Select 'CI'             as TableName, (SELECT count(*) FROM ci)             as TheCount from dual union
Select 'CIRelation'     as TableName, (SELECT count(*) FROM cirelation)     as TheCount from dual union
Select 'DocLinks'       as TableName, (SELECT count(*) FROM doclinks)       as TheCount from dual union
Select 'InvBalances'    as TableName, (SELECT count(*) FROM invbalances)    as TheCount from dual union
Select 'Inventory'      as TableName, (SELECT count(*) FROM inventory)      as TheCount from dual union
Select 'Item'           as TableName, (SELECT count(*) FROM item)           as TheCount from dual union
Select 'Locations'      as TableName, (SELECT count(*) FROM locations)      as TheCount from dual union
Select 'Site'           as TableName, (SELECT count(*) FROM site)           as TheCount from dual union
Select 'PR'             as TableName, (SELECT count(*) FROM PR)             as TheCount from dual union
Select 'PRLine'         as TableName, (SELECT count(*) FROM prline)         as TheCount from dual union
Select 'PO'             as TableName, (SELECT count(*) FROM po)             as TheCount from dual union
Select 'POLine'         as TableName, (SELECT count(*) FROM poline)         as TheCount from dual union
Select 'Invoice'        as TableName, (SELECT count(*) FROM invoice)        as TheCount from dual union
Select 'InvoiceLine'    as TableName, (SELECT count(*) FROM invoiceline)    as TheCount from dual union
Select 'MatRecTrans'    as TableName, (SELECT count(*) FROM matrectrans)    as TheCount from dual union
Select 'ServRecTrans'   as TableName, (SELECT count(*) FROM servrectrans)   as TheCount from dual union
Select 'Ticket'         as TableName, (SELECT count(*) FROM ticket)         as TheCount from dual union
Select 'Workorder'      as TableName, (SELECT count(*) FROM workorder)      as TheCount from dual union
Select 'JobPlan'        as TableName, (SELECT count(*) FROM jobplan)        as TheCount from dual union
Select 'PM'             as TableName, (SELECT count(*) FROM pm)             as TheCount from dual union
Select 'measurement'    as TableName, (SELECT count(*) FROM measurement)    as TheCount from dual union
Select 'meter'          as TableName, (SELECT count(*) FROM meter)          as TheCount from dual union
Select 'meterreading'   as TableName, (SELECT count(*) FROM meterreading)   as TheCount from dual union
Select 'wfaction'       as TableName, (SELECT count(*) FROM wfaction)       as TheCount from dual union
Select 'wfassignment'   as TableName, (SELECT count(*) FROM wfassignment)   as TheCount from dual union
Select 'wfinstance'     as TableName, (SELECT count(*) FROM wfinstance)     as TheCount from dual union
Select 'wfnode'         as TableName, (SELECT count(*) FROM wfnode)         as TheCount from dual union
Select 'wftask'         as TableName, (SELECT count(*) FROM wftask)         as TheCount from dual union
Select 'person'         as TableName, (SELECT count(*) FROM person)         as TheCount from dual union
Select 'maxuser'        as TableName, (SELECT count(*) FROM maxuser)        as TheCount from dual union
Select 'maxgroup'       as TableName, (SELECT count(*) FROM maxgroup)       as TheCount from dual 
;

SELECT siteid as SiteID, count(*) as Asset_Count_In_Site FROM asset GROUP BY siteid;
SELECT siteid as SiteID, count(*) as Workorder_Count_In_Site FROM workorder GROUP BY siteid;