Re: [Emerald] Anyone know of something that can do this?

Josh Hillman ( (no email) )
Mon, 26 Jun 2000 16:31:39 -0400

From: "Billy Huddleston" <>
> Anyone know of a program that can keep track of IP allocations and
> assignments and generate SWIP's and stuff? We maintain quite a few
> accounts, and it's a pain to have to lookup allocations on a Excel
> Spreadsheet, and really hard to tell what we have available and what has
> been assigned etc.. Would love to be able to tell the program how many
> I need, it search the records, spits out a free block that matches the
> specifications etc.. (I.E. Need 20 hosts, possibly to expand to 40 in a
> would like to reserve additional IP's.. Etc)
> Anyone got anything like this? Perhaps even linked with Emerald and the
> Radius attributes stored in dedicated services records?

This is fairly basic, but might help you along (if you use

select IPAddress=convert(char(15), data),
Active=case when active = 1 then 'Yes' else 'No' end,
Name=(firstname+' '+lastname)
from subaccounts sa, radconfigs rc
where sa.accountid = rc.accountid
and RadAttributeID = 8
order by data

-- josh

For more information about this list (including removal) go to: