Previous Topic: No Relationship ProvidedNext Topic: Implied Relationship


TSM Nodes With More Than 10 Objects Failed to Back Up

Similarly, you can join the OBJECT:

TSM_NODE "QA*”

This selects all the TSM nodes names that start with QA to the following CONDITION

TSM_NODE_OBJECTS_FAILED > 10 				

This selects all the TSM node names where more than ten objects failed to be backed up to write a query:

TSM_NODE "QA*" WHERE TSM_NODE_OBJECTS_FAILED > 10

The result is all TSM nodes with more than ten objects that failed to be backed up.

The attribute in the CONDITION (OBJECTS_FAILED) is also an attribute of the object TSM_NODE.