User Profile Description

[Alcom]

I am trying to create a report and need to show the Text associated with a
user profile. I thought it was the file APG05PHY in IPGCFF4 however this is
showing the wrong descriptions.

Does anyone know which file holds the user description?

Regards and TIA,

Alex

[Stanisław Jańczak]

Try DSPOBJD OBJ(QSYS/*ALL) OBJTYPE(*USRPRF) OUTPUT(*OUTFILE)
OUTFILE(YOUR_FILE/YOUR_LIB)
or
DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE)
OUTFILE(YOUR_FILE/YOUR_LIB)
and then from query create report.
or You can write CL PGM and use RTVUSRPRF by Your own. An user prfile
description is hold in TEXT parm.

Użytkownik Alcom <al...@kubota.co.uk> w wiadomości do grup dyskusyjnych
napisał:3b1d...@tahiti.alcom.co.uk...

[Njål Fisketjøn]

The user description is inside the *USRPRF objects in library QSYS. Use one of the methods
mentioned in another reply, or use one of the API's QUSROBJD, QSYUSRI, etc.

--
Njål Fisketjøn, FIGU DATA AS
n...@figu.no

[Alex]

Thanks, but I should have explained my self better. I am accessing the data
through c/a into excel as a data transfer for reporting purposes. Therefor I
need to know the file name and library that holds the description of the
user id. I know it is not APG05PHY although that does contain a user
description field it is not the correct one,

Regards and TIA,

Alex

"Stanisław Jańczak" <sta...@programmer.net> wrote in message
news:3b1e...@news.vogel.pl...

[Tim]

User profiles are *NOT* stored by the system in *ANY* file whatsoever. They
are objects. As objects there are only a few supported interfaces for
extracting the information contained in the object.

I think you are confusing Unix's text based security kludge with AS/400's
integrated security.

If you need to down user profile ID's and descriptions then you must extract
the information via the IBM supplied interfaces. The easiest is to use the
DSPUSRPRF command and use the OUTFILE parameter. Then download *that* file.

"Alex" <al...@kubota.co.uk> wrote in message
news:3b2f7e1c$1...@tahiti.alcom.co.uk...

[Tom Liotta]

Alex:

Technically, there is no "file" that holds this information. User
profiles are objects of type *USRPRF and you must use a kind of object
method to retrieve a description of a user profile.

There is a possible workaround however. Not perfect, but you might be
able to make it work depending on your exact needs.

The Retrieve Disk Information (RTVDSKINF) command will create a file in
QUSRSYS named QAEZDISK. By querying this file "WHERE DIOBTP = 'USRPRF'",
*usrprf descriptions can be retrieved from the DIOBTX column. The major
thing to be aware of is that this file is not dynamic and RTVDSKINF is a
long running command because it looks at just about everything on disk.
The info is only as current as the last time RTVDSKINF was run. If
you're working a weekly kind of function, then RTVDSKINF could be run
weekly. But if you need up-to-second info regularly, then you will have
to rely on DSPOBJD, DSPUSRPRF or some other function to create your
temporary work file when you need it.

Also, you mention file APG05PHY. This is apparently some application
file on your system. I suppose it's possible that this application
maintains a file of user info someplace; but without knowing what the
application is, nobody here can give much help.

Tom Liotta

Alex wrote:
>
> Thanks, but I should have explained my self better. I am accessing the data
> through c/a into excel as a data transfer for reporting purposes. Therefor I
> need to know the file name and library that holds the description of the
> user id. I know it is not APG05PHY although that does contain a user
> description field it is not the correct one,
>
> Regards and TIA,
>
> Alex

--
Tom Liotta
PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone 253-872-7788
Fax 253-872-7904
http://www.400Security.com

[Gary Guthrie]

Why oh why would somebody run RtvDskInf to get at the text associated
with a user profile?

Is there some reason to avoid command RtvUsrPrf or API QSyRUsrI to
retrieve user profile information such as the text description?

Gary Guthrie

[Tom Liotta]

Gary:

I didn't expect anybody would simply "run RtvDskInf to get at the text
associated with a user profile" and I hoped my description of it would
indicate so. But if RtvDskInf is already being run regularly, e.g.
weekly, as a normal part of system operations, then the user profile
text info is there for the taking. Further, if RtvDskInf is not being
run regularly and there's no similar system audit/management function
otherwise being run, then (IMO) it's a reasonable place for an AS/400
shop to start, especially if experienced programmers aren't available.
Given the tone of the original request, I suspect the skills available
might be limited, possibly to "query only".

Tom Liotta

--