IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only
Expand all | Collapse all

Is there a way to tell what version of iACS a user has without firing it up?

  • 1.  Is there a way to tell what version of iACS a user has without firing it up?

    Posted Fri April 19, 2024 12:43 PM

    You know those software packages which scan your users systems and tell you what versions they are running?  This way you can tell if they are running an older version of Word or something you can get them upgraded?

    I'm looking for a way to tell what version of iACS is running on end users machines that these services can easily digest.



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

    #IBMiAccessClientSolutions


  • 2.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Mon April 22, 2024 01:05 PM

    Those packages have an easier time of it with installed Windows applications.  ACS (other than the Windows Application Package) isn't a Windows application that is installed.  Rather it is a Java application that is deployed.  IBM provides some deployment scripts for Windows that will deploy the client to

    %USERPROFILE%\IBM\ClientSolutions 

    or

    %PUBLIC%\IBM\ClientSolutions

    And within that deployed directory is a Documentation directory with a readmespacs.txt file contains information about all of the updates.  It is cumulative and will contain many versions but the first one, at the top of the file, is the version that is deployed in that directory path.

    Something like

    find "Version" %PUBLIC%\IBM\ClientSolutions\Documentation\readmespacs.txt

    will dump the version information.  If you have a 'head' equivalent for Windows you can strip off just the first entry.

    Of course the real wrinkle is that there are as many ways to deploy a java application as there are people deploying it.  Many admins will deploy the client to a network server so that it only needs to be updated in one place (at the expense of a whole lot more network traffic and latency for all of the users).



    ------------------------------
    Michael Swenson
    Software Engineer
    IBM
    ------------------------------



  • 3.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Tue February 03, 2026 09:52 AM

    Is it possible to do the same check from the IBM I on active connections? 



    ------------------------------
    Lars Kristensen
    ------------------------------



  • 4.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Tue February 03, 2026 10:41 AM

    You mean like Run SQL Scripts and values CURRENT CLIENT_PROGRAMID returning 

    file:/C:/Users/Public/IBM/ClientSolutions/acsbundle.jar | Version: 1.1.9.11 | Build id: 6021 | 2026-01-07 15:33:38

    See also:

    SELECT V_AUTHORIZATION_NAME, V_CLIENT_PROGRAMID, V_CLIENT_IP_ADDRESS
    FROM TABLE(QSYS2.GET_JOB_INFO('*'));

    SELECT ji.job_name, GJI.V_AUTHORIZATION_NAME, GJI.V_CLIENT_PROGRAMID, GJI.V_CLIENT_IP_ADDRESS
    FROM TABLE(QSYS2.JOB_INFO(
                           JOB_STATUS_FILTER => '*ACTIVE'
                           JOB_USER_FILTER => '*ALL'
                        )) JI,
      lateral (SELECT V_AUTHORIZATION_NAME, V_CLIENT_PROGRAMID, V_CLIENT_IP_ADDRESS
    FROM TABLE(QSYS2.GET_JOB_INFO(ji.job_name))) GJI
    WHERE GJI.V_CLIENT_PROGRAMID LIKE('%acsbundle.jar%');



    ------------------------------
    Robert Berendt IBMChampion
    Business Systems Analyst, Lead
    Dekko
    Fort Wayne
    ------------------------------



  • 5.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Tue February 03, 2026 11:05 AM

    Nice one Rob!



    ------------------------------
    Jack Woehr
    Senior Consultant
    Seiden Group LLC
    Beulah CO
    3038478442
    ------------------------------



  • 6.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Wed February 04, 2026 03:50 AM

    thanks, exactly what I looked for. 

    Br

    Lars



    ------------------------------
    Lars Kristensen
    ------------------------------



  • 7.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Wed February 04, 2026 07:34 AM

    There is a caveat on that SQL solution though:   https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4807



    ------------------------------
    Robert Berendt IBMChampion
    Business Systems Analyst, Lead
    Dekko
    Fort Wayne
    ------------------------------



  • 8.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Wed February 04, 2026 07:45 AM

    I guess it is currently filled by the JDBC driver of IBM i ACS... not by the ODBC driver of the Windows AP.

    Voted BTW !



    ------------------------------
    Paul Nicolay
    ------------------------------



  • 9.  RE: Is there a way to tell what version of iACS a user has without firing it up?

    Posted Tue February 03, 2026 11:28 AM

    When connecting to the database with iACS, there is this message in the database server job joblog:

    Message ID . . . . . . :   SQL799C       Severity . . . . . . . :   10        
    Message type . . . . . :   Information                                        
    Date sent  . . . . . . :   26-02-03      Time sent  . . . . . . :   17:20:09  
                                                                                  
    Message . . . . :   The following special registers have been set:            
      CLIENT_ACCTNG: Windows 11;SSL=true;admin_user=false, CLIENT_APPLNAME: IBM i 
      Access Client Solutions - Schemas, CLIENT_PROGRAMID:                        
      file:/C:/Users/Marco/IBM/ClientSolutions/acsbundle.jar | Version: 1.1.9.11 |
      Build id: 6021 | 2026-01-07 15:33:38, CLIENT_USERID: Marco,                 
      CLIENT_WRKSTNNAME: ASUSVIVOBOOK                                             
    Cause . . . . . :   This message is issued when any of the client special     
      registers have been updated.                                                

    Maybe it is available in the signon server job as well. If it is the case, you can add an exit program to QIBM_QZSO_SIGNONSRV exit point which analyzes the joblog and perform any appropriate action (send an alert, log the status in a table...).



    ------------------------------
    Marc Rauzier
    ------------------------------