Close Menu
    Facebook X (Twitter) Instagram
    Sunday, July 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»ConfigMgr(SCCM) report for subnets which are undefined

    ConfigMgr(SCCM) report for subnets which are undefined

    Eswar KonetiBy Eswar KonetiJanuary 19, 3:50 pm1 Min Read SCCM 2007 363 Views
    Share
    Facebook Twitter LinkedIn Reddit

    SELECT
       COUNT(distinct ResourceID) as [Count],
       IP_Subnets0 as Subnet
    FROM
       dbo.v_RA_System_IPSubnets
    WHERE
       IP_Subnets0 NOT IN (SELECT IPSubnet FROM
    dbo.v_SiteRoamingBoundary_IPSubnet)
    GROUP BY
       IP_Subnets0
    ORDER BY
       IP_Subnets0

    report for subnets sccm report sccm report for subnets not defined Subnets not defined System center configuration Manager Undefined subnets report
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

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

    Type above and press Enter to search. Press Esc to cancel.