System health status monitoring by report?

Hi,

 

we are playing with the idea, to supply our users with a general report, that tells them something about the health status/workload level of our appian server.

We have several Apps running on our on premise system an usually the server is performing well. But in several facilities in our company the overall network/infrastructure is so bad, that appian users sometimes suffer heavily from it, although our Appian Server ist doing well.

We think it may be a good source for information for our users, if we can provide them with a gerneral performance dashboard of our appian environment, telling them for example how high/low the workload level of the server, the database, the disk quota usage or the mean process time for some of our main processes are. (KPIs)

This way users can easier judge, wether it is their application or their facility environment , that is currently going crazy.

We know that there are administrator tools like the "Appian healthCheck script", which produces an Excel Output. Readable/understandable  by the administrators, but not the users.

But did anybody anywhere create something like a general server performance dashboard, that gathered at least some life performance parameters from the system and shows them with appian report abilities?

thanks for your ideas and advice.

 

Greets

Olaf

  Discussion posts and replies are publicly visible

  • Hi Olaf - we use the Log Reader application to achieve similar things - it might help you here. 

    https://community.appian.com/b/appmarket/posts/log-reader

    Otherwise you may need to create your own dashboard using information from the system.csv and other such log files. I think you may need to be a system admin to have access to the log files though. 

  • 0
    Certified Lead Developer

    Hi olafn,

    You can make use of the excel output from Appian Health Check in order to create a dashboard for users.  A java plugin can be written to parse the document and get the required data back to Appian in the form of json response. You can parse this data and make reports in Appian. Also, one of the smart services which comes along Appian Health Check named Create Health Check Package gives you log files for all the activities in the environment including the logs for Appian Objects and servers, data metrics etc. You can parse this data and create a customized report in Appian.

  • Hello Olaf, 

    This gave me some ideas to display the users a really nice dashboard about the system I would think something like what amazon does per location status. (https://status.aws.amazon.com/) that could help, 

    If you just have 1 Appian instance you can put some kind of metrics or flags like: 

    * all engines running? (red, green) yes/no (checkStatus script)

    * processor usage, memory usage, heap usage, swap usage, sessions, threads, disk usage and what ever you mentioned (as suggested by AdityaU using the system.csv)

    >> all of them as percentages (red, yellow, green) thresholds (start with high thresholds)

    >> Maybe all of them with a nice formula?

    * Add a heart beat 1) to theDatabase server,  2) to each appian server, 3) add a "select 1 from dual", 4) get the login page from the server 

    * If you want to be further and if the problems are mostly the network. create an interface that sends lets say 10 chunks or 1Kb of information maybe using a WebApi triggered by 1 button. The you can get the time at when the user clicked the button and then the system finished . 

    * More further embed a speed test, build your own or provide a link within that dashboard. (https://www.speedtest.net/)

    Finally as part of the process (level 1 support) ask them to send open the status and take a screenshot (including the date and time from the computer) as well as the speed test with the date/time.

    That way you will know where the issue could be how it was when the user reported. at the end it depends how much information you want to give to the user. maybe at the end just a big single status will be enough for them. 

    Hope this helps and please let us know what was your conclusion.  

    Jose