Systemuser using fetchxml

Here is a sample query to get logged-in user's (current user's) information using fetchxml:

<fetch version="1.0" output-format="xml-platform"

       mapping="logical" distinct="false">

   <entity name="systemuser">

      <attribute name="fullname" />

      <attribute name="systemuserid" />

      <order attribute="fullname" descending="false" />

      <filter type="and">

         <condition attribute="systemuserid"

                    operator="eq-userid" />

      </filter>

   </entity>

</fetch>

 

 

SQL based reports:

 

select fullname

from FilteredSystemUser

where systemuserid = dbo.fn_FindUserGuid()