Jira (PDB-3712) Delete/Purge an arbitrary report from the database

0 views
Skip to first unread message

Neil Binney (JIRA)

unread,
Oct 13, 2017, 5:06:03 AM10/13/17
to puppe...@googlegroups.com
Neil Binney created an issue
 
PuppetDB / New Feature PDB-3712
Delete/Purge an arbitrary report from the database
Issue Type: New Feature New Feature
Assignee: Unassigned
Components: PE, PuppetDB
Created: 2017/10/13 2:05 AM
Priority: Normal Normal
Reporter: Neil Binney

Reports are timestamped by the agent node. If the time on the node is wrong this can result in reports in the puppetdb with dates in the furture. When the time on the agent node is corrected puppetdb will discard the fresh reports as the date is older than the previous report.

To resolve this user should be able to;

1) delete/purge an arbitrary report from the database via PQL.
2) View reports based on a timestamp of when they were received by Puppetdb.

Add Comment Add Comment
 
This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe)
Atlassian logo

Wyatt Alt (JIRA)

unread,
Oct 13, 2017, 11:05:03 AM10/13/17
to puppe...@googlegroups.com
Wyatt Alt commented on New Feature PDB-3712
 
Re: Delete/Purge an arbitrary report from the database

Neil Binney FWIW it is safe to delete from the reports table in postgres with psql if necessary

delete from reports where certname = 'foo' and end_time = 'XXXX';

2) sounds like the receive_time field, which is there right now

Rahul Janghel (JIRA)

unread,
Jun 12, 2018, 1:04:02 AM6/12/18
to puppe...@googlegroups.com
Rahul Janghel assigned an issue to Rahul Janghel
 
Change By: Rahul Janghel
Assignee: Rahul Janghel
This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)
Atlassian logo

Claudia Petty (Jira)

unread,
Jun 21, 2023, 10:56:04 AM6/21/23
to puppe...@googlegroups.com
Claudia Petty updated an issue
Change By: Claudia Petty
Labels: new-feature
This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8)
Atlassian logo
Reply all
Reply to author
Forward
0 new messages