System.Activities System.Activities.Statements System.Activities.Expressions System.Activities.Validation System.Activities.XamlIntegration Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections System.Collections.Generic System.Data System.Diagnostics System.Drawing System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq UiPath.Core UiPath.Core.Activities System.Windows.Markup System.ComponentModel System.Runtime.Serialization System.Xml.Serialization UiPath.Excel UiPath.Excel.Activities System.Collections.ObjectModel System.Activities.DynamicUpdate System.Reflection System.Runtime.InteropServices UiPath.Shared.Activities UiPath.DataTableUtilities UiPath.Mail UiPath.Mail.Outlook.Activities UiPath.Mail.Activities System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities System.Data.DataSetExtensions System.Runtime.Serialization UiPath.Excel UiPath.Excel.Activities.Design UiPath.Excel.Activities UiPath.System.Activities.Design System.ServiceModel Microsoft.Bcl.AsyncInterfaces System.ValueTuple System.ComponentModel.Composition System.Memory UiPath.Mail UiPath.Mail.Activities UiPath.Mail.Activities.Design System.Collections.Immutable System.Data.Entity System.Runtime.WindowsRuntime True True True False [HTMLHeader] <!DOCTYPE html><html><head><style>table { font-family: arial, sans-serif; border-collapse: collapse; width: auto;}td, th { border: 1px solid #dddddd; text-align: left; padding: 13px; } th { background-color: #ffc000; } </style></head><body><p>Hi Team,</p><p>Today we will install security patches on below Hosts.</p><p>Kindly arrange the respective Application Support Team/Teams to shut down the application services before the downtime and start the same after the downtime is over.</p><br><table> <tr> <th>Server Type</th> <th>Hostname</th> <th>Ip Address</th> <th>Operating System</th> <th>Server Role type</th> <th>Environment</th> <th>Business Owner</th> <th>Server Location</th> <th>OS type</th> <th>Activity Owner</th> <th>Patch Status</th> <th>Downtime Window</th> </tr> [HTMLFooter] ["</table></body></html>"] True [date1] [Now.AddDays(1).ToString("dd-MM-yyyy")] True True True False True [dateTest] [cdate(dt.rows(0)(col.ColumnName))] [dateColumnName] [col.ColumnName] False False True False True [dtFiltered] [dt.AsEnumerable.Where(Function(row) CDate(row(dateColumnName).ToString).Date.ToString("dd-MM-yyyy").Contains(date1) andAlso Not(row(12).ToString.Trim.Equals("Cancelled"))).CopyToDataTable] True [ServerType] [Hostname] [IpAddress] [OperatingSystem] [ServerRoleType] [Environment] [Business_Owner] [ServerLocation] [OsType] [Activity_Owner] [Patch_Status] [Downtime] True [ServerType] [Row(1).ToString] [Hostname] [Row(2).ToString] [IpAddress] [Row(3).ToString] [OperatingSystem] [Row(4).ToString] [ServerRoleType] [Row(5).ToString] [Environment] [Row(6).ToString] [Business_Owner] [Row(7).ToString] [Email] [Row(8).ToString] [ServerLocation] [Row(9).ToString] [OsType] [Row(10).ToString] [Activity_Owner] [Row(11).ToString] [Patch_Status] [Row(12).ToString] [Downtime] [Row(13).ToString] [HTMLMiddle] [" <tr> <td>"+ServerType+"</td> <td>"+Hostname+"</td> <td>"+IpAddress+"</td> <td>"+OperatingSystem+"</td> <td>"+ServerRoleType+"</td> <td>"+Environment+"</td> <td>"+Business_Owner+"</td> <td>"+ServerLocation+"</td> <td>"+OsType+"</td> <td>"+Activity_Owner+"</td> <td>"+Patch_Status+"</td> <td>"+Downtime+"</td> </tr>"+HTMLMiddle] [HTMLContent] [HTMLHeader+HTMLMiddle+HTMLFooter] True [Email] [finalMail] [finalMail+"/"+Email] [ToEmail] [String.Join(";",finalMail.Split({"/"c},StringSplitOptions.RemoveEmptyEntries).Distinct)] True False True True False False