Friday, 31 August 2018

Tech Roundup - 31st August 2018

Stuff collated since Tech Roundup - 22nd July 2018. With headings:
Microsoft, NetApp, NetApp Blogs, NetApp.io, Tech ONTAP Podcast, NetApp TRs, Security, Veeam, VMware

Microsoft

How to Use Notepad to Create a Log File

NetApp

On-Demand Webinars:

New 2018 Gartner Magic Quadrant for Solid State Arrays
NetApp has moved up and to the right; a leader for the third year in a row!

Ducati CIO Shares the 3 Outcomes of Incredible Data Success

Cloud Volumes Service for AWS Foundations: Part 3

Image: NetApp’s Cloud Portfolio

ONTAP Select - Automation Deployment with Python and PowerShell

ONTAP Select - Automation Deployment with Ansible

Image: PSUs to PDU - how they should be cabled for NetApp FAS9000 / AFF A700 / AFF A800

SnapCenter 4.1:

SnapCenter Software 4.1:

SnapCenter 4.1 Documentation Center

YouTube: NetApp TechComm TV: SnapCenter Playlist

NetApp SnapCenter Software Resources

NetApp Blogs

DreamWorks Looks to Reanimate Business With Advanced Analytics
Approximately 600 terabytes of storage and 120 million core hours of rendering go into each animated feature-length film

A New Take on Scale-Out Storage Expansion for NetApp HCI and SolidFire

What the Heck is VMware Private Cloud with NetApp HCI, Anyway?

NetApp NVMe for your Database

Scalable vSphere Storage with ONTAP

Your File Data Is the Important Bit in the Public Cloud

Please, Sir, I Want Some More Persistent Storage

Everything You Need to Know about Performance Sizing for Cloud Volumes ONTAP (formerly ONTAP Cloud)

Deploying a Virtual Storage Appliance in Azure

NetApp Cloud Assessment: Find Unused Resources and Data Protection Holes

Azure Storage Replication with SnapMirror

Managing iSCSI Storage with Cloud Volumes ONTAP

What Do Customers Want from a Cloud Volumes Service? (Part 2)

What Do Customers Want From a Cloud Volumes Service?

How To: Unjoin NetApp Nodes from a Cluster

NetApp (the) Pub / NetApp.io


Second Major Ansible Module Release

Trident 18.07: Summer Heat and Awesome Features

NetApp Tech ONTAP Podcast



NetApp: TRs


TR-4711: SAP HANA Backup and Recovery using NetApp Storage Systems and Commvault Software

TR-4709: OnCommand Unified Manager Schemas Explained

TR-4707: FlexPod for Epic Directional Sizing Guide

TR-4706: Big-Data Pipeline on ONTAP and Orchestration with Robin Cloud Platform

TR-4684: Implementing and Configuring Modern SANs with NVMe/FC

Security

Here's a List of 29 Different Types of USB Attacks

Foreshadow

Veeam

Veeam Backup for Microsoft Office 365 v2

Veeam Backup for Microsoft Office 365  Community Edition: FREE Office 365 backup!

VMware

Hotadd backup/restore takes time to open VMDKs in VDDK 6.5.2 and later versions (55418)

Backup jobs using Virtual Appliance (HotAdd) transport mode take longer after installing 9.5 Update 3a

Thursday, 23 August 2018

Excel VBA Macro to Use a 3rd Workbook to Transfer Data between 2 Workbooks

In this very simple example, I have an Excel Workbook called C.xlsx.
In C.xlsx, I list the workbook names A.xlsx (in cell A1) and B.xlsx (in cell B1).
I have a bit of data in cell A1 of A.xlsx that I want to ship to A1 in B.xlsx and running the Macro actions this!

Note: The 3 workbooks need to be open (I don’t open/close in this example.)


Sub ABC()
Dim a As Workbook
Dim b As Workbook
Dim c As Workbook

'## Open C workbook first:
Set c = Workbooks("C.xlsx")
Dim SrcFile As String: SrcFile = c.Sheets("Sheet1").Range("A1").Value
Dim DstFile As String: DstFile = c.Sheets("Sheet1").Range("B1").Value

'## Open A and B workbooks:
Set a = Workbooks(SrcFile)
Set b = Workbooks(DstFile)

'Now, copy what you want from a:
a.Sheets("Sheet1").Range("A1").Copy

'Now, paste in to b worksheet:
b.Sheets("Sheet1").Range("A1").PasteSpecial
End Sub


I’m a noob using Excel VBA Macro’s, so yes it is a bit of basic example but it’s a start. Now I’ve got to write what I actually need (which is much more complicated - requires a prompt, many more fields, saving a file with a specific filename ...).

Image: ABC Excel VBA Macro Example

Wednesday, 22 August 2018

nslookup++ / How to Resolve a List of Hostnames to a List of IPs...

...with access to the DOS command prompt commands and the bare minimum set of PowerShell cmdlets.

Copy and paste the script below into a text editor and save as say nslookup++.ps1, and run in PowerShell as .\nslookup++.ps1.

Example image of it in use is below (using public website addresses since cannot share internal hostnames on this blog.)

Image: Example of nslookup++ in action

The Script


[Boolean]$Repeat = $TRUE
While($Repeat){
  Write-Host "nslookup++: RESOLVES LIST OF HOSTNAMES TO IP"
  Write-Host "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"
  Write-Host "Enter list of hostnames (can paste a list)"
  Write-Host "  and press ENTER on empty line to continue (no input terminates program):"
  [System.Array]$Hosts = @()
  [Boolean]$do = $TRUE
 
  While($do){
    $ReadIn = Read-Host
    If($ReadIn -eq ""){$do = $FALSE}
    else{$Hosts += $ReadIn}
  }
 
  [System.Array]$HostsOut = @()
  $Hosts | Foreach{
    If($_ -eq "NONE"){$HostsOut += "NO CHECK"}
    else{
      [System.Array]$nslookup = (nslookup $_)
      [Int32]$TempCount = 0
      [String]$Result = ""
      Foreach($line in $nslookup){
        $TempCount++
        If($line.StartsWith("Name")){
          $Result = $nslookup[$TempCount].Split(" ")[2]
        }
      }
      If(!$Result){$HostsOut += "DNF"}
      else{$HostsOut += $Result}
    }
  }
 
  $HostsOut | Foreach{Write-Host $_}
  If($Hosts.count -eq 0){$Repeat = $FALSE}
  else{PAUSE}
}