Query against User Profiles
I was trying to omit some of the user profiles,which generally starts with KMAN*,TMAN*,CMAN* from the list of all user profiles (DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE).
Software/Hardware used:
V6R1,
I'm querying this against to a outfile,i was able to select the columns what i want,but i couln't find option/feature to omit certain user profiles which start generally with common words(KMAN*,TMAN*,CMAN*)
WRKQRY is the one i'm using for that..
If anyone has some idea/thoughts on this,Pls share it with me I will try to do it
Software/Hardware used:
V6R1,
ASKED:
April 10, 2012 4:55 AM
UPDATED:
April 11, 2012 4:23 AM
Answer Wiki:
Use the option to select records.
Then you can use NLIKE
Here is samples NLIKE
<pre>
UPUPRF NLIKE '%MAN%'
Or
AND/OR Field Test Value
UPUPRF NLIKE 'CMAN%'
OR UPUPRF NLIKE 'KMAN%'
OR UPUPRF NLIKE 'TMAN%'</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
Instead of using “OR”, should those be “AND” for the additional cases?
Tom
Tom
Yes, that is correct.
Thanks for noticing.
Go ahead and make the change. If we don’t hear more from the OP, I’ll approve it.
Tom
Charlie,Tom
It is working just fine..many thanks…One more concern, I’ve few profiles where i want those profiles also included in report
i.e where we are excluding TMAN* profiles from the report,but few profiles starts just like TMANSVR* also need to be included in report
What would be the TEST value that we can use?
Okey…I’ve used below condition to satisfy my report.Working fine
OR UPUPRF LIKE ‘PGLHFTP%’
Pls correct if that is really not correct way..
and
1 .) When i moved this spooled report to my PC as a notepad ,One column is missing from report,But it is actually there in spool report,
2.) I’ve an other column,which will show users date of login(Previous sign on date) ,I wan to modify it into MM/DD/YYYY format from default format? Do we have any way for this?