here’s how I do it:

SELECT A.object_id
, A.index_id
, [name]
, Avg_Fragmentation_In_Percent
FROM sys.dm_db_index_physical_stats (db_id(), NULL,NULL, NULL, NULL) AS A
JOIN sys.indexes B WITH(NOLOCK)
ON A.Object_id = B.Object_id
AND A.Index_id = B.Index_id
WHERE [name] IS NOT NULL

Check the file growth option for your databases, it also tells you the logical and physical file name, file location, etc …

Script to rebuild indexes. it splits the tasks out into an online and offline reindexing. I made some modifications to it. You have to create this store procedure in the database you are looking to indexed.

Store Procedure to check whether a job is running or not.