Use PowerShell to find DSNs

by Mitch Tulloch [Published on 30 July 2014 / Last Updated on 30 July 2014]

Learn how to use Windows PowerShell to find DSNs

Here's another tip from my colleague Ed Wilson (the Microsoft Scripting Guy) about how to use PowerShell to

Question: Your users are complaining about accessing specific legacy data sources. You want to see what DSN’s are defined on their Windows 8.1 desktop devices using Windows PowerShell. How can you do this easily?

Answer: Use the Get-OdbcDsn cmdlet from the wdac module. An example syntax appears here:


Mitch Tulloch is a nine-time recipient of the Microsoft Most Valuable Professional (MVP) award and a widely recognized expert on Windows administration, deployment and virtualization.  For more information see

Ed Wilson is the bestselling author of eight books about Windows Scripting, including Windows PowerShell 3.0 Step by Step, and Windows PowerShell 3.0 First Steps. He writes a daily blog about Windows PowerShell call Hey, Scripting Guy! that is hosted on the Microsoft TechNet Script Center; for more PowerTips check out the Hey, Scripting Guy! blog.

See Also

The Author — Mitch Tulloch

Mitch Tulloch is a well-known expert on Windows Server administration and cloud computing technologies. He has published over a thousand articles on information technology topics and has written, contributed to or been series editor for over 50 books.

Featured Links