{"id":86010,"date":"2015-11-24T08:23:09","date_gmt":"2015-11-24T16:23:09","guid":{"rendered":"http:\/\/devblogs.microsoft.com\/scripting\/?p=86010"},"modified":"2019-06-11T08:24:02","modified_gmt":"2019-06-11T16:24:02","slug":"automating-index-fragmentation-reports-2","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/automating-index-fragmentation-reports-2\/","title":{"rendered":"Automating Index Fragmentation Reports"},"content":{"rendered":"

Summary<\/b>: Guest blogger, Laerte Junior discusses how to use PowerShell to automate an index fragmentation report and generate an Excel file.<\/span><\/p>\n

One of the day-to-day tasks of a DBA is to maintain your environment. This task includes checking the fragmentation of indexes. In this post, I will show how to automate this collection and generate an Excel file.<\/p>\n

Environment considerations<\/h2>\n

For this particular script, I am assuming that like me, you use a central “collector” machine. For that, you have installed SQL Server 2012 or later, Excel, and Windows PowerShell 4.0 or later. Yes! I will use some coding features that only work in Windows PowerShell 4.0 and later. So you are good to go if your checklist looks exactly like this one:<\/p>\n