Wednesday, September 8, 2010

Find Machines coming under a Roaming boundary Subnet

select distinct a.Name0,b.IP_subnets0,c.SiteCode,d.LastHwscan, c.ServerName from v_r_system a inner join v_RA_System_IPSubnets b
on a.resourceid=b.resourceid
inner join v_GS_WORKSTATION_STATUS d on a.resourceID=d.resourceID
left outer join RoamingBoundaryIPSubnet c on b.IP_Subnets0=c.IPSubnet
where c.ServerName != ''
and a.Obsolete0=0
order by a.Name0


Description:

The Above query will give you the total strength of each roaming boundary subnet that a Server supports. You can categorize machines under each roaming boundary.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home