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()