1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

View ODBC DSN per user

Avatar
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
  • Avatar
    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