Client Management Suite

 View Only

  • 1.  Report of Sites and Package Servers in each site

    Posted Jun 30, 2010 12:15 PM

    We have over 400 sites and are supposed to have 2 package servers at each site.  One is a constrained package server and the other  "mother ship" package server is unconstrained and is manually assigned to each site.  This serves as the "source" location for the individual package servers. 

    I would like to create a report that shows which sites are missing a package server other than the mother ship.  Possibly showing all sites or ONLY those sites that are missing a site specific package server (the non-mothership one).

    Site1 MotherShip Site1PS
    Site2 MotherShip Site2PS
    Site3 MotherShip Missing
    Site4 MotherShip Site4PS
    Site5 MotherShip Missing

    I am having trouble finding how to JOIN the tables/views together for this one or which tables/views to use.

    I know I can go into the Site Maintenance and gather the information that way manually but with over 400 sites that can be tedious.  What I am looking for is an exception report for the most part that I can hand off to our service desk team to remediate.


  • 2.  RE: Report of Sites and Package Servers in each site

    Posted Mar 04, 2011 01:02 AM

    Hi jgallas,

    Well it is a bit after the fact....but if you're still looking for this, I put together a report a while ago that I think will at least get you well on your way.  Check it out here (remember to give a thumbs up if it helps! smiley).