[PS] C:\Get-Mailbox | Group-Object -Property:Database | Select-Object Name,Count | Sort-Object Name | Format-Table -Auto
Author Archives: admin
PowerShell One-Liner: Get a Count of Exchange Server Mailboxes Per Database
21 de Maio de 2021 – 15:29
Find Exchange version with PowerShell
14 de Janeiro de 2021 – 12:20
Let’s find out the Exchange version with PowerShell. We are going to use the Get-ExchangeServer cmdlet. Run Exchange Management Shell as administrator.
C:\>Get-ExchangeServer | Format-List Name, Edition, AdminDisplayVersion
C:\>Get-ExchangeServer | Format-Table Name, Edition, AdminDisplayVersion
In the next step, we will find the Exchange Product name.
Now that we know the Exchange version build number, we can find the product name. Go to the Microsoft Docs page
A new image format for the Web
16 de Setembro de 2020 – 13:51
WebP is a modern image format that provides superior lossless and lossy compression for images on the web. Using WebP, webmasters and web developers can create smaller, richer images that make the web faster.
WebP lossless images are 26% smaller in size compared to PNGs. WebP lossy images are 25-34% smaller than comparable JPEG images at equivalent SSIM quality index.
Lossless WebP supports transparency (also known as alpha channel) at a cost of just 22% additional bytes. For cases when lossy RGB compression is acceptable, lossy WebP also supports transparency, typically providing 3× smaller file sizes compared to PNG.
How WebP Works
Lossy WebP compression uses predictive coding to encode an image, the same method used by the VP8 video codec to compress keyframes in videos. Predictive coding uses the values in neighboring blocks of pixels to predict the values in a block, and then encodes only the difference.
Lossless WebP compression uses already seen image fragments in order to exactly reconstruct new pixels. It can also use a local palette if no interesting match is found.
A WebP file consists of VP8 or VP8L image data, and a container
based on RIFF. The standalone libwebp library serves as a reference
implementation for the WebP specification, and is available from
our git repository or as a tarball.
WebP Support
WebP is natively supported in Google Chrome, Firefox, Edge, the Opera browser, and by many other tools and software libraries. Developers have also added support to a variety of image editing tools.
WebP includes the lightweight encoding and decoding library libwebp
and the command line tools cwebp and dwebp for converting
images to and from the WebP format, as well as tools for viewing, muxing and
animating WebP images. The full source code is available on the
download page.
WebP Converter Download
Convert your favorite collection from PNG and JPEG to WebP by downloading the
precompiled cwebp conversion tool for Linux, Windows or Mac OS X.
A importância dos códigos UTM
16 de Setembro de 2020 – 11:04
Qual é a fonte de tráfego (site, artigo, rede social, banner, etc.) que gera o maior volume de visitas ao seu website? Se tem dúvidas ou não sabe a resposta, este é o momento de mudar essa realidade.
Medir os resultados das suas acções, campanhas online, é um dos maiores desafios que qualquer profissional da área digital enfrenta. Saber escolher qual o canal onde deve apostar, optar por um meio em detrimento de outro, com absoluta certeza de que é uma boa decisão é um desafio. Mas não tem de ser um desafio impossível ou uma decisão arriscada, a utilização dos códigos UTM pode ser uma ajuda preciosa e reveladora em muitos casos.
O que são os códigos UTM?
Os códigos UTM (urchin tracking module) são pequenas partes de texto que são colocadas conjuntamente com o endereço web, permitindo desta forma facultar mais informações sobre esse mesmo endereço ao Google Analytics.
Esta solução foi desenvolvida pela empresa Urchin Software Corporation que acabou por ser adquirida pela Google em 2005. Daí o seu nome “urchin tracking module”.
Porque devo usar códigos UTM nos meus endereços?
Como referido anteriormente, os códigos UTM dar-lhe-ão acesso a um conjunto de informações que de outra forma seriam complicadas de medir ou mesmo identificar, para não dizer impossíveis. Ao utilizá-los irá criar um endereço único, sendo possível criar diferentes, para diferentes fontes de tráfego, meios, campanhas, etc.
Ao incluir os códigos UTM irá ter a capacidade de medir o sucesso, ou insucesso das suas campanhas, dos meios que utiliza, dos parceiros, etc. Terá dados mais fiáveis na sua conta de Analytics, sobre o número de visitas de cada um dos endereços.
Com toda a certeza, estas informações irão permitir-lhe tomar melhores decisões para o seu negócio ou projecto.
O que incluem os códigos UTM?
Um código UTM é composto pelos seguintes parâmetros:
Source: identifica a fonte de tráfego, quem está a enviar o tráfego.
Exemplos: Recursos próprios (website, newsletter, etc.), Motores de busca (google, bing, yahoo, etc.), Redes Sociais (facebook, linkedin, twitter, instagram, etc.), parceiros, etc.
Medium: refere-se ao meio utilizado para enviar o tráfego.
Exemplos: social, social-paid, email, banner, afiliado, cpc, etc.
Campaign Name: identifica o nome da campanha que enviou o tráfego.
Exemplos: welcome, parceiros, aniversario, remarketing, balckfriday, etc.
Term: utilizado apenas em campanhas pagas, é utilizado para referenciar as palavras-chave que enviaram tráfego.
Exemplos: alojamentoweb, hosting, domínios, etc.
Content: permite-nos entender qual o conteúdo responsável por enviar o tráfego, dando-nos dados relevantes para melhor entender o desempenho dos diferentes formatos.
Exemplos: banner-header, linkbio, botao-verde, post-facebook, ad-facebook, etc.
Por fim algumas recomendações:
- Utilize hífens (social-paid) em vez de underscores (social_paid).
- Defina regras para a criação de parâmetros UTM, siga-a sem excepções e evite mudar sempre que cria um novo link.
- Procure evitar a repetição de palavras em diferentes parâmetros, poderá complicar a sua leitura (ex.: utm_source=facebook&utm_medium=facebook-post).a
How to delete a file or folder with too long path – LPE Free
4 de Agosto de 2020 – 13:20
How to extract email addresses from a text file using notepad++ with no coding at all
2 de Julho de 2020 – 18:41
How to extract email addresses from a text file using notepad+
Given the following text file as input there are 3 easy steps to follow so that you can extract all email addresses contained inside the text.
Text containing email addresses
Text containing email addresses
1st Step – Find email addresses using regex match
Use the find & replace feature of notepad++
Find: (\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,4}\b)
Replace: \r\n$&\r\n
find&replace
this adds and new line before and after each email address.
Email address in new line
Email address in new line
Step 2 – Mark email addresses and bookmark lines
Mark: (\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,4}\b)
have “Bookmark Line” checked.
bookmar-email-line
Step 3 – Remove unmarked lines
Search > Bookmark > Remove Unmarked Lines
Remove unmarked lines in Notepad++
http://www.kniko.net/how-to-extract-email-addresses-from-a-text-file-using-notepad-with-no-coding-at-all/
Message size and recipient limits in Exchange Server
25 de Maio de 2020 – 11:43
Get-TransportConfig | Format-List MaxReceiveSize,MaxSendSize,MaxRecipientEnvelopeLimit
Get-TransportRule | where {($_.MessageSizeOver -ne $null) -or ($_.AttachmentSizeOver -ne $null)} | Format-Table Name,MessageSizeOver,AttachmentSizeOver
https://docs.microsoft.com/en-us/exchange/mail-flow/message-size-limits?view=exchserver-2019
Using Net User command to Display User Expiration Date
20 de Abril de 2020 – 9:08
Net user USERNAME /domain
Using Powershell
get-aduser -filter * -properties passwordlastset, passwordneverexpires |ft Name, passwordlastset, Passwordneverexpires
To display the expiration date rather than the password last set date, use this command.
Get-ADUser -filter {Enabled -eq $True -and PasswordNeverExpires -eq $False} –Properties "DisplayName", "msDS-UserPasswordExpiryTimeComputed" |
Select-Object -Property "Displayname",@{Name="ExpiryDate";Expression={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}}
Upgrading to SQL Server 2017 – VS Shell installation has failed with exit code 1638
16 de Janeiro de 2020 – 21:13
I experienced this problem as well with SQL Server 2017 Developer and it appears to be just bad planning on the part of the SQL Server installation package people. The problem is that Visual Studio 2017 installs the Microsoft Visual C++ 2017 Redistributable (x86) and (x64) and the SQL Server installation tries to install the Microsoft Visual C++ 2015 Redistributables, which it can’t because the SQL Server installation doesn’t allow you to install an older version with the newer version installed.
This Microsoft Support article presents their explanation of the problem, and their recommended workarounds.
Solution 1: Install SQL Server first before installing Visual Studio 2017.
Solution 2 (what I did):
- Uninstall the Microsoft Visual C++ 2017 Redistributable (x86) and (x64),
- install SQL Server,
- then reinstall the Microsoft Visual C++ 2017 Redistributable (x86) and (x64).
They are a little hard to find, so here are the direct links:
X64: https://go.microsoft.com/fwlink/?LinkId=746572
x86: https://go.microsoft.com/fwlink/?LinkId=746571
Note: If you don’t have Microsoft Visual C++ 2017 Redistributable installed
at all, just install it from one of the above links, and retry installing SQL Server. It should work now.
Hide Office 365 Groups from the GAL
8 de Janeiro de 2020 – 12:48
Schools may require that newly created classes are hidden from the Global Address List (GAL) in Exchange Online. Classes may be hidden through PowerShell. Use the instructions below to hide Classes created with SDS from the GAL.
Classes are represented in Office 365 as Office 365 Groups. In Exchange Online, where the GAL is built, they are called Unified Groups. Use the Get/Set-UnifiedGroup cmdlet to manage these groups through PowerShell.
Hide a single class
Launch PowerShell as an Administrator and connect to Exchange Onlineas shown below.
$UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session -DisableNameChecking
Once connected, run the command below against the Group you want to hide.
Set-UnifiedGroup -Identity <UnifiedGroupIdParameter> -HiddenFromAddressListsEnabled $true
Hide all classes created by SDS
Launch PowerShell as an Administrator and connect to Exchange Online as shown below.
$UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session -DisableNameChecking
Once connected, run the command below against all SDS-created groups.
$Groups = Get-UnifiedGroup -ResultSize Unlimited | ? {$_.PrimarySmtpAddress -like "Section_*"}
Foreach ($Group in $Groups) {Set-UnifiedGroup -Identity $Group.Name -HiddenFromAddressListsEnabled $true}
}
https://docs.microsoft.com/en-us/schooldatasync/hide-office-365-groups-from-the-gal
Home