Eswar Koneti's Blog

All about Configmgr and its connected objects…….

  • About Author
       View eswar koneti's LinkedIn profile

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

    Join 106 other subscribers

  • Awards


  • FaceBook Updates

  • Catagories

  • Meta

  • Copyright!

    All the blog posts in this website are owned by Eswar Koneti and may not be reused in any mode without prior approval of Eswar Koneti. You may quote one paragraph from the blog posts if you link to the original blog post.
    Happy Reading!

«
»

SCCM Report count child sites reporting to Primary

Posted by Eswar Koneti on August 14th, 2012

In a Big environment to know/work based on regional wide kind of doing some maintenance tasks in SCCM ,this would would help you to get you the count of Child sites reporting to primary.

select ReportingSiteCode ,COUNT(*) as [Child sites] from v_Site
group by ReportingSiteCode
order by ReportingSiteCode

Tags: , , , , ,
This entry was posted on Tuesday, August 14th, 2012 at 11:39 AM and is filed under SCCM Reports, SQL Quiries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

«
»