Use 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 http://www.mtit.com.
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.