• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Looking for advise on a VM Backup reporting problem

Spree

ADSM.ORG Member
#1
There is a small VM farm, and there are around 20 "VIP" VMs that need to have individual backup schedule (mainly for reporting purpose).

In the backup proxy, there are multiple data mover nodes defined since it would be difficult to finish all backups in time if there is only 1 data mover node. Then there is a script for capturing the backup status from TSM server activity log, then sending out reports through e-mail for internal reference and some to customer.

If the report is normal, it would look like this:

===

ANS8000I Server command: 'q actlog begind=-1 begint=18:00 endd=-0 endt=now search=transferred nodename=* schedname=VM_1'.

Date/Time Message
-------------------- ----------------------------------------------------------
04/24/2019 22:17:39 ANE4961I (Session: 25, Node: DM) Total number of bytes tr
ansferred: 534.38 MB (SESSION: 25)

ANS8000I Server command: 'q actlog begind=-1 begint=18:00 endd=-0 endt=now search=Elapsed nodename=* schedname=VM_1'.

Date/Time Message
-------------------- ----------------------------------------------------------
04/24/2019 22:17:39 ANE4964I (Session: 25, Node: DM) Elapsed processing time:
00:02:52 (SESSION: 25)
===

But unforunately it will not be that "normal", the reports would stick together and making it not distinguishable between different VMs. For example, for 1st VM report:

===

ANS8000I Server command: 'q actlog begind=-1 begint=18:00 endd=-0 endt=now node=* search=transferred schedname=VM_3'.

Date/Time Message
-------------------- ----------------------------------------------------------
04/24/2019 22:25:14 ANE4961I (Session: 45, Node: DM) Total number of bytes tr
ansferred: 3.91 GB (SESSION: 45)
04/24/2019 22:26:17 ANE4961I (Session: 57, Node: DM) Total number of bytes tr
ansferred: 238.98 MB (SESSION: 57)

ANS8000I Server command: 'q actlog begind=-1 begint=18:00 endd=-0 endt=now node=* search=Elapsed schedname=VM_3'.

Date/Time Message
-------------------- ----------------------------------------------------------
04/24/2019 22:25:14 ANE4964I (Session: 45, Node: DM) Elapsed processing time:
00:06:43 (SESSION: 45)
04/24/2019 22:26:17 ANE4964I (Session: 57, Node: DM) Elapsed processing time:
00:00:58 (SESSION: 57)
===

Then for 2nd VM report nothing would return:

===

ANS8000I Server command: 'q actlog begind=-1 begint=18:00 endd=-0 endt=now node=* search=transferred schedname=VM_5'.
ANR2034E QUERY ACTLOG: No match found using this criteria.
ANS8001I Return code 11.

ANS8000I Server command: 'q actlog begind=-1 begint=18:00 endd=-0 endt=now node=* search=Elapsed schedname=VM_5'.
ANR2034E QUERY ACTLOG: No match found using this criteria.
ANS8001I Return code 11.

===

But the backup was reported successful that I can find the correpoding backup image, just that the report is not correct. Also, it's not always the same one having problems every day, it would be like, on day 1, schedule #3 has 2 entries returned but schedule #5 has no entry returned, on day 2, #3 and #5 becomes normal, but it becomes #6 has 2 entries returned and #7 has no entry returned... but all event status are successful.

Wondering if anybody can provide some advise to this... thanks.
 

marclant

ADSM.ORG Moderator
#2
You have too many options. I'm not sure that it's the cause, but it's best to keep the commands as simple and only use options that add value.
- node is not required unless you actually specify a specific node
- enddate and endtime defaults to NOW, so no need to specify that either

You basically just need:
Code:
q actlog begind=-1 begint=18:00 search=Elapsed schedname=VM_5
For something to return, obviously schedule VM_5 would have had to run and complete between yesterday 18:00 and now.

For VE reporting, most use this: DP for VMWare Reporting Enhancements, Appendix A.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 17 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 53 60.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.5%
  • Other (please comement)

    Votes: 7 8.0%

Forum statistics

Threads
31,469
Messages
134,128
Members
21,569
Latest member
srinathkodela
Top