Anyone know a query one can pull to obtain the following I need total number of distinct logins totaled per nas for a given month. Say in this instance (Example output) 7/1/2004 through 7/31/2004 NasIPAddress Total (Distinct Logins) 1.1.1.1 1000
I tried doing this on UsageDataOnlineHours by chosing min for totals but something is working right, Its still giving me every login and not total of distinct logins, and not sorting totals by nas Any Ideas? Jeff --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
