May 2021 -

Merging RVTools reports using Power BI

May 12, 2021 Kim Bottu 2

RVTools reports are very useful to quickly glance over the state of your virtual environment. However, when you deal with multiple vCenters servers, wouldn’t it be nice to be able to consolidate RVTools reports into a single interface? Enter Power BI. Power BI goes beyond that what you can achieve by using Pivot Tables in Excel. Requirements: Install Power BI Install RVTools What now? Export RVTools reports as Excel files Save the excel files to a dedicated folder Now you have to point Power BI to import sources from a folder. If you want an active representation on how you do this, you can follow this video. Once done, select “combine and transform data” Now, to combine (reads: merge) xlsx […]

How I Passed The #CISSP #vExpert #VCDX @kmcnam1

May 10, 2021 Bilal Ahmed 2

My Background: My career has covered areas that turned out to be quite helpful. I started at a bank, doing Media Management/Backups/Silo tapes, moving them between sites etc. I then became a data centre engineer, racking and stacking and cabling I then joined a BC/DR provider and helped customers test their DR processes and workplace recoveries and just managed services. I then became a VMware and Storage admin, working on keeping it running and upgrading it all and managing their DR recoveries. I now work as a Senior Consultant doing migration work and helping customers with changes and joining CAB meetings and all that jazz. I’ve been through many certification exams; I enjoy doing them as they force me to […]

Use ADFS as Identity Provider for vCenter

May 8, 2021 Kim Bottu 0

After you have setup ADFS, you can start using ADFS as a Identity Provider for vCenter server.You can follow the following screenshots as some kind of a guide on how to configure vCenter server to use ADFS. Change the Identity Provider Next, copy the vCenter Redirect URIs. In my case these are: https://vcenter7.vmusketeers.local/ui/login https://vcenter7.vmusketeers.local/ui/login/oauth2/authcode Next, from ADFS copy the Client Identifier, Shared Secret and OpenID Address. But wait, you first have to create these in ADFS! The client identifier will be generated during the vCenter-ADFS – Server application creation in ADFS. So now open ADFS Create a new server application: vCenter-ADFS – Server application Just follow the screenshots now click Next Copy the Client Identifier: 79713503-00db-48a8-910c-d089b0782ae6 Add the vCenter Redirect […]