This script tracks the number of tickets closed within a specified interval and stores this information in Eliona’s heap storage. By monitoring closed tickets over time, you can analyze trends and activity levels, helping with workload management or identifying potential areas for operational improvement.
- Configuration:
- The script is configured to count tickets closed within a user-defined interval (default: 5 minutes).
- Ticket Count Retrieval:
- An SQL query counts the tickets marked as closed within this interval.
- Data Storage:
- The count of closed tickets is stored in the Eliona heap under a designated attribute, making it accessible for further analysis or visualization.
Specify the interval at which to check for closed tickets. The default is set to 5 minutes
, but this can be adjusted:
INTERVAL = "5 minutes" # Adjust the interval as needed
Identify the Global Asset Identifier (GAI) under which the ticket statistics will be stored in Eliona:
GAI = "Ticket Statistik" # Update the GAI if needed
Define the subtype and attribute name for storing the ticket count:
SUBTYPE = "input" # Define the attribute subtype as 'input' for heap storage
ATTRIBUTE_NAME = "Geschlossene Tickets in den letzten 5 Minuten" # Update attribute name if needed
- Configure Variables: Adjust the
INTERVAL
,GAI
,SUBTYPE
, andATTRIBUTE_NAME
variables to suit your requirements. - Deploy to Script Engine: Upload the script to the Eliona Script Engine.
- Schedule for Periodic Execution: Set the script to run at regular intervals, matching the
INTERVAL
value to ensure all closed tickets are captured within each period. - View Results in Eliona: The closed ticket data will be accessible in Eliona under the specified asset attributes, as set up in the asset’s template.
This script is particularly useful for monitoring help desk or customer service teams by tracking the number of tickets resolved within specific time frames. By examining trends in ticket closures, management can assess team performance, detect peaks in activity, and adjust resources accordingly.
Ensure assets and attributes are correctly set up in Eliona to allow the script to function properly and store accurate results.