PowerShell Code

send email

	# Details of the Login Username and SMTP server. These can very from one 
	# Mail Service Provder to another
	$SMTPServer = "smtp.gmail.com"
	$SMTPPort = "587"
	$Username = "testingpurpose201801@gmail.com"
	$Password = "TestingPurpose_forStudents"
 
	
	#Add email address of person in to & cc  whom you are sending email (Multiple addresses should be comma separated)
	$to = "testingpurpose201801@gmail.com"
	$cc = "testingpurpose201801@gmail.com"
 
 
	$subject = "Email Subject"
	$body = "Dear Sir/Madam, 
			This is a system generated email. Please do not reply.
 
			Information: This is the important information
			Regards,
			Team XYZ
			"
 
	$message = New-Object System.Net.Mail.MailMessage
	$message.subject = $subject
	$message.body = $body
	$message.to.add($to)
	$message.cc.add($cc)
	$message.from = "testingpurpose201801@gmail.com"
 
$smtp = New-Object System.Net.Mail.SmtpClient($SMTPServer, $SMTPPort);
$smtp.EnableSSL = $true
$smtp.Credentials = New-Object System.Net.NetworkCredential($Username, $Password);
 
$smtp.send($message)

update/insert/delete to database with SQL

#=======INSERT STATEMENT=====================================================================================  
#SQL Example:  Insert into DOMAIN_SYSTEM_INFORMATION( ROW_ID,IP_ADDRESS,SERVER_NAME,OS_VERSION,STATUS) values (1,'123.123.123.123','SEVER_NAME1','Windows Server 2008','Good');
 
$connectionString= "Data Source=XE;User Id=SYSTEM;Password=SYSTEM;   Integrated Security=no"  
[System.Reflection.Assembly]::LoadWithPartialName("System.Data.OracleClient")
 
$connection = New-Object  System.Data.OracleClient.OracleConnection($connectionString)  
$connection.Open()  
       
$queryString = "Insert into DOMAIN_SYSTEM_INFORMATION( ROW_ID,IP_ADDRESS,SERVER_NAME,OS_VERSION,STATUS)  VALUES (:row_id, :ip_address, :server_name, :os_version, :status)"  
$command = New-Object System.Data.OracleClient.OracleCommand -ArgumentList $queryString, $connection  
 
$command.Parameters.Add("row_id", 100)  
$command.Parameters.Add("ip_address", "123.123.100.100")  
$command.Parameters.Add("server_name","Server100")  
$command.Parameters.Add("os_version","Windows Server 2016")  
$command.Parameters.Add("status","Server is in awesome status")
 
$command.ExecuteNonQuery()
 
#=======INSERT STATEMENT END=====================================================================================
 
#=======UPDATE STATEMENT=====================================================================================  
#SQL Example :   Update DOMAIN_SYSTEM_INFORMATION set OS_VERSION="Windows Server 2016" where ROW_ID = 1
 
$connectionString= "Data Source=XE;User Id=SYSTEM;Password=SYSTEM;   Integrated Security=no"  
[System.Reflection.Assembly]::LoadWithPartialName("System.Data.OracleClient")
 
$connection = New-Object  System.Data.OracleClient.OracleConnection($connectionString)  
$connection.Open()
 
#Update Values  
$os_version_updated="Windows Server 2016"  
$os_version_previous="Windows Server 2008"
 
#Framing Queries  
$queryString = "Update DOMAIN_SYSTEM_INFORMATION SET OS_VERSION='$os_version_updated' where OS_VERSION='$os_version_previous'"  
$command = New-Object System.Data.OracleClient.OracleCommand -ArgumentList $queryString, $connection  
 
$command.ExecuteNonQuery()
 
#=======UPDATE STATEMENT END=====================================================================================
 
#=======DELETE STATEMENT=====================================================================================  
#SQL Example : Delete from DOMAIN_SYSTEM_INFORMATION where OS_VERSION='Windows Server 2012'
 
$connectionString= "Data Source=XE;User Id=SYSTEM;Password=SYSTEM;   Integrated Security=no"  
[System.Reflection.Assembly]::LoadWithPartialName("System.Data.OracleClient")
 
$connection = New-Object  System.Data.OracleClient.OracleConnection($connectionString)  
$connection.Open()
 
#Update Values  
$os_version="Windows Server 201000"
 
#Framing Queries  
$queryString = "Delete from DOMAIN_SYSTEM_INFORMATION where OS_VERSION='$os_version'"  
$command = New-Object System.Data.OracleClient.OracleCommand -ArgumentList $queryString, $connection  
 
$command.ExecuteNonQuery()  
#=======Delete STATEMENT END=====================================================================================