WORKFLOW1 0 0 536 1136 1 white white gray 3 0 13300Read SAP TableRead SAP Table In RfcDestination RfcDestination 4 In String TableName AGR_1251 In SelectList RowsToRead 2 In StringList ColumnsToRead MANDTAGR_NAMEOBJECTFIELDLOW In Table Filter In String FilterMode In PairList KeyMap In Table DefaultData In Boolean TestRowsLocally false Out Table Result 6 Read AGR_1251 0 188 128 120 60 1 1 Arial 12.0 black false false false Actions 0 1 #F2F7FD #C2D0EB 2 0 255 21050Select ListSelect List AGR_NAME CP Z* I OBJECTEQS_DEVELOPIFIELDEQACTVTILOWBT0102IDELETEDEQXE 188 38 120 60 1 1 Arial 12.0 black false false false Parameters 0 1 #FCFAEF #EEE7BF 2 0 255 Rows to Read 350LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 1 2 false 10 10 gray General 0 41070RFC DestinationRFC Destination !SAP5-I47 38 128 120 60 1 1 Arial 12.0 black false false false Parameters 0 1 #FCFAEF #EEE7BF 2 0 255 SAP System 550LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 1 4 false 10 10 gray General 0 62100TableTable Z* roles with S_DEVELOP 188 218 120 60 1 1 Arial 12.0 black false false false Datasets 0 1 #FFFFF6 #C5EB96 2 0 255 750LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 1 6 false 10 10 gray General 0 83300Read SAP TableRead SAP Table In RfcDestination RfcDestination 4 In String TableName AGR_USERS In SelectList RowsToRead In StringList ColumnsToRead MANDTAGR_NAMEUNAMEFROM_DATTO_DAT In Table Filter 6 In String FilterMode In PairList KeyMap AGR_NAME AGR_NAME In Table DefaultData In Boolean TestRowsLocally false Out Table Result 10 Read AGR_USERS 0 188 308 120 60 1 1 Arial 12.0 black false false false Actions 0 1 #F2F7FD #C2D0EB 2 0 255 950LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 8 4 false 10 10 gray General 0 102100TableTable Users with access to S_DEVELOP 188 398 120 60 1 1 Arial 12.0 black false false false Datasets 0 1 #FFFFF6 #C5EB96 2 0 255 1150LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 8 10 false 10 10 gray General 0 1250LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 8 6 false 10 10 gray General 0 152100TableTable Users with access to S_DEVELOP 188 578 120 60 1 1 Arial 12.0 black false false false Datasets 0 1 #FFFFF6 #C5EB96 2 0 255 233253Create HTML ReportCreate HTML Report In Table Source1 1392 In Table Source2 In Table Source3 In String ReportName S_DEVELOP Out String ReportUrl 25 In StringList RowStatusToShow Create HTML Report 0 188 848 120 60 1 1 Arial 12.0 black false false false Actions 0 1 #F2F7FD #C2D0EB 2 0 255 252013StringString Report URL 188 938 120 60 1 1 Arial 12.0 black false false false Datasets 0 1 #FFFFF6 #C5EB96 2 0 255 2650LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 23 25 false 10 10 gray General 0 273422Read SAP Table and JoinRead SAP Table and Join In RfcDestination RfcDestination 4 In String TableName USR02 In SelectList RowsToRead In Table Source 10 Out Table Result 15 In PairList KeyMap UNAME BNAME In PairList Adds USTYP USTYP In Table DefaultData Read USR02 and join 0 188 488 120 60 1 1 Arial 12.0 black false false false Actions 0 1 #F2F7FD #C2D0EB 2 0 255 2850LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 27 10 false 10 10 gray General 0 2950LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 27 15 false 10 10 gray General 0 3050LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 27 4 false 10 10 gray General 0 1369 3430 Execute SQL In StringList Statements CREATE TABLE Result (BLOCK nvarchar(5)) SELECT Source1.USTYP FROM Source1 WHERE Source1.USTYP = 'A' IF @@ROWCOUNT = 0 INSERT INTO Result (BLOCK) VALUES ('true') ELSE INSERT INTO Result (BLOCK) VALUES ('false') In StringList Options In Table Source1 15 In Table Source2 In String String1 In String String2 Out Table Result 1372 Derive Block String 0 368 578 120 60 1 1 Arial 12.0 black false false false Actions 0 #F2F7FD #C2D0EB 255 2 0 1 1372 2100 Table Block Status 368 668 120 60 1 1 Arial 12.0 black false false false Datasets 0 #FFFFF6 #C5EB96 255 2 0 1 1374 3444 Extract Fields In Table Source 1372 In PairList ColumnsToParams BLOCK Result1 Out String Result1 1376 Out String Result2 Extract true/false Block String Value 0 368 758 120 60 1 1 Arial 12.0 black false false false Actions 0 #F2F7FD #C2D0EB 255 2 0 1 1376 2013 String Block Status (String) 368 848 120 60 1 1 Arial 12.0 black false false false Datasets 0 #FFFFF6 #C5EB96 255 2 0 1 137750LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 1369 1372 false 10 10 gray General 0 137850LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 1374 1372 false 10 10 gray General 0 137950LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 1374 1376 false 10 10 gray General 0 138050LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 1369 15 false 10 10 gray General 0 1383 2010 Boolean True = Block False = Send 368 1028 120 60 1 1 Arial 12.0 black false false false Datasets 0 1 #FFFFF6 #C5EB96 2 0 255 1381 3024 Convert Data In String ConvertType In Boolean InBoolean Out Boolean OutBoolean 1383 In Integer InInteger Out Integer OutInteger In Float InFloat Out Float OutFloat In String InString 1376 Out String OutString In StringList InStringList Out StringList OutStringList In PairList InPairList Out PairList OutPairList In SelectList InSelectList Out SelectList OutSelectList In RfcDestination InRfcDestination Out RfcDestination OutRfcDestination In Table InTable Out Table OutTable In ExternalDataSource InExternalDataSource Out ExternalDataSource OutExternalDataSource Convert Block Status to a Block Action 0 368 938 120 60 1 1 Arial 12.0 black false false false Actions 0 #F2F7FD #C2D0EB 255 2 0 1 79 3500 Send Email Send Email In String Server email1.intellicorp.com In Integer Port 25 In String Subject S_DEVELOP * ALERT * In StringList To mhugen@intellicorp.com In StringList Cc In StringList Bcc In String From LiveCompare In StringMultiline Message LiveCompare has checked all custom (Z) security roles for authorization object S_DEVELOP with ACTVT 01 or 02 and has identified the following dialog users for having this access The detailed report can be accessed here: %Url% ******************************* PLEASE DO NOT REPLY TO THIS EMAIL ******************************* In Boolean Debug false In Boolean Block 1383 In String Username In String Password Url String In 25 Send Email 0 188 1028 120 60 1 1 Arial 12.0 black false false false Actions 0 1 #F2F7FD #C2D0EB 2 0 255 138450LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 1381 1383 false 10 10 gray General 0 138550LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 79 1383 false 10 10 gray General 0 138750LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 79 25 false 10 10 gray General 0 138850LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 1381 1376 false 10 10 gray General 0 13893430Execute SQLExecute SQL In StringList Statements DELETE FROM Result WHERE USTYP <> 'A' In StringList Options CopyRows Source1 Result In Table Source1 15 In Table Source2 In String String1 In String String2 Out Table Result 1392 Remove USTYP <> A 0 188 668 120 60 1 1 Arial 12.0 black false false false Actions 0 1 #F2F7FD #C2D0EB 2 0 255 13922100TableTable Dialog Users with access to S_DEVELOP 188 758 120 60 1 1 Arial 12.0 black false false false Datasets 0 1 #FFFFF6 #C5EB96 2 0 255 139350LinkLink 0 0 0 0 #4C4C4C 1.0 0 0 4 1389 1392 false 10 10 gray General 0 139450LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 1389 15 false 10 10 gray General 0 139550LinkLink 0 0 0 0 #4C4C4C 1.0 0 4 0 23 1392 false 10 10 gray General 0 0Overviewtrue