Adding Additional Affected User using AssystNet in 11.4

Hi Danesho,
 

I believe this would be possible by using the Action Processor and the ETM tool.

You would need a SQL file to obtain the custom fields used within your offering within assystNET, for example:

sql([[SELECT wcpc.string_value "USER_EMAIL"
FROM jptsys_web_cust_prop AS wcp
INNER JOIN jptsys_web_cust_prop_cont AS wcpc
ON wcp.jptsys_web_cust_prop_id = wcpc.jptsys_web_cust_prop_id
WHERE wcp.jptsys_web_cust_prop_sc = 'USER EMAIL' AND wcpc.entity_id = ]] .. EVENT_ID)

You’ll also need to create a source file within your .conf file. You can do this by including the below:

    {
        name = [[ "Create Source File for additional affected users" ]],
        data_generation = [[ { "..\\sql\\Additional_Affected_User.sql" } ]],
        condition = [[ true ]],
        activities = {
                        {"log", 
                        [["Additional_Affected_User.sql SQL completed successfully"]]
                        },
                        

                { "script",
                    [[        
                                            
                            IMP_FILE_NAME = "F:\\Axios\\Test\\Automations\\RequestRemoteUpload\\AdditionalAffectedUser\\AdditionalAffectedUser_"..EVENT_ID..".csv"
                            LOGGER:info("The Impport file name is " .. IMP_FILE_NAME)
                            -- open the txt file for writing in windows binary format
                            f_handler,err = io.open(IMP_FILE_NAME,"wb")
                            -- open the file for output (writing)
                            io.output(f_handler)
                            -- do some error trapping
                            if not(f_handler) then 
                                LOGGER:error("io.open returned error: " .. err)
                                os.exit(2)
                                return
                            else
                                LOGGER:info("Opened " .. IMP_FILE_NAME.. " OK")
                            end
                            io.write(string.format("%s,%s,%s\n", "eventID", "ShortCode", "AdditionalUser”)) -- Column headers
                            io.write(string.format("%s,%s,%s\n", EVENT_ID, AFF_USR_SC, USER_EMAIL)) -- Data row
                            io.close(f_handler)                        
                            
                            BAT_FILE = "F:\\Axios\\Test\\Automations\\RequestRemoteUpload\\AdditionalAffectedUser.bat"
                            HEADER = "cd F:\\Axios\\Test\\Automations\\RequestRemoteUpload\r\n"
                            HEADER = HEADER.."PowerShell -NoProfile -ExecutionPolicy Bypass -Command "
                            HEADER = HEADER.."\"F:\\Axios\\Test\\Automations\\RequestRemoteUpload\\importtool.ps1\" -url YOUR_ENVIRONMENT_URL/assystETM/REST/  -username assystETM_USERNAME "
                            HEADER = HEADER.."-password PASSWORD_HERE  "
                            HEADER = HEADER.."-channel \"ETM_CHANNEL_NAME\" -filename \"" ..IMP_FILE_NAME.."\""
                            HEADER = HEADER.."\r\n"
                            LOGGER:info(HEADER)
                            -- open the txt file for writing in windows binary format
                            f_handler,err = io.open(BAT_FILE,"wb")
                            -- open the file for output (writing)
                            io.output(f_handler)
                            -- do some error trapping
                            if not(f_handler) then 
                                LOGGER:error("io.open returned error: " .. err)
                                os.exit(2)
                                return
                            else
                                LOGGER:info("Opened " .. BAT_FILE.. " OK")
                            end
                            io.write(string.format("%s",HEADER))
                            io.close(f_handler)
                            os.execute(BAT_FILE)
                            
                        
                    ]]
                },
        },
        "continue",
    },

For your .bat file:

cd F:\Axios\Test\Automations\RequestRemoteUpload
PowerShell -NoProfile -ExecutionPolicy Bypass -Command "F:\Axios\Test\Automations\RequestRemoteUpload\importtool.ps1" -url YOUR_ENVIRONMENT_URL/assystETM/REST/  -username ETM_USERNAME -password ETM_PASSWORD  -channel "ETM_CHANNEL_NAME" -filename "F:\Axios\Test\Automations\AdditionalAffectedUser\AdditionalAffectedUser_5255103.csv"

You can then configure your ETM data mapper to put the value ‘inbound.AdditionalUser’ as a custom contact user.

I have not tested this method but feel that this would work - this does assume that you already have the ‘importtool.ps1’ PowerShell script within your environment.

Hi, @danesho - no problem at all. Apologies, I misunderstood your question!

Can you try the below instead of the ‘Additional Affected User’ field? I cannot see the extended details of your ‘billing_approver’ variable but you will need some way to extract some kind of value from the variable (Name, ID, Short Code, etc.)

It’s also worth running an import to see if it works as it appears when I debug, it doesn’t show a value but the additional user is added to the ticket as expected.

@danesho - We are on ETM 1.5 & assyst 11.4.1, perhaps this was removed in one of your upgrades?

Is your assyst resource set to ‘Event’ at the top of the mapper?