Re: [Emerald] Records

Frank Canode ( (no email) )
Fri, 12 Nov 1999 09:29:06 -0600

Sounds like you may have some MBRs with no services. Search for "serviceless
accounts" onthe Advanced tab of the accounts window.

FrankC

> When I open up Emerald Manager at the bottom I see my licensing
information
> with the number of licenses I have now and how many are used (ie.
> 1164/1200). Now when I use MSQuery and pull a listing of all the records
> from the Emerald DB:
>
> (SELECT SubAccounts.PhoneHome, SubAccounts.PhoneWork,
SubAccounts.LastName,
> SubAccounts.FirstName, SubAccounts.Login, SubAccounts.Password,
> SubAccounts.AccountType
> FROM Emerald.dbo.SubAccounts SubAccounts)
>
> I get a total of records (1111) that is 53 less that what shows in the
> Emerald Manager (1164).
>
> Any ideas as to why this happens? My billing/accounting people are going
> nuts trying to get those numbers to match.
>
> TIA
>
> Jason Roblyer
> NCTC
> jason@nctc.net
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart