10-30-2019 05:45 AM
ENVIRONMENT
Netbackup = 8.1
OS = Windows 2008R2
QUERY
How to check "Activity Monitor > job overview" detail from CLI ?
10-30-2019 06:49 AM
See the documentation for the bpdbjobs command here:
https://www.veritas.com/content/support/en_US/doc/123533878-127136857-0/v123536850-127136857
10-30-2019 06:52 AM
...and a quick test to list details about job number 1 would be :
bpdbjobs 1
bpdbjobs 1 -most_columns
bpdbjobs 1 -all_columns
...and you can collect most details for all jobs with :
bpdbjobs -most_columns -file myjobs-most.txt
...and all details for all jobs with :
bpdbjobs -all_columns -file myjobs-all.txt
10-30-2019 06:56 AM
The most_columns data should be quite easy to process.
The all_columns data contains two embedded expanding lists, and can prove to be quite tricky for scripting newbies to grasp. See this for some clues:
http://www.backupcentral.com/forum/7/37538/bpdbjobs_-all_columns
11-01-2019 12:46 AM
Not able to cut specific line from this command
11-01-2019 12:58 AM
Hi @Zahid_Haseeb, apologies but I don't understand what you mean with "Not able to cut specific line from this command". Please could you explain in more detail ?
11-01-2019 01:13 AM - edited 11-01-2019 01:15 AM
bpdbjobs gives a detailed output. I only want to see specific line or string like I only want to grep TFSDATABASEB.MSSQL7.TFSDB.db.TFS02_Warehousedata01
Like bpdbjobs -all_columns | find "TFSDATABASEB.MSSQL7.TFSDB.db.TFS02_Warehousedata01" is failed or PS command is also failed to grep
11-01-2019 01:25 AM
Ok the detail you need, i.e. that of resolved database names in SQL backup jobs, is revealed within only the -all_columns style output. As noted previously, this itself will be embedded within the try list, see the bpdbjobs documentation here:
https://www.veritas.com/content/support/en_US/doc/123533878-127136857-0/v123536850-127136857
...which at the very end says :
"Show the sample logic to decode -all_columns output to produce the backup initiation time of a job that succeeded, but not on the first try."