Share via

SCCM query for computer name and MAC Address

kevin jimand 400 Reputation points
2024-10-08T15:37:36.41+00:00

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!

Microsoft Configuration Manager Deployment
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Deployment: The process of delivering, assembling, and maintaining a particular version of a software system at a site.
982 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Simon Ren-MSFT 34,546 Reputation points Microsoft Vendor
    2024-10-09T02:19:32.2966667+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.