Re: Reporting on DSPLOG

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Everything in the history log is already in physical files - names start 
with QHST - there can be multiple records for each message. There is 
actually more data there than you get in the *PRINT output, or even 
displaying.

The Work Management documentation and the CL Programming documentation 
both have information on the layout of the records in the QHST* physical 
files. It is not difficult to work with, just a little tedious.

I would scan the QHST* files for a certain date range, perhaps - the 
text description of the files has that range, I believe. Read through 
them, finding the seq# 1 record that has this message ID. Then find the 
remaining records for the message and combine the contents into a 
long-enough character variable.

TAA Tools also has some analysis tools for the history log - not sure if 
anything would help you there.

HTH
Vern

On 7/7/2011 2:08 PM, fbocch2595@xxxxxxx wrote:
> Hi Folks, I'm trying to get the client info from the history log, specifically the client IP address for the usrprf in the log msg CPIAD09.   DSPLOG doesn't have the option for outfile so I'm wondering if anyone has a quick way to create a report for DSPLOG that will create a report of the IP addresses from the log?  If anyone has code to share on this plz send it along.
> Thanks, Frank