How to find max user loggin

[raven]

I am doing a report and need to find the maximum of user loggin at the same time. I can do a search on how many people loggin during 24 Hour period, but I need to know how to find the max for certain hour or 24 hour period (ex., 10:30AM, 100 max user loggin for the day). Anybody got any clue? thanks

[tommy]

In stathistory a record is written once an hour (depemnding on the schedule file) with the current number of users logged on.



You can report on that file, each record has a timestamp.

[raven]

How do I make a schedule to do that? All I see is a bunch of field that does not make sense to me. I also use crystal report. What field should I use. So far, I have not see any field that is useful to me.

[tommy]

Lets say You want to report on the period from 01/01/02 to 01/31/02



Then you should form you select criteria with following values:



name="Connected Users" and

exact.time>'01/01/02 00:00:00' and exact.time<'01/31/02 00:00:00'



this assumes dateformat dd/mm/yy (change to whatever dateformat you use)



Then you would get a number of records with the number of users logged on in the field value. Then you can do normal Crystal Report functions on this.

[raven]

You DA MAN. Thanks :grin:

[tommy]

Moved from Howto -> Tips & tricks & questions