PS Query & SQL

 View Only

Soap operation transaction counts per day

  • 1.  Soap operation transaction counts per day

    Posted 07-22-2025 09:55 AM

    I'm look for a table that stores transactions for each soap service operation call.

    I found a table/view that has rest services but can not find one for soap service calls.

    Does anyone know if a table exists and what the table name is or SQL to supply the service and transaction counts per day.

    Here is SQL I have for rest services, I need to produce this for soap operations too.

    select IB_OPERATIONNAME, trunc(PUBLISHTIMESTAMP), count(*)
    from PS_AMM_SYNCLIST
    group by IB_OPERATIONNAME, trunc(PUBLISHTIMESTAMP)
    order by trunc(PUBLISHTIMESTAMP) desc, IB_OPERATIONNAME

    Thanks for any help anyone can provide.



    ------------------------------
    Paul Abitz
    Systems Coordinator for Student Records
    Kansas State University
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------
    Alliance 2026 Registration is Open!