Comapring data in AS/400

115 pts.
Tags:
AS/400
As part of system cleanup, we delete the unused libraries and IDs after we get the list of IDs. If I have a list of employee numbers of my company, I need to check if they have IDs on AS400 or not. I want to compare that list of numbers with the IDs present on AS400 server. We create IDs based on employee numbers. How do I check that and is there is any program which can compare the numbers with IDs on the system? Please provide me the program which can do that.
ASKED: March 3, 2008  12:07 PM
UPDATED: March 3, 2008  3:00 PM

Answer Wiki

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

I may be mis-reading your note, but it sounds more like you have a list of IDs and want to know what user profiles are on the system that are not in the current employee ID file. If that is the case then there are various APIs and commands which can provide a list of user profiles. By checking this list against your employee file you could identify which profiles are no longer needed and perform the necessary cleanup. You will of course want to make sure you don’t inadvertently delete any profiles created by IBM products (or any other products you may have installed).

To get a list of profiles you could either use Security related commands/APIs or object related commands/APIs (asking for objects that are user profiles). For APIs, you might check <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/qsylautu.htm”>List Authorized Users</a> or <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/quslobj.htm”>List Objects</a>.

Discuss This Question: 1  Reply

 
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
  • AnchorS
    Another "Lower Tech" answer is to use the DPSUSRPRF command and dump the information to a file. Either query against it, or take the information into a spreadsheet. DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIB/DSPUSRPRF) You can also use the command to list the objects ownded by the user.
    380 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