Re: How many spool files per user ?

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