Device name required with user details

Poll

Hi
I have 70 users

How to get device name of those users

Is there any query available

Please 🙏 tell me

in progress 0
JAKEER 2022-04-24T01:15:30+05:30 1 Answer 25 views Beginner
0

Answer ( 1 )

  2. Deepak Rai
    0
    2022-04-27T04:25:34+05:30
    Reply

    Hope this helps.

    All PCs with Username and Email ID details

    SELECT SYS.User_Name0 as Login, USR.Mail0 as ‘EMail ID’, SYS.Netbios_Name0 as Machine,
    Operating_System_Name_and0 as OS FROM v_R_System SYS
    JOIN v_R_User USR on USR.User_Name0 = SYS.User_Name0
    –WHERE SYS.User_Name0 LIKE ‘Username’
    ORDER BY SYS.User_Name0, SYS.Netbios_Name0

Leave an answer

Sorry, you do not have permission to answer to this question .