Is there some trick to getting the translation working? "AS" in the query below fails...

Here is the Query:

SELECT c.FirstName AS first_name,
             c.LastName AS last_name,
             c.Company AS company_name,
             r.RepID AS rep_id,
             r.RepName AS rep_name,
             c.CustomerID AS om_customer_id
FROM Customers c
LEFT JOIN RepManufacturer r ON r.RepID = c.Integer5
WHERE (c.FirstName LIKE '%todd test%' OR c.LastName LIKE '%todd test%' OR c.FullName LIKE '%todd test%' OR c.Email LIKE '%todd test%' OR c.Phone LIKE '%todd test%' OR c.Company LIKE '%todd test%')

Which gives me this array result on our Unix Ubuntu web server.. so basically it just totally ignores the ‘AS’ and retains the orginal name

Array ( [0] => Array ( [FirstName] => Todd testing [LastName] => Sprind testing [Company] => OurCompany [RepID] => 658 [RepName] => Dan The Man [CustomerID] => 2171 ) [1] => Array ( [FirstName] => todd TEST [LastName] => sprind TEST [Company] => ourcompany.com [RepID] => [RepName] => [CustomerID] => 2172 ) [2] => Array ( [FirstName] => TEST Todd [LastName] => TEST Sprind [Company] => [RepID] => [RepName] => [CustomerID] => 2242 ) [3] => Array ( [FirstName] => test todd [LastName] => test spri [Company] => residential [RepID] => [RepName] => [CustomerID] => 2702 )

I have a On premise AD set up and AD connect for sync with Azure AD, here is my problem.
I've created a contact with an external email address so that it gets published in my GAL and i'm able to see that in my Office 365 admin portal under contacts but i'm unable to locate it in GAL and even Azure AD.
i'm even unable to find these contacts while adding them to a Distribution group in office 365 admin portal, what could be possibly happening ??

Syncing on prem to office 365 via adconnect and migrating mailboxes to exchange online in the cloud.  I have a couple of questions:

1.  If I migrate a users mailbox, and the user does not have a license in Office 365, will the user still migrate and have full functionality with the migrated mailbox for 30 days?  After 30 days, would this go to the recycle bin and need to be restored?

2.  I am assigning licenses through msol by using a on premises group, then have a script that reads the group and if a member set's license sku's in O365.  On some occasions (small amount), the license is added to the group, and the script goes to set a license sku but this fails.  I think this is due to giving a license to the user at some point, then taking it away.  Does giving a license set any attributes in msol which would cause this?

3.  I set a SIP address for skype for business for on prem mailboxes and accounts that are syncing to O365.  I've noticed when some accounts were migrated, that skype connection was lost and I had to re-license the user.  Any explanation why this would happen.

Really appreciate any knowledge on this.

Thanks

Dear Team,

I'm attempting to configure my first failover cluster in windows server 2016 for sql purposes across sites (different subnets). When the failover cluster goes through the validation in SITE A (DR-SQL1) the validation fails with the following errors:

 * Node DR-SQL2 is not reachable from node DR-SQL1. It is necessary that each cluster node can
    communicate each other cluster node by a minimum of one network path (though multiple paths
    are recommended to avoid a single point of failure). Please verify that existing networks
    are configured properly or add additional networks.
 * Node DR-SQL1 is not reachable from node DR-SQL2. It is necessary that each cluster node can
    communicate each other cluster node by a minimum of one network path (though multiple paths
    are recommended to avoid a single point of failure). Please verify that existing networks
    are configured properly or add additional networks.

Although when I run the same validation test from SITE B (DR-SQL2), they all pass just fine.

Any ideas where I should start looking, the firewall rules should allow all traffic to pass through between these 2 hosts.

Thank you.

We have a large AD environment and already in the process of moving to Office 365 and have a dedicated circuit in place just to handle all MS traffic. We would like to AD to VM in AZure that are running AD to extend our infrastructure to the cloud for DR purposes. I konw we have to plan out the Azure Network environment and also ensure all data stay within N.A geolocations but was wondering what other items we should consider. I am interest to hear freed back from others who are already doing this.

In know in Azure you can scope a storage account to replicate globally or to a specific. This may not be possible but wanted to confirm in o365 I do not believe you can restricted that o365 mailbox data and Onedrive date only replicate to a specific region i.e N.A only for compliance reason correct?

Hello everyone

Our company is merging with another company very soon and i need to put together a plan to migrate everything into one IT infrastructure. The management priority is to have New agency email address ready for all employees as soon as possible. So I was trying to find a best way to merge everything into one.

here is some information about both company.

Company A
Windows server 2012 AD domain :  ABC.com
Uses office 365 with Azure AD connect to sync password and users between on site AD and Office 365.
Approximate 150 employees.


Company B
Windows server 2012 AD domain :  XYZ.com
Uses office 365 with Azure AD connect to sync password and users between on site AD and Office 365. Also have Exchange 2010 to manage users with Office 365.  (I am not 100% sure if they use Azure AD connect or not, but will know soon.)
Approximate 90 employees.

Company A will be surviving organization after merger.  Once both company merges, merged company will have new name and new email address.

New Company after merger:  123.com

Management wants both agency staff to have new email at 123.com as soon as possible.  

Currently I am working on putting VPN between both companies and to setup Forest level trust between both forest. This should be done within one week or so. But I am having little hard time in putting together plan to merge both forest and both Office 365 tenants.

Should i start with creating brand new Forest with 123.com and then create 3 …

What would be a good tool/solution to export users and groups from authoritative source G-Suite over OpenLDAP and import into Active Directory under one OU in Azure?  Moving from on-premises onto Azure.
What are the options?
Thanks.

Installed the PS-AutoLab, ran TEST-SingleServer and worked OK, then needed to run  POC-MultiRole
and CLi1 and Nano server finish OK but the DC1 and S1 are stuck on the black screen with the circle dots spinning for over 24 hours. I tried twice after a full reboot. No errors in the event log. I'm using Surface Pro 4 with 16gb or RAM and over 100GB of free space. Any idea where to look?

I can ping both directions between hosts and VMs. RDP works fine in both directions as well. My Host can get to shares on the VMs

However, my VMs cannot get to network shares on the host. Thoughts at what i'm missing here?

Host is Windows Server 2016 Datacenter, VMs are a mix of 2008R2, 2012R2, and 2016