How Can I Retrieve a List of the System DSNs on a Computer?

re: How Can I Retrieve a List of the System DSNs on a Computer?

hernandezjj — Thu, 04 Oct 2012 13:57:19 GMT

Good morning all!

How can I run the script agains a list of computers and store the results in a text file or Excel file, listing the DSN and the computer names? How about if I want to include the last user who logged into the computer?

Thank you,

re: How Can I Retrieve a List of the System DSNs on a Computer?

Pak-Ming Cheung (WDAC Team, Microsoft) — Wed, 27 Jun 2012 02:12:32 GMT

To retrieve the list of ODBC System DSN, you can use the command:

Get-OdbcDsn -DsnType System

To retrieve the list of ODBC User DSN, you can use the command:

Get-OdbcDsn -DsnType User

Thanks,

Ming.

WDAC Team, Microsoft.

(This post include information about a pre-release windows and is subject to change in future releases.)

re: How Can I Retrieve a List of the System DSNs on a Computer?

Pak-Ming Cheung (WDAC Team, Microsoft) — Wed, 27 Jun 2012 02:10:39 GMT

Of course, you can retrieve the list of DSN via some registry functions. However, there is a much simpler method available in Windows 8 (Release Preview version) and Windows Server 2012 (Release Candidate version).

You can use the Get-OdbcDsn to retrieve the list of all ODBC DSN installed in the system.

See the blog article for more detail: blogs.msdn.com/.../odbc-dsn-management-in-the-next-release-of-windows-code-named-windows-8-and-windows-server-8.aspx

Thanks,

Ming.

WDAC Team, Microsoft.

(This post include information about a pre-release windows and is subject to change in future releases.)

re: How Can I Retrieve a List of the System DSNs on a Computer?

BobM — Thu, 17 May 2012 17:19:07 GMT

Great script, thank you

Can you tell me how i could run this script against a list of computers?

thanks,