Skip to main content
New Participant
Apr 24, 2023 4:00 PM UTC
Question

How to read login-audit.csv from 3 different servers?

Tried using the Log Reader Plugin but it does not read logs from all servers.

Any suggestion is appreciated.

Thanks 

    8 replies

    stefanhelzle0001
    Brainy
    Apr 24, 2023 4:31 PM UTC

    AFAIK, there is no solution using this plugin.

    mikes0011
    Brainy
    Apr 24, 2023 5:37 PM UTC

    In the distant past I believe I was able to cook up a brute force approach that read the log file from several process instances launched in such a way that they'd be launched on random app servers, and compared all results to each other.  I figured that if I launched enough instances (n^2 perhaps) then I was realistically guaranteed to have hit all of them.  Of course, the project I did this on is long in my past, and I haven't messed with it recently, so I can't really speak to whether this method would still realistically work.

    The Expression Guru
    christineh465186
    Participating Frequently
    Apr 25, 2023 6:58 PM UTC

    One idea is to leverage other technology. If you are on Appian cloud, you could stream the logs to a tool like SPLUNK to be ingested, consolidated, and presented. If you are self-hosting, you could set this up as well.

    Known Participant
    Jul 15, 2024 1:52 PM UTC

    I am facing same issue.

    do you have any idea how to resolve this ?

    Participating Frequently
    Jul 15, 2024 2:21 PM UTC

    Hi Yogesh,

    The original Q&A is a little vague; if you have multiple application servers in a single Appian instance then I'm not sure that I have an answer that's any better than what's above. 

    If you're in a High Availability config or other distributed topology, we've found a way to do that. It's fairly simple:

    • Determine HA node names from topology config
      • If you're on cloud, here's how
      • Navigate to your Appian Support portal
      • Go to Health tab --> Cloud Resources --> Metrics
      • Select the HA environment URL (e.g. our prod environment)
      • Your HA node names show up under "servers to display"
    • If the environment has more than once instance (e.g. when a cloud instance is high availability), prepend the server name to the log file name. Loop over the server names to get all 3 servers' logs.
      • e.g. concat([server name], "/", [log file name])
    Known Participant
    Jul 16, 2024 11:39 AM UTC

    HI [mention:c5b3abf6b7604dfface6ab6b4c67a446:e9ed411860ed4f2ba0265705b8793d05] 

    Its working fine now.

    able to fetch logs from all the servers.

    Thank you [emoticon:c4563cd7d5574777a71c318021cbbcc8]