with tbl as
(
select l.request_session_id,
       l.resource_database_id,
       DB_NAME(l.resource_database_id) AS dbname,
       CASE WHEN resource_type = 'OBJECT'
            THEN OBJECT_NAME(l.resource_associated_entity_id)
            ELSE OBJECT_NAME(p.OBJECT_ID)
       END as ObjectName,
       p.index_id,
       i.name AS index_name,
       l.resource_type,
       l.resource_description,
       l.resource_associated_entity_id,
       l.request_mode,
       l.request_status
from sys.dm_tran_locks l
left join sys.partitions p on p.hobt_id = l.resource_associated_entity_id
left join sys.indexes i on i.OBJECT_ID = p.OBJECT_ID AND i.index_id = p.index_id
where l.resource_associated_entity_id > 0
and l.resource_database_id = DB_ID()
) select count(*) as [count], objectname, resource_type, index_name from tbl group by objectname, resource_type, index_name order by 1 desc