Skip to content

Improvements for Poller Last Run Date#5478

Merged
TheWitness merged 2 commits intoCacti:1.2.xfrom
xmacan:last_run
Sep 6, 2023
Merged

Improvements for Poller Last Run Date#5478
TheWitness merged 2 commits intoCacti:1.2.xfrom
xmacan:last_run

Conversation

@xmacan
Copy link
Copy Markdown
Member

@xmacan xmacan commented Aug 31, 2023

I don't know if 1.2.x is already frozen before release. I'd like to store information about the last run time of reindex, ... I want to use this in intropage - notify if services have not been running for a long time.

If it's too late, I'll want to add it at least to 1.3

@TheWitness
Copy link
Copy Markdown
Member

First, store it as a timestamp, second, and for 1.3, store it per data query. For the CLI's I'm good with a timestamp, but duration and las runtime in the snmp_query table.

@xmacan
Copy link
Copy Markdown
Member Author

xmacan commented Sep 1, 2023

timestamp fixed. I can prepare the same for 1.3.

I don't understand "duration and las runtime in the snmp_query table." I need only last run time not duration.

@TheWitness
Copy link
Copy Markdown
Member

ALTER TABLE host_snmp_query 
ADD COLUMN last_runtime TIMESTAMP NOT NULL default current_timestamp, 
ADD COLUMN last_duration DOUBLE UNSIGNED NOT NULL default '0';

@TheWitness
Copy link
Copy Markdown
Member

But for 1.3/develop.

@TheWitness TheWitness merged commit 937c129 into Cacti:1.2.x Sep 6, 2023
TheWitness pushed a commit that referenced this pull request Sep 6, 2023
* add last_run date for reindex, rrdcleaner, ...

* change to timestamp
TheWitness pushed a commit that referenced this pull request Sep 23, 2023
* add last_run date for reindex, rrdcleaner, ...

* change to timestamp
@github-actions github-actions bot locked and limited conversation to collaborators Dec 6, 2023
@netniV netniV changed the title Last run date for reindex, cleaner, ... Improvements for Poller Last Run Date Dec 16, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants