Re: How many spool files per user ?

[DrFranken <midrange@xxxxxxxxxxxx>]

So right there you get the award for the best IBM i tool name. That Is 
Awesome!! The fact that it's free is a bonus!

        - Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 3/19/2019 11:13 AM, B Stone wrote:
> 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