This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

TriggerQueryDesign and ResetQueryDesign fields ?

These live in the AlertDefinitions table for the Beta Alerting Engine. Does anyone have any docs about how to decompose these into plain English for documentation of what you're alerting on? The reason this is important, is that I want to be able to get a report from the database that's readable, and be able to compare it to a stored document that should match what the report says.

Example text in that field below. I'm sure I could sit down and try to write a parser in MS Office Query or something awful, but I'd probably get it wrong....

<QUERY><KIND>1</KIND><COMPLEX><CONNECTIVE>1</CONNECTIVE><CHECKED>1</CHEC
KED><SIMPLE><ADVANCED>0</ADVANCED><COMPARISON>1</COMPARISON><FUNCTION>0<
/FUNCTION><SORT>0</SORT><CHECKED>1</CHECKED><LEFTSIDEKIND>2</LEFTSIDEKIN
D><RIGHTSIDEKIND>1</RIGHTSIDEKIND><COMPARISONATTRIBUTES></COMPARISONATTR
IBUTES><FUNCTIONATTRIBUTES></FUNCTIONATTRIBUTES><LEFTFIELDPATH>Volumes.V
olume Status.Volume Percent
Used</LEFTFIELDPATH><RIGHTFIELDPATH></RIGHTFIELDPATH><LEFTVALUETYPE>0</L
EFTVALUETYPE><LEFTVALUE></LEFTVALUE><LEFTCAPTION>Volume Percent
Used</LEFTCAPTION><RIGHTVALUETYPE>5</RIGHTVALUETYPE><RIGHTVALUE>85</RIGH
TVALUE><RIGHTCAPTION>85</RIGHTCAPTION></SIMPLE><SIMPLE><ADVANCED>0</ADVA
NCED><COMPARISON>0</COMPARISON><FUNCTION>0</FUNCTION><SORT>0</SORT><CHEC
KED>1</CHECKED><LEFTSIDEKIND>2</LEFTSIDEKIND><RIGHTSIDEKIND>1</RIGHTSIDE
KIND><COMPARISONATTRIBUTES></COMPARISONATTRIBUTES><FUNCTIONATTRIBUTES></
FUNCTIONATTRIBUTES><LEFTFIELDPATH>Volumes.Volume
Details.VolumeType</LEFTFIELDPATH><RIGHTFIELDPATH></RIGHTFIELDPATH><LEFT
VALUETYPE>0</LEFTVALUETYPE><LEFTVALUE></LEFTVALUE><LEFTCAPTION>VolumeTyp
e</LEFTCAPTION><RIGHTVALUETYPE>8</RIGHTVALUETYPE><RIGHTVALUE>Fixed
Disk</RIGHTVALUE><RIGHTCAPTION>Fixed
Disk</RIGHTCAPTION></SIMPLE></COMPLEX></QUERY>