USE [Base2Base.Tcu5Db40727_New];
GO

SELECT 
    OBJECT_SCHEMA_NAME(i.object_id)     AS SchemaName,
    OBJECT_NAME(i.object_id)            AS TableName,
    i.name                              AS IndexName,
    i.index_id,
    i.type_desc                         AS IndexType,
    us.user_seeks,
    us.user_scans,
    us.user_lookups,
    us.user_updates,
    us.last_user_seek,
    us.last_user_scan,
    us.last_user_lookup,
    us.last_user_update
FROM sys.indexes AS i
JOIN sys.dm_db_index_usage_stats AS us
    ON i.object_id = us.object_id 
   AND i.index_id  = us.index_id
WHERE 
    OBJECTPROPERTY(i.object_id, 'IsUserTable') = 1
    AND us.database_id = DB_ID('Base2Base.Tcu5Db40727_New')
    AND (
        us.user_seeks   > 0 
        OR us.user_scans   > 0 
        OR us.user_lookups > 0
    )
    AND OBJECT_NAME(i.object_id) = 'InventoryJournalRecords'
ORDER BY 
    (us.user_seeks + us.user_scans + us.user_lookups) DESC;