SCCM query for computer name and MAC Address

Question

I want to run a query for the computer name and MAC address for a device collection. It would be even better if I could add the IP address to the query. It's highly appreciated for your help!

Answer 1

Hi,

Thank you for posting in Microsoft Q&A forum.

You can try below query for computer name, MAC Address and IP address:

select SMS_R_System.NetbiosName, SMS_R_System.MACAddresses, SMS_R_System.IPAddresses from SMS_R_System

Thanks for your time. Have a nice day!

Best regards,

Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.