How to grep the date and backup from log file?

#1
Is there any way or we can write a script available that can pull the PROGRESS BACKUP STATUS INFO from the log file?
I did a grep on “BACKUP” and it pulls the correct information, but unfortunately, there is no time date stamp associated.

The end goal would look like this:

Selection Date Range:

Start Date: 07/6/2018

End Date: 7/7/2018


Output:

Date: Mon July 6 20:00 2018

20:03:28 BACKUP 10: Full Backup Started

20:51:44 BACKUP 10: Full Backup Successfully Completed


Date: Mon July 7 20:00 2018

20:03:28 BACKUP 10: Full Backup Started

20:51:44 BACKUP 10: Full Backup Successfully Completed
 

RealHeavyDude

Well-Known Member
#2
You seem to use a extremely outdated version of Progress. In recent versions of Progress OpenEdge the log files contain a timestamp. What version do you use?
 

Cringer

ProgressTalk.com Moderator
Staff member
#3
In all honesty I'd install ProTop. The fully free version of it includes details of the last backup in the portal, and of course it's available on the Character client. THe paid version also includes the reporting of start/stop to the portal along with a host of other monitoring features. Why reinvent the wheel.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#6
You can also get the date of the last full backup from the database:
Code:
find dictdb._dbstatus.
display _dbstatus._dbstatus-fbdate.

┌────────────────────────┐
│Most recent full backup │
│────────────────────────│
│Fri Jul 13 08:48:49 2018│
└────────────────────────┘
 
#7
You can also get the date of the last full backup from the database:
Code:
find dictdb._dbstatus.
display _dbstatus._dbstatus-fbdate.

┌────────────────────────┐
│Most recent full backup │
│────────────────────────│
│Fri Jul 13 08:48:49 2018│
└────────────────────────┘
Can you help the same with some Unix or progress commands to get the start time and end time?
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#9
The _dbstatus._dbstatus-fbdate field gives you the start time of the backup. The end time isn't in the VSTs as far as I'm aware. If you want that you would have to grep the log file for (1364) messages.
08:48:49 Full backup successfully completed. (1364)

You should also deal with the absence of that message, e.g.:
11:21:48 BACKUP 5: Backup terminated due to errors. (1617)
 
#10
Rob is right, I brain cramped. The backup timestamp is effectively what your "as of" timestamp would be if you restored that backup. Which is the *start* of the backup, not the end.
 
#11
And no matter how you slice it there is no simple grep command (or anything else) that will give you the starting and ending timestamps for a v9 backup.
 
Top