Video Screencast Help

Need a report to locate Subnets without a package server assigned

Created: 17 May 2013 | 3 comments

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

Comments 3 CommentsJump to latest comment

SK's picture

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).

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

Saeed's picture

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.

If a forum post solves your problem, please flag it as a solution. If you like an article, blog post or download vote it up.
 

fabio.sanches's picture

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