Check database runs a consistency check on your SQL Server (its a check
that SQL Server does on itself) and also checks your identities and
index
statistics. You should do this once a week if you don't have it
scheduled as a task.
Update calls updates your calls table prior to a consolidation. Again,
you only need to d this if you don't have it scheduled as a task.
Update database is used to go from Emerald 2.1 to Emerald 2.5.
> 2. SQL Server: Emerald Database : Stored Procedures
> - What does "Trim Logs" do? When should I run it?
> - What does "Consolidation" do? I keep hearing about multiple-hour runs.
> - Is there a stored procedure to automatically trim the calls database
> after say 6months or 1 year?
In general, you should never use a stored procedure directly. They are
there for use by the programs.
Trim Logs is used by a schedule task to trim your RadLogs entries.
Consolidation is used by the pre-billing (charges) step.
No, but you could easily make one.
> 3. Emerald Admin: Servers: USR HyperArcs
> - Is there an SQL statement to get these ported right? Peter did one for us
> during the inital conversion, but we're adding more chassis all the time.
Yes. ftp://ftp.iea-software.com/Emerald/Updates/updtports.sql
> BTW the "UST HyperArc" option gives an SQL when you chose it then save.
This has already been fixed.
> - What does it take to get the "online" tables right? I have 6 chassis
> working right, and 2 chassis auth'ing from Emerald, and logging to it, but
> the "online" tables are Waaaay wrong.
Run the above script after receiving calls for a while and it will
create
the correct ports.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com