Versions Compared

Old Version 2

changes.mady.by.user Jonathan Muse

Saved on

compared with

New Version 3

changes.mady.by.user Jonathan Muse

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. In the SIL Manager create a new file called userLoginReport.sil

  2. Paste the following code into the file:

    Code Block
    sruct login {
    string userName;
    date loginDate;
}

string sql = "SELECT cu.user_name, " +
        "li.successdate " +
        "FROM logininfo li " +
        "JOIN user_mapping um ON um.user_key = li.username " +
        "JOIN cwd_user cu ON um.username = cu.user_name " +
        "JOIN cwd_directory cd ON cu.directory_id = cd.id " +
        "ORDER BY successdate";
        
login [] logins = sql("confluence_DB", sql);

return logins;


  3. Save the file
  4. Create a new page for the user report
  5. Add the SIL Table macro to the page
  6. Image RemovedEdit the macro
  7. Enter userLastLogin.sil for the script setting
  8. Enter "Username, Last Login Date" for the columns setting
    Image Added
  9. Save the changes to the macro

You should now see a user login report when you view the page similar to the report below.

Image Modified