DUO Authentication Proxy Update

Purpose

This solution will update the Duo Authentication Proxy application to the latest version.

Associated Content

Content	Type	Function
CWM - Automate - Remote Monitor - ProVal - Development - Software - Update - DUO Auth Proxy	Remote Monitor	Detects the machines with older versions of the DUO Auth Proxy application.
CWM - Automate - Script - DUO Auth Proxy - Install/Update Latest Version [Global, Autofix]	Autofix Script	Updates the application for the machines detected by the monitor set.
△ Custom - Update - DUO Auth Proxy	Alert Template	Executes the Autofix Script on the machines detected by the monitor set.

Implementation

• Create a search for the Windows computers having the 'DUO Security Authentication Proxy' application installed.

• Create a group and limit it to the search created in the first step.

• Import the CWM - Automate - Script - DUO Auth Proxy - Install/Update Latest Version [Global, Autofix] script.

• Create/Import the △ Custom - Update - DUO Auth Proxy alert template.

  INSERT INTO `alerttemplate` (
   `Name`, `Comment`, `Last_User`, `Last_Date`, 
   `GUID`
  ) 
  SELECT 
   '△ Custom - Update - DUO Auth Proxy' AS `Name`, 
   '△ Custom - Update - DUO Auth Proxy' AS `Comment`, 
   'PRONOC' AS `Last_User`, 
   (NOW()) AS `Last_Date`, 
   'fd4b5f87-9677-4b4f-82c4-aad647b6e201' AS `GUID` 
  WHERE 
   (
     SELECT 
      COUNT(*) 
     FROM 
      alerttemplate 
     WHERE 
      GUID = 'fd4b5f87-9677-4b4f-82c4-aad647b6e201'
   ) = '0';
  
  INSERT INTO `alerttemplates` (
   `AlertActionID`, `DayOfWeek`, `TimeStart`, 
   `TimeEnd`, `AlertAction`, `ContactID`, 
   `UserID`, `ScriptID`, `Trump`, `GUID`, 
   `WarningAction`
  ) 
  SELECT 
   (
     SELECT 
      alertactionid 
     FROM 
      alerttemplate 
     WHERE 
      `GUID` = 'fd4b5f87-9677-4b4f-82c4-aad647b6e201'
   ) AS `AlertActionid`, 
   '127' AS `DayOfWeek`, 
   '00:00:00' AS `TimeStart`, 
   '23:59:00' AS `TimeEnd`, 
   '512' AS `AlertAction`, 
   '-2' AS `ContactID`, 
   '0' AS `UserID`, 
   (
     SELECT 
      Scriptid 
     FROM 
      lt_scripts 
     WHERE 
      scriptGUID = '4f1db3c7-cf3f-11ed-bf6a-000c295e5f21'
   ) AS `Scriptid`, 
   '0' AS `Trump`, 
   'f94370da-7432-4acb-b102-022473d59d52' AS `GUID`, 
   '512' AS `WarningAction` 
  WHERE 
   (
     SELECT 
      COUNT(*) 
     FROM 
      alerttemplates 
     WHERE 
      GUID = 'f94370da-7432-4acb-b102-022473d59d52'
   ) = '0';

• Create the CWM - Automate - Internal Monitor - ProVal - Development - Software - Update - DUO Auth Proxy remote monitor on the group created in the second step.

• Assign the alert template to the monitor.