Find SQL Servers on the network by PowerShell


I will make simple and short. PowerShell command uses SQL Browser service to populate the local SQL servers and instances on the network. So the requirements are: SQL Browser service installed and running (or run it on a SQL server) You should be a Administrator (preferably domain admin) You have to run this command on … Continue reading Find SQL Servers on the network by PowerShell

Office 365: Send service alert emails using PowerShell


Office 365 service health information (healthy, degraded, etc.,) can be checked at Office 365 Admin console or using Office 365 Admin App on the phone. At least Office 365 Admin App (for iPhone/Android/Windows) alerts when there is a change in service status. I wrote a script for old school boys and girls who want to … Continue reading Office 365: Send service alert emails using PowerShell

Search-ADAccount for disabled, expired, inactive accounts


What would be the easiest way to list disabled accounts, inactive accounts or expired accounts from AD. You could use Get-ADUser or Get-ADObject, but they are more complicated & dealing with User attributes. I found Search-ADAccount, it’s been much easier and generating reports from AD on the fly pretty much. Search-ADAccount description and help is … Continue reading Search-ADAccount for disabled, expired, inactive accounts

Outlook removes line breaks, but Why?


When we type beautiful emails with some (apparently) extra lines (line breaks) to make the message more readable sometimes. And when it reaches the user, Outlook removes the extra lines and make the email real ugly. Then Outlook displays this message on top of the message window: We removed extra line breaks from this message. … Continue reading Outlook removes line breaks, but Why?

Exchange: Members can’t remove themselves from security groups. Please set the group to Closed…


It was interesting to see when I was trying to add a member to a “mail enabled” security group in Exchange Admin Center, I get this: Oh! I was freaking add a member…what the? Well, we have two options. One: Add the member using Active Directory Users and Computer console. It is easy, but we … Continue reading Exchange: Members can’t remove themselves from security groups. Please set the group to Closed…

List all authorized DHCP servers from Active Directory


Here is PowerShell command to list all authorized DHCP servers from Active Directory. Replace the DOMAIN and COM with your domain name in the command below. Get-ADObject -SearchBase “cn=configuration,dc=DOMAIN,dc=COM” -Filter { ObjectClass -eq 'dhcpclass' } | Select-Object Name  | Format-Table –Wrap I used format-table with wrap option to display full DHCP server name if it … Continue reading List all authorized DHCP servers from Active Directory

How to install unsigned driver (if you have to) in Windows 10?


If you tried to install a unsigned driver in Windows 10, you would hit the wall. There is no settings to allow unsigned drivers like in old Microsoft Operating Systems. This is the guide to show you how to enable unsigned drivers (& risk making Windows 10 unstable). Follow the stops to enable the Unsigned … Continue reading How to install unsigned driver (if you have to) in Windows 10?

Active Directory: Why the protected account permissions cannot be changed? what is AdminSDHolder?


If try anyone of the things below on accounts that is member of Domain Admins or Account Operators or any other protected groups, you know it can't be done. Changing permissions (add/remove/modify perms in security tab of the account properties window) Enabling Permission Inheritance (to activate a ActiveSync account on the Administrator's device) Low-level admins … Continue reading Active Directory: Why the protected account permissions cannot be changed? what is AdminSDHolder?

How to bulk add SPAM white and black list in Exchange Online Protection?


I hope you have a text files with SPAM white and black lists. If so, it’s all down to run the PowerShell command after connecting to Exchange Online. If you created custom SPAM filter policy, replace “default” in Identity property with your custom filter policy name in the commands below. Create different text files for … Continue reading How to bulk add SPAM white and black list in Exchange Online Protection?

Exchange: How to mail-enable the security group?


Say you have a AD Security Group, you want to convert to a distribution group. (When do we stop calling Distribution List…I always said DL. Now it’s distribution group..whatever!!) It’s a very easy task. There is only one requirement. Security group must be a Universal Group. if it is not a universal group already, go … Continue reading Exchange: How to mail-enable the security group?