Status Report Text in Database

T

Tom

I am trying to query the database directly to pull text
from status reports. However, I cannot find the actual
content of the status reports in the database. Can anyone
help me locate this in the db?
 
T

Tom.

Kevin:

I have seen the both the msp_web_status_responses and the
msp_web_status_reports tables. I thought the status
report contents would be stored in the WRESP_TEXT column
of the MSP_Web_Status_Responses table.

However, the only thing I find in the text columns is what
appears to be an XML definition of the status report, not
the contents(example below). Does anyone know where the
actual contents of the status report are stored? Are they
stored outside the database?

LONGVARWCHAR</FIELDTYPE></FIELD><FIELD><FIELDNAME>SectionD
Click to expand...
ata</FIELDNAME><FIELDTYPE>LONGVARWCHAR</FIELDTYPE></FIELD><
FIELD><FIELDNAME>SectionDescription</FIELDNAME><FIELDTYPE>L
ONGVARWCHAR</FIELDTY

Thanks in advance for any help.
 
Top