Is there a way to identify the number of logins from past 6 months? Please advise

Certified Associate Developer

Is there a way to identify the number of logins from past 6 months? I know we can access the login -audit files manually but that would take a lot of time. Is there another easier way to fetch it via rule? Please advise.

  Discussion posts and replies are publicly visible

Parents
  • You can certainly query that file from within Appian, but doing so is a bit of a lift and it only goes back so far before you start having to deal with compressed archival copies (which maybe Appian can't do on its own).

    What's your use case?  Are you trying to do a one-off audit of a particular user?  Are you trying to build something where, going forward, you can maintain internal user audits?  Something in between?  Because if it's something you will need on a wide-scale and ongoing basis, then the best approach might be to build a tool that scrapes the previous day's audit file every single day and writes the contents to a DB table.

Reply
  • You can certainly query that file from within Appian, but doing so is a bit of a lift and it only goes back so far before you start having to deal with compressed archival copies (which maybe Appian can't do on its own).

    What's your use case?  Are you trying to do a one-off audit of a particular user?  Are you trying to build something where, going forward, you can maintain internal user audits?  Something in between?  Because if it's something you will need on a wide-scale and ongoing basis, then the best approach might be to build a tool that scrapes the previous day's audit file every single day and writes the contents to a DB table.

Children