Wrote a simple query to look at basic attributes of indexing in a specific database:
SELECT [IndexGroup]
,[FileName]
,[TableName]
,[IndexName]
,[dpages]
,[rowcnt]
,[rows]
,[OrigFillFactor]
,[groupid]
,[allocpolicy]
,[status]
,[groupname]
FROM [dbo].[INDEX_INFORMATION]
[Click Below to get the complete code used to create the database view]