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

2023-06-21 Thread 'Claudia Petty (Jira)' via Puppet Bugs
Title: Message Title


 
 
 
 

 
 
 

 
   
 Claudia Petty updated an issue  
 

  
 
 
 
 

 
 
  
 
 
 
 

 
 PuppetDB /  PDB-3712  
 
 
  Delete/Purge an arbitrary report from the database   
 

  
 
 
 
 

 
Change By: 
 Claudia Petty  
 
 
Labels: 
 new-feature  
 

  
 
 
 
 

 
 
 

 
 
 Add Comment  
 

  
 

  
 
 
 
  
 

  
 
 
 
 

 
 This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8)  
 
 

 
   
 

  
 

  
 

   





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.216073.1507885523000.2126.1687359361265%40Atlassian.JIRA.


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

2018-06-11 Thread Rahul Janghel (JIRA)
Title: Message Title


 
 
 
 

 
 
 

 
   
 Rahul Janghel assigned an issue to Rahul Janghel  
 

  
 
 
 
 

 
 
  
 
 
 
 

 
 PuppetDB /  PDB-3712  
 
 
  Delete/Purge an arbitrary report from the database   
 

  
 
 
 
 

 
Change By: 
 Rahul Janghel  
 
 
Assignee: 
 Rahul Janghel  
 

  
 
 
 
 

 
 
 

 
 
 Add Comment  
 

  
 

  
 
 
 
  
 

  
 
 
 
 

 
 This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)  
 
 

 
   
 

  
 

  
 

   





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-bugs@googlegroups.com.
Visit this group at https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.


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

2017-10-13 Thread Wyatt Alt (JIRA)
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Wyatt Alt commented on  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 = '';
 
 
 
 
 
 
 
2) sounds like the receive_time field, which is there right now 
 
 
 
 
 
 
 
 
 
 
 
 

 
 Add Comment 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 

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





-- 
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-bugs@googlegroups.com.
Visit this group at https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.


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

2017-10-13 Thread Neil Binney (JIRA)
Title: Message Title
 
 
 
 
 
 
 
 
 
 
  
 
 Neil Binney created an issue 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 PuppetDB /  PDB-3712 
 
 
 
  Delete/Purge an arbitrary report from the database  
 
 
 
 
 
 
 
 
 

Issue Type:
 
  New Feature 
 
 
 

Assignee:
 

 Unassigned 
 
 
 

Components:
 

 PE, PuppetDB 
 
 
 

Created:
 

 2017/10/13 2:05 AM 
 
 
 

Priority:
 
  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