Skip to content

Instantly share code, notes, and snippets.

@weeyin83

weeyin83/configmgr-sql.sql

Last active September 1, 2020 14:24
Show Gist options
  • Save weeyin83/4644e99c39952968b4bd96ea790bc629 to your computer and use it in GitHub Desktop.
Save weeyin83/4644e99c39952968b4bd96ea790bc629 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
configmgr-sql.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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment