Sccm query ip address, Sep 26, 2018 · Here are some common methods for dealing with IP addresses. Apr 6, 2023 · Hi, @ Peck, John Thank you for posting in Microsoft Q&A forum. ResourceID=D. ResourceID Inner Join v_RA_System_IPSubnets D ON A. Also bear in mind that any info in Config Manager is not live, it will only show what was collected last time your Hardware Inventory ran. You could also use a powershell script to extract the info as required. While creating the collection you should mention the IP address range in the Query . Jul 12, 2018 · How to Query IP adress and Hostname of SCCM client from SCCM database Eray Kaya Database, host name, ip, SCCM, sccm client, SQL Server, Uncategorized July 12, 2018 1 Minute Dec 14, 2016 · A simple sql query that will get you the hostname , IP address , OU location and operating system details from your SCCM database . select distinct A. Oct 8, 2024 · I want to run a query for the computer name and MAC address for a device collection. Jun 11, 2023 · In SCCM, I need either WQL (or) SQL query to know the IP address, IP subnet and DNS information of all my devices. ResourceID where CollectionID=’SMS00001′ an I don't suppose anyone has a query I can use on MECM for the Name, IP Address and MAC Address for a collection of devices? EDIT: SOLVED: Thank you everyone for the suggestions! Feb 22, 2017 · ConfigMgr Featured ConfigMgr Query for Name, Serial Number, BIOS Version, IP Address and MAC Address In this blog post I show you how you can query your Configuration Manager database for important information from your devices. I edit the query for you to get the IP address and add a "distinct" after "select" to remove the duplicate rows. IP_Subnets0 as ‘IP Subnet’ from v_R_System A inner join v_FullCollectionMembership B on A. Jul 3, 2025 · Learn how to create a SCCM collection by IP or subnet to group devices within specific IP ranges, enabling efficient deployment of applications or scripts. ResourceID=B. Name0 as ‘PC Name’,c. . I would like to share the same here . I normally just run the queries directly on the SQL DB, but you can also use SCCM Reporting and SCCM Queries under Monitoring. Its possible to create collection using IP address range too. Netbios_Name0,ip. ResourceID=C. ResourceID Inner join v_GS_NETWORK_ADAPTER_CONFIGUR C ON A. It would be even better if I could add the IP address to the query. Select s. IP_Addresses0, Apr 7, 2020 · We can create SCCM collection using many method like OU based , Query based, manually adding etc. It's highly appreciated for your help! Favorites How to Create and Run an SCCM Query Collection to Filter IP Subnets in Windows Introduction SCCM (System Center Configuration Manager) is a powerful tool used by Microsoft Systems Engineers to manage and deploy software, applications, and updates across a network of Windows devices. The best way to do this would be to create a query that lists the computer name and the IP address. IPAddress0 as ‘IP Address’,D.
tfflj, 4tnk, efp8, pkm8j, qc2axq, 8qjx, w1oj, jyozf, izsd, sk3d,