All about Microsoft Endpoint Manager
  • Home
  • SCCM
    • Collections
    • OS Deployment
    • Troubleshooting Tips
    • Scripting
      1. PowerShell
      2. VB Script
    • SCCM Tools
  • SCCM Reports
  • Intune
  • About Author
Tuesday, 5 December 2023

Tags: All computers in defined subnet

Configmgr(SCCM) report for computers falls within Subnet

Posted on January 18, 2012 by Eswar Koneti | 2 Comments | 250 Views
had a requirement to see how many computer falls within the specific subnet. select a.name0,b.IP_Subnets0 from v_R_System a,dbo.v_RA_System_IPSubnets b where a.ResourceID=b.ResourceID and b.IP_Subnets0 in ('192.168.10.0') group by a.name0,b.IP_Subnets0 You can include other subnet details if you need.
Read more »

Eswar Koneti

Awards

  • Latest
  • Popular
  • Comments
  • Optimizing Content Delivery with Microsoft Delivery Optimization and Zscaler Proxy

    Optimizing Content Delivery with Microsoft Delivery Optimization and Zscaler Proxy

    November 23, 2023
  • Powershell script – Extract the device inventory data in Intune using Microsoft Graph

    Powershell script – Extract the device inventory data in Intune using Microsoft Graph

    October 30, 2023
  • Enhancing Troubleshooting with Verbose Logging in SCCM

    Enhancing Troubleshooting with Verbose Logging in SCCM

    October 29, 2023
  • Enhancing End-User Experience in Windows Update for Business using Intune

    Enhancing End-User Experience in Windows Update for Business using Intune

    October 28, 2023
  • SCCM ConfigMgr report for local admins and local group members

    SCCM ConfigMgr report for local admins and local group members

    March 9, 2017
  • SCCM Configmgr Troubleshooting Client software update issues

    SCCM Configmgr Troubleshooting Client software update issues

    April 7, 2015
  • Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

    March 25, 2010
  • SCCM report/collection for computers with Internet Explorer with different versions

    April 21, 2010
  • RaM Nice, thanks!
  • JaCzu Thanks. It works really well.
  • Eswar Koneti hi, looks like you dont have permissions to run the script n
  • Eswar Koneti Hi, For OSD task sequence, you dont need to CMG switches as

.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 6,172 other subscribers

@eskonr on Twitter

Tweets Eswar

All Rights Reserved

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

Archives

.

© Copyright 2009-2023 Eswar Koneti , All rights reserved.