|
MaryLou, The data in the QHST log is stored in physical files in the QSYS library. The names of these files are in the pattern QHST######, where the #'s are hexadecimal "numbers" (0-9, A-F). The files don't have a useful external definition, so using Query on them directly is not fun, especially since there will be multiple files involved much of the time. (I'm sure you've seen the message in QSYSOPR about "Log version QHST###### in QSYS closed and should be saved." - every time you get one of those, it's just closed one file and created a new one.) A simple way to put it into a reportable form is to create a file of your own with field definitions that fit the layout of the QHST files, then CPYF from the QHST files to your file, then Query your file. A simple CL program could use DSPFD or DSPOBJD to list the QHST files, loop around a CPYF command that selects the messages that you want, then runs whatever queries you need. Note that normally the QHST files are written to asynchronously, so that getting the absolute most recent entries from the current file is not guaranteed. To force the most recent entries to the file, just do a DSPLOG. Dave Shaw -----Original Message----- From: MaryLou Atwell [mailto:matwell@interboro.k12.pa.us] Everyone, I'm in the need to set up a program on my machine to find out what time and which users at one building actually sign on and then sign off the AS/400. I can find this information thru the "DSPLOG" command with one message ID#CPIAD12, This lists the IP address of the machine that these users are using. However, I need to filter it to the one set of IP addresses. We have the building coded with IP #'s with one range of IP #'s. I went to run a query, but I'm not sure what LIbraray to look for this information in, or if that is the way to go Any help on this is really appreciated... And I decided to try you folks first before I get lost in the phone number haze that is now IBM help line... MaryLou Atwell - Interboro School District - +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.