locked
how to get client information that login sql server RRS feed

  • Question

  • hi ;

    is it possible to get remote client information such as , macadres,diskno,processor or other hardware info ( only remote client )

    Saturday, April 7, 2018 2:24 PM

Answers

  • hi ;

    is it possible to get remote client information such as , macadres,diskno,processor or other hardware info ( only remote client )

    You cant get all such info what best you can get is IP address or MAC address using sys.dm_exec_connections or sys.dm_exec_sessions.

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Marked as answer by Aly14 Monday, April 9, 2018 6:47 AM
    Monday, April 9, 2018 4:28 AM

All replies

  • You can get client IP address from sys.dm_exec_connections (Transact-SQL), how (or why) should SQL Server know anything about Client architecture like CPU, hardware, etc?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Sunday, April 8, 2018 6:12 AM
  • hi ;

    is it possible to get remote client information such as , macadres,diskno,processor or other hardware info ( only remote client )

    You cant get all such info what best you can get is IP address or MAC address using sys.dm_exec_connections or sys.dm_exec_sessions.

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Marked as answer by Aly14 Monday, April 9, 2018 6:47 AM
    Monday, April 9, 2018 4:28 AM
  • I didn't find That I want in your's solution , I think I will look other solution like .NET on C#

    Thanks in advance.

    Monday, April 9, 2018 6:47 AM