SQL Query to find machine information in SCCM
2013-4-24 · SQL Query to find machine information in SCCM April 24, 2013 The below query provides the hostname,AD SITE Name,Username,Client version,creation date,Operating System of a SCCM client installed machine. select Name0 AS ''HostName'', AD_Site_Name0 AS ''AD Site Name'', User_Name0 as ''User Name'', Client_Version0 asBuilding a SCCM SQL Query: Return Users Without Specific ...2021-10-21 · Step 2: Translate the Computer ID''s to Machine Names. Show the computer names of computers with Zoom installed. Additional View: v_R_System_Valid; For this, we''ll need to pull in another view — one that can use the ResourceID from v_GS_ADD_REMOVE_PROGRAMS and give us back the name for the computer it''s tied to.