View ODBC DSN per user

Follow
Danny Charlesworth

Looking to see if i can pull a report that shows me all the ODBC DSN listed per user. I need to see who in our domain has old 32bit connections that i need to go round and remove

 

I have had a little look round but everything points to actually deploying ODBC, which isn't what i am looking to do.


Thanks in advance!

0

Comments

1 comment

Date Votes
  • Ryan Joachim

    There are a few ways to get that information, most notably Powrershell and the registry.
    With Powershell, you can run Get-OdbcDsn -Platform 32-bit to list all 32-bit sources.
    The registry holds info on all of the sources for each user, but I don't think it shows whether a source is 64-bit or 32.

    My suggestion would be to pull the information you need using Powershell (with Get-OdbcDsn), then use that to populate custom fields in Inventory.
    From there you would be able to build reports based on the results of that script.

    Let me know if that's a route you'd like to look at, and I'll try to put together an example for you.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post