Brightspace Data Sets Updates

2»

Comments

  • Hi @Jonathan.W.515 - I wanted to add a note that the data is still available (just requires a bit of additional joins) by looking at the User Login BDS.

    • FirstLoginDate - look for the earliest occurrence of the UserID (so you get the first login);
    • LastAccessed - Last accessed would be the latest occurrence of the UserID login.

    I appreciate this adds an extra couple steps to reference the information; but it does eliminate risk of duplicate data in the system (as a colleague has told me, if in the same place twice, one of the places is probably wrong).

    To perform the join, just link the Users table based off UserID to the User Login BDS.

    Let me know if that is helpful in answering your question.

  • Jonathan.W.515
    Jonathan.W.515 Posts: 6 🧭

    Hi @Bruce.B.64,
    Here's the issue: the 'User Login BDS' only "contains data from 1 January 2021 onwards and adheres to the default system limit of 150 million rows of the most recent data." according to D2L's docs. The 'Data Hub' page in the LE states "This data is limited to the past two calendar years." Additionally, 'user logins' does not cover Pulse access, whereas 'LastAccessed' does.

    I need to know the 'FirstLogin' and 'LastAccessed' for the past 7 years due to data retention policies. Here's an example: "Find all the user accounts created more than 7 years ago, with no logins in the past 5 years."

    Also, for an admin who doesn't have a database/warehouse and just needs to get a list of email addresses of any account who has accessed Brightspace in the past 6 months, this change makes that extremely frustrating (joining three data sets >40 million rows in Excel) or at best, extremely tedious (copy/paste from the LE).