Hi All,

Hope you all are doing good in this pandemic time.

In various situation, we keep getting req to list out the active vs inactive interfaces in B2B integrator. But as per my understanding, we either tend to the historical communication session related info (ACT_SESSION) or historical data transfer details to reach our objective though there are caveats to that as there might be partners who send / receive data only on quarterly,half yearly or yearly basis. And our historical log may not cover older data.

Hence we may end up flagging those partners as inactive causing more issues going forward to reinstate them.

Can anyone shed some light that they might have followed to fulfill such requirement ?

------------------------------
Pranjit Biswas
------------------------------
#SupplyChain
#B2BIntegration

Hi,

I believe you are looking for an option to identify  User Logins  are Active / Inactive.

Keeping the more data ACT_SESSION impacts the performance of the system , we need to maintain the lifespan of visibility data as less as possible.

If you want to achieve the Active / Inactive userlogins or filetransfer activities then have to go for a custom solution.

Implement the UserExits available in B2Bi , build the DB design according to your requirement and store the needed info in that custom DB that you designed.

Thanks,
RadhaKrishna Gajula.

------------------------------
Radhakrishna Gajula
------------------------------

Thank you all for the response to my query..

------------------------------
Pranjit Biswas
------------------------------

Original Message:
Sent: Wed April 21, 2021 02:59 AM
From: Radhakrishna Gajula
Subject: Any standard or custom process to find active vs inactive interface in B2Bi

Hi,

I believe you are looking for an option to identify  User Logins  are Active / Inactive.

Keeping the more data ACT_SESSION impacts the performance of the system , we need to maintain the lifespan of visibility data as less as possible.

If you want to achieve the Active / Inactive userlogins or filetransfer activities then have to go for a custom solution.

Implement the UserExits available in B2Bi , build the DB design according to your requirement and store the needed info in that custom DB that you designed.

Thanks,
RadhaKrishna Gajula.

------------------------------
Radhakrishna Gajula
------------------------------

Hi Pranjit,

Yes, you are correct, to check whether the interface is active/inactive, you can verify ACT-SESSION, workflow_context, audit reports etc. but since we use to keep limited period data in SI, so its difficult. In few customer scenario, I found that they created some custom table and use to keep some reference for latest transaction (& use to clean old data), few customer take the reference from backend applications.

Regards,
Shreekant

------------------------------
Shreekant Prasad
------------------------------

One solution, depending on your configuration.  If your partner logins are tied to a virtual root mailbox, you can use the last modification time on the mailbox to determine activity levels and act accordingly.  If you segregate partner mailboxes from other routing mailboxes, you can adjust the SQL query where clause below as needed.

SELECT mm.PATH, mm.LAST_MODIFICATION
FROM MBX_MAILBOX mm
JOIN MBX_MATCH_MBX mmm on mm.MAILBOX_ID = mmm.MAILBOX_ID
JOIN MBX_RULE mr on mmm.RULE_ID = mr.RULE_ID
JOIN MBX_RULE_DESCR mrd on mr.RULE_ID = mrd.RULE_ID and mrd.DESCRIPTION in ('NameOfYourRoutingRule')
WHERE DATEDIFF( MM, mm.LAST_MODIFICATION, GETDATE() ) > 6
ORDER BY FORMAT(mm.LAST_MODIFICATION,'YYYYMMDD') desc, mm.PATH

Highlighted parts above may need to be adjusted for your database type and the name of your Sterling mailbox Routing Rule.  You also need the following property set in customer_overrides.properties and a Sterling restart to enable the last_modification value.

$SI_HOME/properties/customer_overrides.properties
mailbox.updateMailboxLastModification=true

------------------------------
Michael Geier
IT Engineer 3
Enterprise Holdings, Inc
St. Louis MO
------------------------------