Does anyone know which table contains the list of users to appstack assignments? (same list that shows under the 'appstack assignments' section under directory>users in the GUI)
I am building a view that shows list of licensed applications with costs per user in PowerBI by joining data between these tables using SQL.
List of appstacks: dbo.snapvols
List of applications: dbo.snapvol_apps
List of users: dbo.users
List of Licensed Applications with costs: Manually created table
The table (snapvol_app_assignments) I would expect this to be in is empty.
Ciao
I took a look at my APPvolume test DB and I think it looks like this:
user (target_id) --> assigning the application (app_assignment_id)
I give a practical example my user "Piccoli Brividi" has 3 applications associated so:
at this point we translate the application, "Piccoli Brividi" has the apps_Assignment_id 9,15 and 16
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.
I'm especially stayed aware of the article and I will get many benefits from it. Subsequently, thank you for sharing it.
@djbradp1myBayCare wrote:Does anyone know which table contains the list of users to appstack assignments? (same list that shows under the 'appstack assignments' section under directory>users in the GUI)
I am building a view that shows list of licensed applications with costs per user in PowerBI by joining data between these tables using SQL.
List of appstacks: dbo.snapvols
List of applications: dbo.snapvol_apps
List of users: dbo.users
List of Licensed Applications with costs: Manually created table
The table (snapvol_app_assignments) I would expect this to be in is empty.
ciao
I saw that in my answer post not all images are displayed...here a link with the same answer and images:
AppVolume DB – How to see User – Application association – BIOLNX (vmvirtual.blog)