Skip to content

Power BI Installs

    SCCM SQL query for Power BI installs in your organization

    SELECT DISTINCT v_r_system.resourceid,
                    v_r_system.resourcetype,
                    v_r_system.name0,
                    v_gs_add_remove_programs_64.displayname0,
                    v_r_system.sms_unique_identifier0,
                    v_r_system.resource_domain_or_workgr0,
                    v_r_system.client0,
                    v_r_system.lastlogon0,
                    v_r_system.description0,
                    v_r_system.distinguished_name0,
                    v_r_system.user_name0
    FROM   v_r_system
           INNER JOIN v_gs_add_remove_programs
                   ON v_gs_add_remove_programs.resourceid = v_r_system.resourceid
           INNER JOIN v_gs_add_remove_programs_64
                   ON v_gs_add_remove_programs_64.resourceid = v_r_system.resourceid
    WHERE  v_gs_add_remove_programs_64.displayname0 LIKE '%Power BI desktop%'
    ORDER  BY description0 
    Snarful Solutions Group, LLC.