Device name required with user details


I have 70 users

How to get device name of those users

Is there any query available

Please 🙏 tell me

Answer ( 1 )


    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 .