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
Saturday, 3 June 2023

Tags: Subnets report

Configmgr(SCCM) report for computers falls within Subnet

Posted on January 18, 2012 by Eswar Koneti | 2 Comments | 239 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

Support the website

  • Latest
  • Popular
  • Comments
  • Company portal – Install option grayed out due to primary user

    Company portal – Install option grayed out due to primary user

    May 9, 2023
  • Efficiently Target Your Devices and Users with Intune Filters

    Efficiently Target Your Devices and Users with Intune Filters

    April 16, 2023
  • MyApps and Conditional Access – Exclude with ease

    MyApps and Conditional Access – Exclude with ease

    January 26, 2023
  • Efficiently Identify Co-Managed Devices: Techniques and Tools

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 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
  • Eswar Koneti Hi Bob, can you post your query here for me to look at it? i
  • Andre Piva Thanks! I lost a lot of time with this screen, several forma
  • Bob Hiya, this mostly works however it's definitely flagging som
  • Eswar Koneti Hi, with windows 10 and windows 11, you hardly need to use t

.

Subscribe to Blog via Email

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

Join 7,434 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.