December 2022 – BIOLNX

Immagine che contiene testo, interni

Descrizione generata automaticamente

Until a few weeks, my Home Lab was composed of two physical ESXi nodes (respectively an INTEL NUC NUC8i3BEH and an HP Desktop HP ProDesk 600 G2 DM), with 32 GB of RAM each and 5 TB of total disk.

For my testing activities, especially in VDI (Horizon) and some vSAN (implemented a 2-node cluster to test the operation of Shared Disks for Microsoft clusters) could be enough.

But the desire to test vSphere 8 (vSAN etc …) and the possibility of trying the Kubernetes world was pushing me to evaluate an expansion of my Home LAB ……….

………. And thanks to COHESITY and the vEXPERT community at VMware EXPLORER in Barcelona I was able to have my expansion…. a beautiful Maxtang NX6412 NX6412-Maxtang-A premier manufacturer (maxtangpc.com)

Image containing electronic, projector

Auto-generated description

here’s how I activated the new HW:

Equipment
- Being barebones I had to buy RAM and DISK, taking advantage of Black Friday I bought:
  - Timetec 1TB SSD 3D NAND TLC SATA III 6Gb/s M.2 2280 NGFF 512TBW
  - Transcend JM3200HSE-32G 32GB DDR4 3200MHz SO-DIMM 2Rx8 1.2V

Image containing text, electronic, circuit

Auto-generated description

For the RAM I will proceed to evaluate an expansion with an additional 32GB bank

Installation
- Updated vCenter to version 8
- Installed ESXi version 8 on a USB stick (Using VMware Workstation and installing ESXi from an ISO on my USB stick) and used it to boot from Maxtang.

At this point I encountered the first problem, the two network cards are not compatible… I had to use a USB dongle -> Ethernet and I managed to start everything (Thanks also to the community drivers USB Network Native Driver for ESXi | VMware Flings

- I finally added ESXi to my vCenter
First use
- The first thing I did was use William Lam’s script to deploy a vSAN 8

Automated vSphere & vSAN 8 Lab Deployment Script (williamlam.com)

- I configured the HA of my vCenter
- Now I’m trying to improve my know-how on Tanzu and WorkSpace One

So THANK YOU vEXPERT, VMware and COHESITY

I need to find on AppVolume DB the association from User and Application.

I took a look at my APPvolume test DB and I think it looks like this:

In the table dbo.app_assignment_entities I find the mapping:

user (target_id) –> assigning the application (app_assignment_id)

Image containing table

Auto-generated description

In the dbo.users table I find my users, so from that table I associate the target_id (ID column of the table) to my user:

Image containing text, screenshots, internals

Auto-generated description

while in the dbo.app_assignments table I translate the application assignment id (app_assignment_id, in this table it is l’id, found in the dbo.app_assignment_entities table) into the actual application id (app_product_id)

I translate the defined ID of the application (app_product_id) to the name of the application in Table dbo_app_products

I give a practical example my user “Piccoli Brividi” has 3 applications associated so:

In the table dbo.app_assignment_entities I find in column target_id three times the value 2
in the dbo.users table I find that id 2 corresponds to “Piccoli Brividi”

at this point we translate the application, “Piccoli Brividi” has the apps_Assignment_id 9,15 and 16

In the dbo.app_assignments table I find that ID 9 is associated with app_product_id 5, 15 7 and 16 2
I go to the table dba_approducts and find out the name of the applications associated with my user “Piccoli Brividi”

App_product_id (id) 5 –> FoxitWin11

App_product_id (id) 7 –> IBM personal communication

App_product_id (id) 2 –> notepad++

and I correspond to what I see from GUI.

BIOLNX

vmvirtual.blog

Month: December 2022

I updated my Home Lab with the gift of Cohesity and the vEXPERT community

So THANK YOU vEXPERT, VMware and COHESITY

AppVolume DB – How to see User – Application association