Creating basic sql/SCCM query
I’m trying to create a SQL query that will give me some basic information that includes:
System Name (from v_R_System)
TopConsoleUser (from v_GS_System_Console_Usage_Maxgroup)
User office location (from v_R_User)
The query looks like this:
Select v_R_System.Name0, v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0, v_R_User.l0 From v_R_System Inner Join v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP On v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.ResourceID = v_R_System.ResourceID Inner Join v_R_User On v_R_User.ResourceID = v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.ResourceID But when I execute the query, it returns no results and does so in seconds(Done in 0.6942996 seconds.) I’m new to query writing, and I’m trying to figure it out. Where I get lost is when it comes to “JOINS” confusing as hell! Any help would be appreciated!