Ignacio Torres Masdeu

Diary: 2006-02-15 - ePolicy Orchestrator SQL

...brain ...hurts 

use ePO_SERVER99; --
select BranchNode.NodeName,ipsubnetmask.AutoID,
BranchNode.ParentID,ipsubnetmask.ParentID,
ipsubnetmask.IP_Start,ipsubnetmask.IP_End
from ipsubnetmask join BranchNode
on IPSubnetMask.ParentID = BranchNode.AutoID
where BranchNode.ParentID not in ('1','2')
order by IP_Start;

Handy Software:

# Published on: Wed, 15 Feb 2006 17:03:00 +0100