> ## Content Index
> Fetch the complete content index at: https://www.techielass.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# ConfigMgr Query for Name, Serial Number, BIOS Version, IP Address and MAC Address
- URL: https://www.techielass.com/configmgr-query-for-name-serial-number-bios-version-ip-address-and-mac-address/
- Published: 2017-02-22T06:00:00.000Z
- Updated: 2023-12-07T11:39:30.000Z
- Description: In this blog post I show you how you can query your Configuration Manager database for important information from your devices.
- Author: Sarah Lean
- Tags: ConfigMgr

> These queries were last tested with [Configuration Manager version 2107](https://docs.microsoft.com/mem/configmgr/core/plan-design/changes/whats-new-in-version-2107?WT.mc%5Fid=modinfra-0000-salean&ref=techielass.com)

I recently had to pull together some information on several servers, and I used ConfigMgr to collate the information. Below is the ConfigMgr Query that I used and its SQL equivalent. This query will pull out the Computer Name, Serial Number, BIOS Version, IP and MAC Address.

The ConfigMgr query is:

```bash
select distinct SMS_R_System.Name, SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_PC_BIOS.SMBIOSBIOSVersion, SMS_R_System.IPAddresses, SMS_R_System.MACAddresses from  SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId

```

![The query inside ConfigMgr](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/08/configquery.png)

The query inside ConfigMgr

Here is the SQL equivalent if you wish to use that instead to pull the information out of your ConfigMgr database:

```SQL
SELECT DISTINCT SYS.Name0, IP.IP_Addresses0, NET.MACAddress0, BIOS.SMBIOSBIOSVersion0, BIOS.SerialNumber0 FROM dbo.v_RA_System_IPSubnets IPSUB INNER JOIN dbo.v_R_System SYS ON IPSUB.ResourceID = SYS.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NETW ON SYS.ResourceID = NETW.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER NET ON SYS.ResourceID = NET.ResourceID INNER JOIN dbo.v_RA_System_IPAddresses IP ON IPSUB.ResourceID = IP.ResourceID INNER JOIN dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID = SYS.ResourceID

```

### Conclusion

Even if you can't use this query immediately, I would suggest taking a copy and storing it. You never know when this might come in handy, or it could be the start of a query you need.