Uncategorized

Powershell

Posted on

Powershell $session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri “https://ps.outlook.com/powershell/” -Credential $cred -Authentication Basic -AllowRedirection Import-PSSession $session Get-Mailbox Get-Recipient -ResultSize Unlimited | select DisplayName,RecipientType,EmailAddresses | Export-Csv C:\Users\Ricardo\Desktop\email-recipients.csv Get-MessageTrackingLog -Recipients xxxx.xxxxx@malla-group.com | where {($_.EventId -eq “RECEIVE”)} Agregar Permiso de Ver Mail Recipientes Primero Ver cuales son los grupos que tenemos $ Get-Group Agregarl el Mail Recipients Role al […]

Uncategorized

SugarCRM: Higlight Invalid Emails

Posted on

line-throughline-through   /var/www/html/master/include/SugarEmailAddress/templates/forDetailView.tpl Around line 42   <td style=”border:none;”>{if $address.key === ‘opt_out’}<span style=”text-decoration: line-through; background: rgba(255, 255, 0, 0.3)”>{elseif $address.key === ‘invalid’}<span style=”text-decoration: line-through; background: rgba(255, 0, 0, 0.3)”>{elseif $address.key === ‘opt_out_invalid’}<span style=”text-decoration: line-through; background: rgba(255, 0, 0, 0.3)”>{elseif $address.key === ‘primary’}<b>{elseif $address.key === ‘reply_to’ && $item.key != 0}<i>{/if} {$address.address} {if $address.key === ‘primary’}</b>&nbsp;<i>&#x28;{$app_strings.LBL_EMAIL_PRIMARY}&#x29;&#x200E;</i>{elseif $address.key […]

Uncategorized

Mysql: Table size query

Posted on

    SELECT TABLE_NAME, table_rows, data_length, index_length, ROUND(((data_length + index_length) / 1024 / 1024),2) ‘Size in MB’ FROM information_schema.TABLES WHERE table_schema = ‘mallagroup_mautic’ ORDER BY ROUND(((data_length + index_length) / 1024 / 1024),2) DESC ;

Uncategorized

Openbravo: Latest Version Install

Posted on

We have an old Community Version of Openbravo, which is super buggy and corrupted, so starting this new year, we’re interested on trying the latest version of OB. In this case we’ll be installing Openbravo Community Edition PR18Q4.1.  Additionally one of the reasons we want to install this is that we are going to install it […]

Uncategorized

Vmware: GhettoVCB

Posted on

This script was created by William Lam (https://www.virtuallyghetto.com) and is a great tool to backup your VMs with a Script.  Download the Script to your datastore Configure the Shell Create a file with the names of the VMs you want to backup (for example vmbackup) After this run the command ./ghettoVCB.sh -f vmbackup    

Uncategorized

PFSense: Turn off Interface with Script

Posted on

  On our office, we have a USB Stick as a backup for our internet. The problem is that after reviewing the log, every night it consumes about 4gb of data (not sure why).  So, for the time being, I would like to programatically disable the Interface every night and enable it every morning, this […]