TSM query from activity log message formatting

[yuki]

Hello all,

Using command:

SELECT MESSAGE from ACTLOG where MSGNO=4143 and nodename='XXXX' and date_time between '%s' and '%s'

Result:

ANE4143I Total number of virtual machines failed: 1(SESSION: 2109)

Is it possible to get only number of failed VMs?

I need only numeric value of failed VMs...

Same thing about names of VMs with MSGNO 4142, how to get only VM name from message?

 

[chad_small]

use the SUBSTR option in your select, then you can gather just the number and just the name.

 

[yuki]

Thanks Chad,

I got script work good enough, for VMs with longer names than "normal" i just take first letters and ignore rest.