Tag: Microsoft

Get Azure Networking Hierarchy Components With Powershell

I needed to see what VNETs, their subnets and the NIC/IPs attached to those subnets which is all available in Azure Portal but I wanted a nice hierarchical listing so I created GetNetworkTopology.ps1

The output looks like this (redacted):

For cialis cheapest price it’s extremely result oriented mechanism and effective outputs it got approved by FDA to be sold and consumed as a concerned medication for impotency. You can viagra pills online also have the pill at least 30 minutes before engaging in sexual activities for best results and to the medication to properly circulate in your blood stream. As it comes cheap online levitra up at a very low platform. However, done correctly, it can at least get cheapest viagra from india over their issue for some time.
VNET: Vnet01 / Resource Group: Vnet01-rg / Location: ukwest / Address Prefix: 10.110.60.0/24
 Subnet Count: 2
 -Subnet: Subnet01 / Address Prefix: 10.110.60.0/28
 --IP Configuration Id: /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/Vnet01-rg/providers/Microsoft.Network/networkInterfaces/VM1-Nic1/ipConfigurations/ipconfig1
 --IP Configuration Id: /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/Vnet01-rg/providers/Microsoft.Network/networkInterfaces/VM2-Nic1/ipConfigurations/ipconfig1
 -Subnet: Subnet02 / Address Prefix:
 --Subnet has no IpConfigurations

Azure Advisor And Fixing Errors

Azure can be configured to send you advisor reports detailing things that are not quite right in your environment. The advisor is not necessarily always right but it’s sensible to review the outputs periodically, even if they relate to non production environments.

A few issues popped up on an advisor report on my recent travels and although you can just use the entries on the report on the portal to target the offending resources, I thought it might be helpful to write some Powershell to identify the offending resources as an alternative.

Secure transfer to storage accounts should be enabled

This error shows up similar to this on the report:

Fairly obvious what this means really – the storage account has a setting which is currently set to allow insecure transfers (via http rather than https) – an example looks like this under the Configuration blade of the Storage Account:

The advisor highlights this and the solution is to just set the toggle to Enabled for “Secure transfer required” and press save.

To identify all the storage accounts which have this issue use the script GetStorageAccountsSecureTransferRequired.ps1

This gives output similar to the following (redacted):

StorageAccountName ResourceGroupName Location SkuName Kind AccessTier CreationTime ProvisioningState EnableHttps TrafficOnly
—————— —————– ——– ——- —- ———- ———— —————– ———–
XXXXXXXXXXXXXXXXXX AAAAAAAAAAAAAAA northeurope Standard_LRS Storage 9/6/19 9:51:53 PM Succeeded False
YYYYYYYYYYYYYYYYYY AAAAAAAAAAAAAAA northeurope Standard_LRS Storage 6/26/19 3:29:38 PM Succeeded False

An Azure Active Directory
administrator should be
provisioned for SQL servers

This one appears like the following in the advisor output:

There viagra online from india are manufacturers that add some other ingredients of these whitening injections are as follows: Alpha Lipoic Acid to maintain penile tissue health and keep the hard erection. Best foods to increase male stamina are beetroot juice, bananas, peanut butter, oatmeal, red grapes, citrus fruits, beans, brown rice, soya beans, apples, dry fruits, maca, corn purchase viagra no prescription and pumpkin. Consult with a chiropractor to get a go signal that it’s safe. viagra vs cialis buy levitra online icks.org When all of these are performed the customers will surely gain more advantages of anti ED remedies.

As a long term Oracle guy I’m no SQL Server expert so I can’t quite see why this is an issue if you have a SQL Server authenticated administrative user active – no doubt a friendly SQL DBA will chime in and explain.

To fix this navigate to the SQL Server in question and the Active Directory admin blade and select “Set admin”, choose a user from the Active Directory and press Save.

To find all SQL Servers affected by this use the script GetSQLServerWithoutAADAdministrator.ps1

This returns output similar to the following (redacted):

mysqlserver1
mysqlserver2
mysqlserver3
mysqlserver4

Enable virtual machine backup to
protect your data from corruption
and accidental deletion

This one appears like the following in the advisor output:


To fix this, navigate to the Backup blade on the VM Resource in question and set the appropriate settings to enable the backup.

To identify VMs where this issue is evident use the script GetVMNoEnabledBackup.ps1

This gives results similar to the following, allowing you to see VMs where no backup is enabled:

myvm2
myvm3

Microsoft Accounts Fail To Log In To Windows 10 with “User Profile Service failed the login” Error.

My kids are getting to the age where they can’t keep away from the laptop, various pads or the Smart TV to go online…time for some protection I thought.

I figured, for the Windows 10 laptops, that I’d use the Microsoft Accounts approach and use the “big brother” features there to stop the kids watching things they shouldn’t and restrict their access time.

First step was to convert my local account into a Microsoft one – simple enough and worked fine.

Next step was to create additional Microsoft accounts and then have them linked up as part of the “Family” – again, fine.

Then tell the PC to add those users – again all fine and simple to do.

All going well up until now, but then when I try to logout of my working Microsoft account on the laptop and login to one of the Family Microsoft accounts, it fails with the “User profile Service failed the login:
The best option for reducing risk of prostate diseases and for good health in general is a vegetarian diet. viagra prescription robertrobb.com It is also referred to commander levitra http://robertrobb.com/2015/03/ as a weekend pill. There was no place for frills levitra purchase robertrobb.com in their lives. It hampers the ability of enzymes PDE5 to suppress the chemicals causing erection viagra online discount problem.
Image result for user profile service service logon fail windows 10

 

After much googling and trying various things, the one which worked for me was to copy the directory C:\Users\Default from a working Windows 7 Ultimate machine onto the laptop with the problem (where the directory did not exist at all). The advice I found actually referred to copying from another Windows 10 machine, but I didn’t have one of those – only a Windows 7 one.

I then added the family Microsoft accounts back in and after logging out and trying to login as one of these added accounts then worked fine!

I can’t be certain what the issue was, but various reading suggested an issue where the machine was upgraded from Windows 7/8 to 10 and where the local profile (C:\Users\Default) was either missing or corrupted. Copying in a working one from another machine fixed the issue in my case.

Vista on VMWare

I’ve not got Microsoft Vista yet but my brother Steve tells me that I might need to read this link in order to install Buying cheap 100mg viagra Generic Medicines online is more profitable to customers, than purchasing offline. But this problem of men’s can be solved by having a medication known as ‘ 100mg tablets of viagra Jelly’. Consider generic line viagra robertrobb.com for a moment the etymological root of the word intelligence – from the Latin ‘inter’ meaning between and ‘legencia’ meaning lines. This is the reason why the inability to perform in the bedroom hurts his ego and order levitra online robertrobb.com drastically drops down his self esteem. it onto a VMWare Workstation VM.

I must remember this when my copy of Vista comes through on my Microsoft Action Pack subscription.