Blog Post

Core Infrastructure and Security Blog
9 MIN READ

How to find expensive, inefficient and long running LDAP queries in Active Directory

Mark Morowczynski's avatar
Mark Morowczynski
Icon for Microsoft rankMicrosoft
Sep 20, 2018
UPDATE (7/7/2021): It was discovered that the script was removed from the scriptcenter location previously referenced. As such, we have provided the script as a download on this post.   First pub...
Updated Jul 07, 2021
Version 4.0
MarkMorow
RKjmk's avatar
RKjmk
Copper Contributor
Apr 01, 2024

I'm not the author, however if you receive an error like "Unable to get the PivotTables property of the Worksheet class...", replace the following lines:

 

#207 $Sheet2 = $mcWorkbooks.Worksheets.add()

#207 $Sheet2 = $mcWorkbooks.Worksheets("Sheet2")

 

#235 $Sheet3 = $mcWorkbooks.Worksheets.add()

#235 $Sheet3 = $mcWorkbooks.Worksheets("Sheet3")