Query against User Profiles

1675 pts.
Tags:
AS400 -WRKQRY
iSeries V6R1
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).
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,

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Instead of using "OR", should those be "AND" for the additional cases? Tom
    125,585 pointsBadges:
    report
  • CharlieBrowne
    Tom Yes, that is correct. Thanks for noticing.
    41,380 pointsBadges:
    report
  • TomLiotta
    Go ahead and make the change. If we don't hear more from the OP, I'll approve it. Tom
    125,585 pointsBadges:
    report
  • qmaster
    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?
    1,675 pointsBadges:
    report
  • qmaster
    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?
    1,675 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following