Best practice forum (Archived)

Report on new registrations

Hi there,

Does anyone know a way to run off a monthly report for all new registrations on to the LMS in the past month?

Linda

Permalink | Reply

Hi Linda

We do this the following way (although, no doubt there's probably a better way in Report builder).

Navigate to: Site Administration > Accounts > Browse list of users
then click on 'Show Advanced'
and set the First access value to be the 1st of the month you're interested in.

Cheers
Austen

Permalink | Show parent | Reply

Hi Austin,

Thank you for your response. When we do that it only gives us a list of users that have logged into courses in that month not actual new registrations on the system.

Any other suggestions?

Permalink | Show parent | Reply

Hi Linda

I was under the imporession the LMS home page is Course id=1 which should caputure new sign ups - sorry if that's not the case.

Cheers
Austen

Permalink | Show parent | Reply

Hi Austen,

Could you please explain in more detail what you mean?

Linda

Permalink | Show parent | Reply

There are quite a few dates associated with a user account:

timecreated - this is the one you want - the date the account was created
timemodified - last time the account details were changed
currentlogin - this is actually the time they last logged in
lastlogin - confusingly, this is actually the second to last time they logged in - the last one is stored in currentlogin
firstaccess - the first time the user ever logged into the system. This can be different from timecreated if you are using self-registration
lastaccess - the most recent time they accessed the system

It doesn't appear that the timecreated one that you are interested in appears in either Totara's report builder or the standard user report.

We could add it to report builder, but you would still need to manually create a report each month - the ideal fix would be to add a content restriction which let you specify a period of time rather than an absolute date - that way you could create the report and schedule it to be emailed every month.

I can take a look at adding that as a feature but I'm afraid it might take a while before we are able to include it in a release.

Simon

Permalink | Show parent | Reply

I've just noticed that timecreated doesn't exist in 1.1 - I'm afraid we'll only be able to provide this feature in 2.2 as the data isn't tracked in 1.1.

Simon

Permalink | Show parent | Reply

Hi,

There was a patch included in the 2.2.3 release yesterday (5th Sept 2012) that added a time created content resitriction to User reports. If you update and look at the edit view of a user report, under the content tab there should now be a section labeled "Show by time created" which should let you do what you want.

Cheers
David

Permalink | Show parent | Reply

Hi Linda,

I'm not sure if you can do it using the built in reporting capabilities within Totara. The way that we've done it is using a block called configurable reports. You can then make a report to show you all users whose "first access" was 30 days ago etc.

You can get the block from moodle here

It is not automated though, as in I don't think you can make it automatically email you a list every month. You'll have to manually go into the block and check the report though it does give you an option to download it as an excel spreadsheet.

Marcus

Permalink | Show parent | Reply

Hi Linda,

This might work, assuming that users you want to report on register using emal based self registration.

In user > borwse list of users > advanced
Choose first login within last month
Choose authenticartion method email based self registration

I don't see auth field on report builder so you can't seem to make a report like that for now.

Amir

Permalink | Show parent | Reply