Hi everyone, As you know from the dashboard the least standard timeframe is the last 5 minutes, we wanted to know the last 1 minute, so I used the same script as I did before when I wanted to get the visits per day (Check the article). And just changed the time frame I now made a new script that checks the concurrent visits for the last minute. The script is below: #!/bin/bash now=$(date +"%s.%3N" | awk '{printf "%d%03d\n", $1, substr($2,1,3)}') lastmin=$(date -d "now - 1 minute" +"%s.%3N" | awk '{printf "%d%03d\n", $1, substr($2,1,3)}') scrollid=$(curl -s -X POST "<ES_IP>:9080/events/query?start=${lastmin}&end=${now}" -H"X-Events-API-Key:<API-KEY>" -H"X-Events-API-AccountName:<Your-Account-Global-Name>" -H"Content-Type:application/vnd.appd.events+text;v=2" -H"Accept:application/vnd.appd.events+json;v=2" -d"[{ \"query\": \"SELECT * FROM web_session_records\", \"mode\": \"scroll\"}]" | grep -oP '(?<="scrollid":").*?(?=",)') curlout=$(curl -s -i \ -H "Accept: application/vnd.appd.events+json;v=2" \ -H "Content-Type:application/vnd.appd.events+text;v=2" \ -H "X-Events-API-Key:<API-KEY>" \ -H "X-Events-API-AccountName:<Your-Account-Global-Name>" \ -d "[{ \"query\": \"SELECT count(*) FROM web_session_records\", \"mode\": \"scroll\", \"scrollid\":\"$scrollid\"}]" \ -X POST "http://<ES_IP>:9080/events/query?start=${lastmin}&end=${now}") echo "$curlout" | grep -o '"results":\[\[[0-9]*\]\]' | cut -d "[" -f3 | cut -d "]" -f1 Also, I made a small webserver on port 8000 that returns the output of this script: https://<Contoller_IP>:8000 Do you guys have a better way to do it? Best regards, Mohamed Ashraf Mohamed Ashraf Application Operations Engineer Platform & IT Solution Ops team Saudi Company for Visa and Travel Solutions (SVTS) Phone: +966549574746 Email: mmahmoud.c@saudivts.com  Riyadh, Saudi Arabia ... View more

Hi everyone, Problem: Unfortunately, you cannot display data more than 10K on the dashboard using ES queries. So the only way to do it is from the API. Objective: We want automation to find the last 24h visits every day just by running a script and sending an email with the results daily using Cronjob Solution: I made a script to get the total number of Nusuk website visits using AppDynamics API as it’s the only way to get the number. https://docs.appdynamics.com/appd/23.x/23.12/en/extend-appdynamics/appdynamics-apis/analytics-events-api#id-.AnalyticsEventsAPIv23.10-query-eventsQueryEvents(SingleQuery)  Challenges: 1- I had to find a way to automate the script to find the current date and time in UNIX format 2- Then, call the API with the right parameters to get the scrollID. 3- Lastly, call the API again to get the Visits number. Script tasks: Get today’s and yesterday's dates in UNIX format (13 digits) -> last 3 digits should be zeros Call the first API to get the scrollid string. Recall the API with scrollid string in the API data. Grep the results. Script: #!/bin/bash today=$(date +"%s.%3N" | awk '{printf "%d%03d\n", $1, substr($2,1,3)}') yesterday=$(date -d "yesterday" +"%s.%3N" | awk '{printf "%d%03d\n", $1, substr($2,1,3)}') scrollid=$(curl -s -X POST "<ES-IP>:9080/events/query?start=${yesterday}&end=${today}" -H"X-Events-API-Key:<your-Key>" -H"X-Events-API-AccountName:<customer-ID>" -H"Content-Type:application/vnd.appd.events+text;v=2" -H"Accept:application/vnd.appd.events+json;v=2" -d"[{ \"query\": \"SELECT * FROM web_session_records\", \"mode\": \"scroll\"}]" | grep -oP '(?<="scrollid":").*?(?=",)') curlout=$(curl -s -i \ -H "Accept: application/vnd.appd.events+json;v=2" \ -H "Content-Type:application/vnd.appd.events+text;v=2" \ -H "X-Events-API-Key:<your-key>" \ -H "X-Events-API-AccountName:<customer-ID>" \ -d "[{ \"query\": <ES_IP>\"SELECT count(*) FROM web_session_records\", \"mode\": \"scroll\", \"scrollid\":\"$scrollid\"}]" \ -X POST "http://<ES_IP>:9080/events/query?start=${yesterday}&end=${today}") echo "$curlout" | grep -o '"results":\[\[[0-9]*\]\]' | cut -d "[" -f3 | cut -d "]" -f1 You can get the variables from: 1- Account name From the license page on the Contoller UI 2- API key: https://docs.appdynamics.com/appd/23.x/23.12/en/analytics/deploy-analytics-with-the-analytics-agent/analytics-and-data-security/manage-api-keys#id-.ManageAPIKeysv23.1-CreateAPIKeys  ... View more