assyst Integrations

Hi,I’m struggling to find how to get a custom field value with our LUA scripts. Normally - to get a value we do something like this:ASSYSTREST:get("Event",EVENT_ID, "richRemarks.content" ) However, how do a specify the shortcode of a custom field value I want to pull?I tried something like this, but it didn’t work: ASSYSTREST:get("Event", EVENT_ID,{customFields={customFieldShortCode="NEW AUTO PAGE OUT"}}) Thank you. Martin

Hi all.We have just upgraded our test environment ETM to 1.7 which introduces the HTTP(S) to the mix and are putting it through its paces to see what we could use it for.One use case we are looking at is possibly replacing a script we have running on our integration VM. We use future actions to trigger a stop clock action, with assyst user setting the date to ‘come off hold’ and leaving the success checkbox as false. The script (SQL included below) will query the DB and find tickets due to come off hold.select top 5 act_reg_id ACT_REG_ID , act_type.act_type_n "HOLD_ACTION" , date_actioned "ACT_DATE" , act_reg.incident_id "INCIDENT_ID" , incident.incident_ref "REMIND_INC_REF" ,incident.type_enum from act_reg inner join incident on incident.incident_id = act_reg.incident_id inner join inc_data on incident.incident_id = inc_data.incident_id inner join act_type on act_reg.act_type_i

We need to sync accountExpires date field from AD in usr_flag2 field of contact user. I am able to sync the data but the data seems to be in datetime or other format.  For example expiry date for a user is set Monday June 3,2024 in AD but when i run the CUG process the value it updates in usr_flag2 field is 1336194720. How can I update the field with proper date format?     

We are trying to implement Teams integration for one of our clients using the Service Principal due to the active MFA on their accounts.Can someone who has already done this integration give us some more information regarding the certificate to use?We have provided our client with the following documentation but they are having some difficulty in providing the certificate.https://wiki.axiossystems.com/assyst11-7Wiki/index.php/Integrations:Deploying_the_assyst_Virtual_Agenthttps://learn.microsoft.com/en-us/entra/identity-platform/howto-create-servi

Hi Everyone,Would anyone have experience implementing the STMP Gateway in iPaaS?I’m referring to this:IPaaS SMTP Gateway - assyst11-8Wiki (axiossystems.com)IFS provided me a username and password for the gateway - however I have no clue how to input all of my MS Graph API connection credentials details for my email box.There are screenshots of configs fields in the wiki that need to be filled out - but WHERE do I input them?Thanks!Martin Provost

How is IPaaS and ETM licensed?  I understand that the account(s) must be configured as an Integrations license type in assyst.  Is there somewhere in the License form of assyst that might indicate an amount of integration licenses available, or do they piggy back on concurrent assyst users, or is it something else?James

Hi,I’m working with the Mailbox Reader ETM source files found here: https://wiki.axiossystems.com/assyst11-7Wiki/index.php/Integrations:assystETM_1.7_-_Examples Is there a way to add the triggering source email to the Event just like the legacy MBR was able to do?Thanks.Martin Provost

Looking to see if I can have a conversation with anyone who has leverage the JIRA event bridge in the legacy or ETM channel capacity.Are there any current assyst users who have implemented this in their instance? We have an internal business unit that is looking to hear from other assyst customers that have leveraged it and any lessons learned, etc.Thanks!

I know that there is a feature in Assyst 11.6 to add additional affected user but we are running 11.4.3 version which does not support this feature. We have a use case where end user will be creating a request in AssystNet and will input a additional affected user in a custom lookup field and we need to add that user as a additional affected user using custom script. Did anyone achieve this using custom script using restAPI or through ETM. Would appreciate help on this.

Hi Everyone,I’m in the process of converting our Mailbox Reader config and moving it to ETM.I was able to import the template channel/mappers and got one of my mailboxes converted successfully.However, my other mailbox is a bit more complex.I have an update_pattern setup with associated email templates like this in Mailbox Reader: update_pattern = { ["\< ACK \>"] = { UPDATE_ACTION = "SERV-DEPT-ACK", ACTIONIMPPROFILE = "MBR PULSE", description_template = "template/ack_template.txt", }, ["Response/Reponse: Approved /"] = { UPDATE_ACTION = "DEC-APPROVED_APPROUVE", ACTIONIMPPROFILE = "MBR PULSE", description_template = "template/approval_template.txt", }, ["Response/Reponse: Not Approved /"] = { UPDATE_ACTION = "DEC-NOT_APPROVED_REFUSE", ACTIONIMPPROFILE = "MBR PULSE", description_template = "template/approval_template.txt",

Hi Everyone,We are trying to move our MailboxReader functionality into ETM, however, we have hit a snag.Our email box is currently configured to be accessed/read with MailboxReader via MS Graph API.However, testing our ETM using this package:https://wiki.axiossystems.com/assyst11-7Wiki/index.php/Integrations:assystETM_1.7_-_ExamplesThe configuration only has options for IMAP and POP - which is not supported with our o365 mailbox:Is there any way to enable MS Graph API access?Thanks!Martin

Are there any documentations on how to configure datamappers and channel ITOM CMDB? 

Hello,I am working on configuring an ETM channel to bulk create some event builders, and am not able to find documentation on acceptable values for eventBuilderType, eventType and usage (Event Builder Type, Event Type, Usage in ETM). ETM seems to want integer values for these fields, but the database values are letters.Are these documented anywhere? Thanks,Duncan

How can we extract Building Name, Address1, Address2, City, Province in ETM? The only value we have is Building ShortCode.

We want to update an EventMonitor/Query Profile in the ETM. This would run on a weekly basis to show last weeks closed calls. the fields that would change would be the action date to and from. We are struggling to get the ETM to recognise the Query Profile. We know we can query Query profiles using REST like this - assystREST/v2/queryProfiles/1514?onBehalfOfUser=aliashas. So assumed it would be similar with the ETM. Any Suggestions on what to try? 

​Hello,short Question: Is it possible to add/update/delete Entries into an Lookup Table via ETM?If the answer is YES: How? :-)If the answer is NO: Is this Feature on an axisting Roadmap? If not i would like to submit this as an Idea The corresponding Data is stored in the DB under:SELECT *FROM [ASSYSTETM].[dbo].[ips_config_value]WHERE [configkey] in ('data','name','headers','notes') AND [ips_config_id] = 902 -- specified ID in this caseKind RegardsChristian​

Hello,ETM Version 1.5.0Thanks to the support here in the forum, i am able to expand and access Customfields as described here: https://wiki.axiossystems.com/assyst11-6Wiki/index.php/Category:assystREST#Field_Expansion_and_Filtering However, the opposite way would now be needed: To identify an item based on the value of an CustomField via ETM.i couldn't find a way to search for Item by CustomFields inside an Datamapper.I also couldn't find a suitable variable assyst search for this task.In this specific case, it is about finding an item using the IP address, which is stored in a custom field of the item-fo

I’m working on the configuration of IPaaS after having a copy of the database from production to development.  I’m on the step of doing “assyst-config-persist:reload” which seems to be taking forever. Is this normal?

Hi, I want to fetch all events in a certain date range. Following the docs ihttps://wiki.axiossystems.com/assyst11-3Wiki/index.php/Category:assystREST#JSON_Body, I already managed to get all events from a certain department, but I can’t manage to limit the results to a daterange.  https://<assyst>/assystREST/v2/events?eventType=incident&eventStatus=open&assignedServDeptId=68 works just finehttps://<assyst>/assystREST/v2/events?eventType=incident&eventStatus=open&assignedServDeptId=68&dateLogged=2023-09-22T00:00:00Z,2023-09-22T20:00:00Z returns “Invalid Lookup Parameter: dateLogged”. Any idea on how to make this filter work?

Has anyone set a date using a javascript todays date function. I have an item movement datamapper and want to set the move date to always be todays date. 

Hello. I am trying to set a variable in an ETM data mapper based on whether an external bond exists or not. Below is my expression to set the variable to either true or false (the assyst resource for the mapper is Contact User):if (outbound.self) {        if (! outbound.self.bonds.externalIdentifier) {        false;    }else{        true;    }}else {    false;}With my test data, I know that the bond does exists, so I believe this should be evaluating to true. However, no matter if the bond exists or not in the ips_bond table, this expression always evaluates to false.I have tried just using outbound.self.bonds.externalIdentifier and outbound.self.externalIdentifier to bring back the identifier in the variable instead of setting it to true/false, but it always evaluates to null.The wiki is not clear on how this value can be used.We are running ETM 1.6 and assyst 11.4.1.Any help

Hello,We are on 11.6.3 and we use Contact User Gateway to import and update our users from AD.Are there any templates we can import to ETM or a tutorial on how we can achieve this with ETM? Thanks.

assystREST/v2/events?eventType=change&eventStatus=openassystREST/v2/events?eventType=incident&eventStatus=open how to get all events (open/pending/closed) in one query ?also how to get Service Requests because its part of Change ?    

We just upgraded from 11.3 to 11.6, and our mailbox reader services that use the logging_form parameter will not start up. We get an error that is bascially: Failed to lookup the logging form 'FORMNAME' There is always a corresponding error generated on the web server: WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component CustomisationServiceBean for method public abstract com.axiossystems.assyst.dto.customisation.custom.CustomEntityDefinitionDto[] com.axiossystems.assyst.ejb.customisation.CustomisationService.lookupCustomEntityDefinition(com.axiossystems.assyst.dto.SessionToken,com.axiossystems.assyst.lookupParameter.LookupParameter[],java.lang.String[],java.lang.Integer) throws com.axiossystems.assyst.exceptions.DAOException,com.axiossystems.assyst.exceptions.AuthorizationException: javax.ejb.EJBException: java.lang.ClassCastException It looks like it’s some type of permissions issue, but I can’t figure out wha

hi I’ve installed action processor on a windows server ( it’s an upgrade from action processor 1.9.6) , action processor start but on each action i receive the same error : 2023-02-13 16:12:26.036 [error] <0.180.0>@axios_ejb_session_wrapper:log_java_output:530 EJB Wrapper 'assystEJB_wrapper':Exception.2023-02-13 16:12:26.474 [error] <0.189.0>@axios_alua:flush_port_data:265 ALua 'action_processor_alua': Problem encountered when trying to retrieve values for the event <> (action id: 10252885): Exception: java.lang.NullPointerException stack traceback:logic\setup.lua:65: in function 'error'logic\action_processor.lua:400: in function <logic\action_processor.lua:386>(tail call): ?[C]: in function 'xpcall'bridge_support\record_queue.lua:472: in function <bridge_support\record_queue.lua:463>(tail call): ?[C]: in function 'xpcall'logic\action_processor.lua:620: in functio