Editing OpenSimulator Internals/Useful Queries (section)

=== Object Contents (Task Inventory) ===

Show contents of a named object:

 SELECT pi.name, pi.assetType, pi.assetID
 FROM primitems pi
 WHERE pi.primID IN (
     SELECT UUID FROM prims
     WHERE SceneGroupID = (
         SELECT UUID FROM prims
         WHERE UUID = SceneGroupID AND Name LIKE '%Box%'
         LIMIT 1
     )
 );

Count task inventory items by type across all objects:

 SELECT pi.assetType, COUNT(*) AS count
 FROM primitems pi
 GROUP BY pi.assetType
 ORDER BY count DESC;

Show all objects that contain scripts:

 SELECT DISTINCT p.Name, p.UUID, p.GroupPositionX, p.GroupPositionY, p.GroupPositionZ
 FROM prims p
 JOIN primitems pi ON pi.primID = p.UUID
 WHERE p.UUID = p.SceneGroupID
 AND pi.assetType = 10
 ORDER BY p.Name;