We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------

Turn on object auditing?

or see these?  https://www.ibm.com/docs/en/i/7.5?topic=collection-authority-views

------------------------------
Robert Berendt IBMChampion
------------------------------

Original Message:
Sent: Wed November 15, 2023 11:49 AM
From: Ryan Speight
Subject: Locating Objects Used by webservice

We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------

Dear Ryan

Would you be able to supply some more information on what your application does.  Does you application use SQL to get the data you mentioned about?  If so, you can run it and then look into DB2 Plan Cache --> Show Statement (from IBM i ACS GUI) and identify your job and look at the SQL statement itself which will give you the answer.   If your application uses native IO (RPG/COBOL/CL), you may need to play around with WRKACTJOB command to work with the job you invoked and look at opened objects.

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.
------------------------------

Original Message:
Sent: Wed November 15, 2023 11:49 AM
From: Ryan Speight
Subject: Locating Objects Used by webservice

We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------

Hello Ryan,

I think the most efficient way is to use Authority Collection. Just start the collection with the user who runs your application. You even can specify the granularity of what you want to collect, in both QSYS.LIB and IFS. Don't forget to stop it once you have collected enough. Easy to find documentation on this subject. 

Guy Marmorat.  

------------------------------
Guy Marmorat
Security Expert for IBM i - Resiliane
------------------------------

Original Message:
Sent: Wed November 15, 2023 11:49 AM
From: Ryan Speight
Subject: Locating Objects Used by webservice

We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------

Hello Ryan,

If you are able to limit the activity on system for the user running the application, the easiest way to gather this information is to use Authority collection. 

When using Navigator for i => User and Groups => Users, you are able to filter for the user runing the application. A right click soon the user will open a panel with the option Authority Collection. When using the Start option and when finished using the application you can use the End option. The Display option allows you to look at the Summary, Detail, Authorisation Failures, Programs and Commands, Database Files and IFS Directories. 
when using Detail you can manage the columns to be displayed and add the Job name, Job user and Job number allowing you to filter out only the web browser application. 

When done and gathering all the info, you can also delete that data from the same spot.

Hope this helps. 

Greetings

------------------------------
Rudi Van Helvoirt
------------------------------

Original Message:
Sent: Wed November 15, 2023 11:49 AM
From: Ryan Speight
Subject: Locating Objects Used by webservice

We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------

Robert, Satid, Guy, and Rudi,

Thank you all for your input.  I will look into the authority collector.  The user space that I thought the web service was interacting with was correct.  I made a change to the user space but didn't see my issue resolved.  Namely because I didn't restart the web service.  The webservice, because it was already running, only referenced the user space on start up.

I will have to look into the tools with the new navigator even more as there seems to be quite a lot of features.  However, interestingly enough, when I click on Users under Users and Groups, nothing happens.  I may have to open a ticket with support on that.

------------------------------
Ryan Speight
------------------------------

Original Message:
Sent: Wed November 15, 2023 11:49 AM
From: Ryan Speight
Subject: Locating Objects Used by webservice

We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------

------------------------------
Robert Berendt IBMChampion
------------------------------

Original Message:
Sent: Thu November 16, 2023 01:41 PM
From: Ryan Speight
Subject: Locating Objects Used by webservice

Robert, Satid, Guy, and Rudi,

Thank you all for your input.  I will look into the authority collector.  The user space that I thought the web service was interacting with was correct.  I made a change to the user space but didn't see my issue resolved.  Namely because I didn't restart the web service.  The webservice, because it was already running, only referenced the user space on start up.

I will have to look into the tools with the new navigator even more as there seems to be quite a lot of features.  However, interestingly enough, when I click on Users under Users and Groups, nothing happens.  I may have to open a ticket with support on that.

------------------------------
Ryan Speight

Original Message:
Sent: Wed November 15, 2023 11:49 AM
From: Ryan Speight
Subject: Locating Objects Used by webservice

We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------

Dear Ryan

Apart from Navigator GUI, you can also use CL command STRAUTCOL and ENDAUTCOL. 

Please be informed that user-based authority collection is available in IBM i 7.3 and later and it will cause some performance degradation to the job(s) being collected. Make sure to stop it when done.  For more information on this, please refer to the files I attach herewith. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.
------------------------------

Original Message:
Sent: Thu November 16, 2023 01:41 PM
From: Ryan Speight
Subject: Locating Objects Used by webservice

Robert, Satid, Guy, and Rudi,

Thank you all for your input.  I will look into the authority collector.  The user space that I thought the web service was interacting with was correct.  I made a change to the user space but didn't see my issue resolved.  Namely because I didn't restart the web service.  The webservice, because it was already running, only referenced the user space on start up.

I will have to look into the tools with the new navigator even more as there seems to be quite a lot of features.  However, interestingly enough, when I click on Users under Users and Groups, nothing happens.  I may have to open a ticket with support on that.

------------------------------
Ryan Speight

Original Message:
Sent: Wed November 15, 2023 11:49 AM
From: Ryan Speight
Subject: Locating Objects Used by webservice

We have an application on our IBM i which utilizes a web browser as it's front end.  It's presenting data, but I'm not sure what files, or data areas, or user spaces it's pulling from.  Any ideas on how we can find out?

------------------------------
Ryan Speight
------------------------------