O! My beloved motherI love you moreYou gave me birthTo look the world. You prepare food for meWhen I was childYou love me and make me greatI became glad. You wash my clothesWhen I was childI want to meet youBut you are not in the world. Your beloved son is […]
बाल दिवस
खोइ केहो बाल दिवस भनेकोजहाँ बालकहरुलाईे हेला हुन्छखोइ के हो बाल अधिकार भनेकोजहाँ बालकहरुको अधिकार सोशण हुन्छ । भन्छन बालक भविष्यका कर्णधार हुन्तर त्यही बालक भइरहेछ होटलका नोकरभन्छन बालक एक भविष्यका तारा हुनतर त्यही बालक भइरहेछ एउटा खाते गर्नुपर्छ मद्दत हामीले बालकहरुलाईदिनुपर्छ अधिकार हामीले बालकलाईयसैलाइृ भन्छन सबैलेयहि हो बाल दिवस […]
Delete duplicate record from oracle table
you must use the rowid column to delete the duplicate record delete from table_namewhere rowid not in (select min(rowid) from table_name group by c1,c2,c3) e.g:delete from employeeswhere rowid not in (select min(rowid) from employees group by employee_id, first_name,last_name)
Bulk update/modify email signature using powershell
$import= import-csv -Path ‘\email-list.csv’ #location of CSV file $import | ForEach-Object { }
Bulk Add/Push Office365 Email Signature using powershell
$import= import-csv -Path ‘<PATH_TO_CSV_FILE>email-list.csv’ #location of CSV file $import | ForEach-Object { $sig = Get-Mailbox -Identity $_.identity.trim() Set-MailboxMessageConfiguration -Identity $sig.Alias -DefaultFontName ‘Arial’ -AutoAddSignature $true -AutoAddSignatureOnReply $true -SignatureHtml “<html><body><table border=’2′ cellspacing=’3′ cellpadding=’3′ style=’font-family:arial;’ width=’100%’> <tbody> <tr> <td rowspan=’2′ valign=’middle’ style=’width:200px;’ align=’center’><a href=’http://rajanmaharjan.com/?utm_source=logo&utm_medium=signature’ target=’_blank’ ><img src=’http://rajanmaharjan.com.np/logo.png’ /></a> <p style=”margin-top:20px”> <span><a href=’https://www.facebook.com/maharjan.rajan” target=”_blank” […]
Push HTML Format Email Signature in Office365 from powershell
$sig = Get-Mailbox -Identity “rajan.maharjan” Set-MailboxMessageConfiguration -Identity $sig.Alias -DefaultFontName ‘Arial’ -AutoAddSignature $true -AutoAddSignatureOnReply $true -SignatureHtml “<html><body><table border=’2′ cellspacing=’3′ cellpadding=’3′ style=’font-family:arial;’ width=’100%’><tbody><tr><td rowspan=’2′ valign=’middle’ style=’width:200px;’ align=’center’><a href=’http://rajanmaharjan.com/?utm_source=logo&utm_medium=signature’ target=’_blank’ ><img src=’http://rajanmaharjan.com.np/logo.png’ /></a><p style=’margin-top:20px’><span><a href=’https://www.facebook.com/maharjan.rajan’ target=’_blank’ rel=’noopener’><img alt=’facebook icon’ style=’border:0; height:25px; width:25px;’ src=’http://rajanmaharjan.com/icons/facebook.png’ width=’15’ border=’0’></a> </span> <span><a href=’https://twitter.com/rajan_maharjan’ target=’_blank’ rel=’noopener’><img alt=’twitter icon’ style=’border:0; height:25px; […]