search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
267 stars 62 forks source link

ODBC and JDBC Driver Version #1076

Open aachaemenes opened 1 month ago

aachaemenes commented 1 month ago

It is very valuable for DBADASH to track ODBC and JDBC driver versions.

DavidWiseman commented 1 month ago

There isn't a lot of information in this request as to why this would be useful. None of our applications use ODBC or JDBC so I'm unlikely to look at this. I'd consider pull requests.

aachaemenes commented 1 month ago

The jdbc driver is it is outdated causes lots of implicit transactions which is horrible. Odbc and ole drivers if they are outdated have security and connectivity implications. Most apps are using one or the other to talk to SQL.

On Mon, Oct 14, 2024, 12:59 PM David Wiseman @.***> wrote:

There isn't a lot of information in this request as to why this would be useful. None of our applications use ODBC or JDBC so I'm unlikely to look at this. I'd consider pull requests.

— Reply to this email directly, view it on GitHub https://github.com/trimble-oss/dba-dash/issues/1076#issuecomment-2412098671, or unsubscribe https://github.com/notifications/unsubscribe-auth/BGN5RX2GNSOUQ6OIO4YB743Z3QPCBAVCNFSM6AAAAABP5LSWK2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMJSGA4TQNRXGE . You are receiving this because you authored the thread.Message ID: @.***>

DavidWiseman commented 1 month ago

I'm not sure if it's possible to capture what driver versions are being used by clients. The client interface name is available in sys.dm_exec_sessions but that doesn't tell you much other than it's ODBC, etc.

aachaemenes commented 1 month ago

We have to powershell through it

Get-OdbcDriver -CimSession MyServer -Name sql | Format-Table name, platform -AutoSize 02. name platform

On Mon, Oct 14, 2024, 1:38 PM David Wiseman @.***> wrote:

I'm not sure if it's possible to capture what driver versions are being used by clients. The client interface name is available in sys.dm_exec_sessions but that doesn't tell you much other than it's ODBC, etc.

— Reply to this email directly, view it on GitHub https://github.com/trimble-oss/dba-dash/issues/1076#issuecomment-2412247576, or unsubscribe https://github.com/notifications/unsubscribe-auth/BGN5RX5SKGZY4H5IZOEJHLLZ3QTV7AVCNFSM6AAAAABP5LSWK2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMJSGI2DONJXGY . You are receiving this because you authored the thread.Message ID: @.***>