Re: How many spool files per user ?

[B Stone <bvstone@xxxxxxxxx>]

Cyndi,

There is no doubt some SQL function that you can use.  One other option is
our SPLTOOL software (www.bvstools.com/spltool.html) has a FREE
option/command named List Spooled File Attributes (SPLATT).

This command can be used to build a PF based on any selection criteria you
want, including user.  So, you could use it to list all spooled files on
the system, then sql/count using user id as the level break.

                      List Spooled File Attributes (SPLATT)



 Type choices, press Enter.



 Output queue . . . . . . . . . .                 Name, *ALL

   Library  . . . . . . . . . . .     *LIBL       Name, *LIBL

 Spooled File . . . . . . . . . .                 *ALL, generic*, Name

 User name  . . . . . . . . . . .                 *CURRENT, *ALL, Name

 Job Name . . . . . . . . . . . .                 *ALL, generic*, Name

 Job Number . . . . . . . . . . .                 *ALL, 000000-999999

 Spooled File Number  . . . . . .                 *ALL, 1-999999

 User data  . . . . . . . . . . .                 *ALL, User data

 Form type  . . . . . . . . . . .                 *ALL, Form type

 From Date (MMDDYYYY) . . . . . .   *ALL          Number, *ALL

 To Date (MMDDYYYY) . . . . . . .   *ALL          Number, *ALL

 To file  . . . . . . . . . . . .                 To file

   Library  . . . . . . . . . . .     *CURLIB     Name, *CURLIB

 To member  . . . . . . . . . . .                 Name, *FIRST

 Replace or Add records . . . . .   *ADD          *ADD, *REPLACE

 Create file  . . . . . . . . . .   *NO           *NO, *YES


 Bottom
 F3=Exit   F4=Prompt   F5=Refresh   F12=Cancel   F13=How to use this
display
 F24=More keys


Just one option.


Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #22 <https://www.bvstools.com/mailtool.html>: Cost
starting at under $300 a year per partition!

On Tue, Mar 19, 2019 at 10:10 AM Cyndi Bradberry <CyndiB@xxxxxxxx> wrote:

> I'm looking for a way to tell individual user's how many spool files exist
> in their name on our iSeries.
>
> Previously, this hasn't been too big of an issue. But we have more
> locations and more staff and they don't know how to clean up after
> themselves. I would like to be able to target the worst offenders first and
> go from there.
>
> Currently on V7R2. Only IT has ACS, users have client access, but not iNav.
>
> Cyndi Bradberry | Application Developer
> Idaho Housing and Finance Association
> PO Box 7899, Boise, ID 83707-1899
> Phone 208-331-4775 | CyndiB@xxxxxxxx<mailto:CyndiB@xxxxxxxx>
> www.idahohousing.com<http://www.idahohousing.com>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com