Ruben Zimmermann

Another, related good read: https://docs.microsoft.com/en-us/windows/win32/adsi/what-makes-a-fast-query

Hi Simon,

sorry for the late feedback. I cannot provide an answer to your question.

But I have a suggestion 😉

Try to limit the columns to only what you need directly from the beginning. That makes queries faster.

It is like with databases. A "SELECT * FROM Table" will take much longer than "SELECT  ColumnA, ColumnB From Table".

Kind regards

Ruben

Hi Fernando,

glad you liked it.  🙂

You can speed up the query if you limit the information you need in the first step. Go from column to column, select the attributes you need and remove the ones you don't need. You directory size is not small but also not too much for Excel 😉

I don't know how to filter for specific users upfront. 

With query merging you can combine your AD query and your list  ( but you need to create table first from it and then also query that one ). You can specify then which of selection you need. E.g. if you want to have a Left-outer-join or a union-join or …

Hope that helped

Ruben

Hi Anthony,

as far I know co-authoring works only if a the Excel file is stored on SharePoint (Online) or in OneDrive. – Perhaps other document management systems also offer that functionality, but you need a ‘server’ in the background.

The ‘SHARE’ button in my Excel works in O365 and gives the possibility to select users from AzureAD or to add externals via E-Mail addresses. The recipient will receive a link to the document which is either in OneDrive or on a SharePoint site.

Ruben

Hi Javier,

Active Directory only stores the last logon information. If you need historical information I suggest to look into audit solutions like NetWrix or ManageEngine.

Ruben