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?
 
Alex GreenConnect With a Mentor 3rd Line Server SupportCommented:
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
 
Alex Green3rd Line Server SupportCommented:
Why not use powershell?

Get-ADGroup -filter * -properties * | Select-Object Name | export-csv c:\temp\results.csv
0
 
Alex Green3rd Line Server SupportCommented:
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
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
 
Alex Green3rd Line Server SupportCommented:
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 Green3rd Line Server SupportCommented:
And the security associated with the groups, I.E Go to properties and then the security tab. Correct?
0
 
Sonia BowditchInformation Security OfficerAuthor Commented:
Thanks for your help.
0
All Courses

From novice to tech pro — start learning today.