How do I get list of completed jobs by run time in descending order?

[iamumairayub]

I want to get list of completed jobs that took the most time

How do I get it?

I have default Cronicle's config.json with File Storage

[jhuckaby]

I do apologize, but this feature is not available in Cronicle v1. The list of completed jobs is just a plain list, and not a sortable DB table.

I will add a TODO task to add this requested feature in Cronicle v2 (Orchestra) which DOES use a database for completed jobs. It might not make the initial release tho (I have WAY too many requested features to implement them all) but I will add it as soon as I can.

[iamumairayub]

where is this list located please?
I can copy it and sort it myself

[jhuckaby]

Alas, it is a bit complicated. The completed job data is split up across two areas in storage. First, there is a paginated linked list which lists all the jobs in the order in which they completed, but that list only has SOME of the job information. The full job data record is then stored separately using the Job ID as the key.

The list data can be retrieved using the CLI like this:

/opt/cronicle/bin/storage-cli.js list_get logs/completed

And then each individual job can be loaded to retrieve its data using this command:

/opt/cronicle/bin/storage-cli.js get jobs/JOB_ID_HERE

I hope this helps. Cronicle v2 will have a much easier way of doing this.

[iamumairayub]

Thanks, this does the job for me

[iamumairayub]

just so it helps future readers

I exported the output of

/opt/cronicle/bin/storage-cli.js list_get logs/completed

and then using Python, I printed most time consuming jobs

import json

def format_seconds(seconds):
    hours = seconds // 3600
    minutes = (seconds % 3600) // 60
    return f"{hours}h {minutes}m"

file_path = r'C:/Users/User/Desktop/cronicle_complete.txt'
with open(file_path, 'r') as file:
    data = json.load(file)

sorted_data = sorted(data, key=lambda x: float(x.get('elapsed', 0)), reverse=True)

top_20 = sorted_data[:50]

for job in top_20:
    print(f"{format_seconds(job['elapsed']):<12} | {job['event_title']}")