Get list Administrators - DISCOVER_XML_METADATA

Question

Hi, Running an XMLA script to get all administrators of SSAS. See below. Do you have to be an administrator to run this script or is it possible to give the user that runs the script another role/access that do not give that user admin rights, but the rights to view who is administrators?

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
    <RequestType>DISCOVER_XML_METADATA</RequestType>
    <Restrictions>
        <RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">
            <RoleID>Administrators</RoleID>
            <ObjectExpansion>ExpandObject</ObjectExpansion>
        </RestrictionList>  
    </Restrictions>
    <Properties>
    </Properties>
</Discover>

Answer 1

Hi Stefan According to the documentation you have to be Administrator to be able to execute DMVs Regards Javier