Power Query for Excel 2013 From Active Directory Query Help

I am having to use Power Query in Excel 2013.  I want to create a query to connect to the Domain Controller to get a list of groups.  Unfortunately, I am more familiar with the later versions of Power Query and I am having difficulty in creating the connection when I don't have the New Query\From Other Sources\From Active Directory.

Could any one help?

I am not able to upgrade Excel 2013 and Power Query at this time.
Sonia BowditchInformation Security OfficerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alex GreenProject Systems EngineerCommented:
Why not use powershell?

Get-ADGroup -filter * -properties * | Select-Object Name | export-csv c:\temp\results.csv
0
Alex GreenProject Systems EngineerCommented:
If you have a list of groups, please provide them and/or tell me if they are in a text file and what details you want.

Thanks
Alex
0
Sonia BowditchInformation Security OfficerAuthor Commented:
Thanks for getting back to me.  I need something that will dynamically update the list of AD security groups each time the Excel spreadsheet was opened.  With a powershell I would need to run it each time and since this is something I will be handing off to someone who would not have the appropriate access to run a powershell.  I want to make the process as easy as opening a spreadsheet.

Thanks,
Sonia
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Alex GreenProject Systems EngineerCommented:
Actually pretty much everyone will have read access to active directory, and the groups. I've had to set something like this before up.

So you want the actual security of the groups, not the content of the groups right?
0
Sonia BowditchInformation Security OfficerAuthor Commented:
You are correct.  All I need is the a list of the groups and not the actual content.

Thanks,
Sonia
0
Alex GreenProject Systems EngineerCommented:
And the security associated with the groups, I.E Go to properties and then the security tab. Correct?
0
Alex GreenProject Systems EngineerCommented:
Oh actually the code I gave you would do it, you don't want the security structure so.

Get-ADGroup -filter * -properties * | Select-Object Name | export-csv c:\temp\results.csv

Open in new window



You could also use

Get-ADGroup -filter * -properties * | Select-Object Name, canonicalname | export-csv c:\temp\results.csv

Open in new window



which would give you the location in AD
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sonia BowditchInformation Security OfficerAuthor Commented:
Thanks for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.