Feature Request: Filter activity by node #1290

Closed
jasonhensler opened this Issue Jun 16, 2015 · 3 comments

Projects

None yet

4 participants

@jasonhensler
Contributor

I ran into an issue were I wanted to see who had run what on a node from rundeck. I quickly realized there does not appear to be a simple way to do this. I think it would be a great feature to be able to filter activity logs based on the node that the job was executed on.

@LoovtO
LoovtO commented Aug 7, 2015

For folks waiting for this enhancement, I had the same need and did this way (MySQL DB) for a job list:

select distinct br.report_id
from base_report br
left join execution e on ( br.id = e.id )
where e.succeeded_node_list='NODENAME' or e.failed_node_list='NODENAME';

and then filter results (here last 10 executions) with job name found:

select br.id, e.succeeded_node_list, e.failed_node_list, br.date_started, br.date_completed, br.status, br.report_id, br.title
from base_report br
left join execution e on ( br.id = e.id )
where br.report_id like '%JOBNAME%' and e.succeeded_node_list='NODENAME' or e.failed_node_list='NODENAME' order by br.id desc limit 10;
@Slm0n87
Slm0n87 commented Nov 16, 2016

+1

@gschueler
Contributor

see #2056

@gschueler gschueler added this to the 2.7.0 milestone Nov 16, 2016
@gschueler gschueler closed this Nov 16, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment