CMD.exe: Get second column output to variable

Question

I need the below command second column output <USERNAME> result to variables:

query sessions|find "Active"
>console    <USERNAME>     1   Active

I know the %USERNAME% OR whoami could get the current user name but this script will run using administrator account and will need to be able to capture the current active logon username. If I could select the second column of the output results and assign it to a variable.. this will be a great help.

Answer 1

In this case you should use FOR /F to capture the output

for /F "tokens=1,2,3,4,5" %%A in ('"query session | find "Active""') DO (
  echo %%A,%%B,%%C,%%D,%%E
)

It splits also the line at spaces and TABs, but this can be problematic if the username contains spaces.