With the recent issues surrounding the data_engine performance and different versions of NMS having different indexes someone in support created a script to retrieve the index information. This is not my creation but it might save you some time in getting information to support in regards to slow data_engine performance.
USE NimsoftSLM GO SELECT so.name AS TableName , si.name AS IndexName , si.type_desc AS IndexType FROM sys.indexes si JOIN sys.objects so ON si.[object_id] = so.[object_id] WHERE so.type = 'U' --Only get indexes for User Created Tables AND si.name IS NOT NULL ORDER BY so.name, si.type