Symantec Management Platform (Notification Server)

 View Only

  • 1.  Need a report to locate Subnets without a package server assigned

    Posted May 17, 2013 09:49 AM

    Does anyone out there have a report that can lookup Subnets that do not have a Package Server assigned?



  • 2.  RE: Need a report to locate Subnets without a package server assigned

    Posted Jun 05, 2013 01:31 PM

    There is a stored procedure that lists those that do (cant rememebr if there is one that lists those that dont), so you should be able to modify its sql to have it show those that dont (obviously do not modify the actual SP but use its SQL as a seperate query).



  • 3.  RE: Need a report to locate Subnets without a package server assigned

    Posted Jul 23, 2013 12:28 AM

    Hi GUYS,

     

    Even i would like to have such report where i can find all the subnet where there is not package server assigned. Or a report which will tell which package server is assigned to which subnet.



  • 4.  RE: Need a report to locate Subnets without a package server assigned

    Posted Jul 28, 2013 01:16 AM

    Hi DrGonzo,

    Could you please test the following query?

    select
    st.Name,
    ss.Subnet,
    ss.[Subnet Mask]
    from vSiteSubnetMap vsm
    full outer join vSite st on vsm._ResourceGuid = st.Guid
    full outer join vSubnet ss on vsm.SubnetGuid = ss.Guid
    order by st.Name
     
    Regards,
     
    Fábio Sanches