View ODBC DSN per user
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!
-
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.
Please sign in to leave a comment.
Comments
1 comment