Need report for number of users logged in - CMS7
i am in need of a report to generate the number of users logged in to our computer labs for specific periods. In particular, I need to generate a report for a specific subset of users belonging to an arm of the university which is slightly separate (financially). Our staff numbers contain 6 digits, regular students 8 digits and the ones I'm in need of at the moment the user ids contain 7 digits. Some acounts may start with a 0.
Can anyone help with the SQL for generating a report for a specific time period and possibly by campus (which can be obtained by the first 5 characters of the computer name)
Thanks in advance
University of Technology, Sydney