Re: Help with Date Last Used Reporting...

[MacWheel99@xxxxxxx]

Using Query more effectively seems to be a very popular topic recently on 
Midrange_L leading to various people informing us of web sites with 
downloadable solutions.  You might like to double check if any of the 
following has some of what you are looking for.

http://hkrebs.dk/fndstrsyso.html
http://archive.midrange.com/repository/extqrydef.htm
http://www.as400network.com/Resources/ClubTech/TNT400//bo400ng/AS400Q0114.htm

There were more like this in the midrange_L archives but I cut pasted what 
seemed worth me pursuing some time.

www.bvstools.com (shareware from 400 reports to e-mail etc.) from the home 
page scroll down to QRY2ERPG (see Query/400 on the web) 

>  From:    clewis@iquest.net (Chuck Lewis)
>  
>  Hi Folks,
>  
>  I need to provide a listing of all queries on the system as well as all
>  files created by a query and the date last used...
>  
>  I know how to use the wrkobjpdm command with wildcards but it doesn't
>  provide date last used. The dspobjd using *ALL for Object Name done to
>  screen OR print file includes the Date Last Used. BUT if I send it to an
>  outfile it does NOT include Date Last Used.
>  
>  Doing dspobjd with *ALL for Object Name to *PRINT with *Basic does not
>  provide it. With *Full or *Service it does but it is one MOTHER of a
>  report and would be a nightmare to dump to a DB file and edit...
>  
>  Am I missing a better way/is there some better way of doing this before
>  I "reinvent the wheel" ?
>  
>  Thanks and Happy New Year - and we should ALL be more relaxed this year,
>  eh ? ! :-)
>  
>  Chuck

As usual I am at home unconnected to work 400 where when I go in I will be on 
twinax.  I wrote a CL a month or so ago that does a DSPOBJD of *QRYDFN & 
other stuff to a file, in which we refresh the whole thing every nite so 
folks have query access to all queries that we have by a variety of sequences 
& I am pretty sure it has everything you asking for ... promises promises ... 
you been such a big help to us ... I will print out the CL & transcribe the 
steps to a later e-mail for you.  I will also do a 6 on some of our queries 
that use this & let you know some of the particulars.

I agree that DSPOBJD can be a mother of an *OUTFILE but with Query/400 or 
other tools you can go after the fields of specific interest.  It might make 
sense to use the mother collection then other software to extract just what 
you want, then clear the mother, or use QTEMP for mother, so that disk space 
consumption ends up just being what you wanted to extract from the *OUTFILE.

A lot of stuff is now obvious to us because of user (miracle of miracle) 
naming convention standards.
When they do a query - the subject title starts with INV (for inventory) or 
ACP (for accounts payable) or CST (for cost) so they can be sort selected in 
that range ... the very end of the title has the initials of the person who 
created it, so you know who to consult regarding why this or that technique 
or if it not look right.  Of course, not all users are doing this, but I 
hazard a guess that hundreds of our queries are now consistent this way.
When we do a CL to run a query from a menu & I am not the only person writing 
these, we put on the end of the line (justified for substring convenience) 
the name of the query that it runs.

There are several queries off of this & some more we plan to add.
Here is a list of all the software we added in the last 2 months.
Here is a list of queries no one has used in the last 3 months or 2 years or 
whatever (candidates for purge).
View on screen all queries relevant to a particular department.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

+---
| 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
+---