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
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
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