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