Unable to generate reports from DirectAccess

Question

Hi,

I'm trying to generate a report from DirectAccess containing all the information in the Remote Access Reporting page of the Remote Access Mgmt Console but I can't seem to find a good way of doing this.

I've used Get-RemoteAccessUserActivity and Get-RemoteAccessConnectionStatistics commands in order to get some of the information, however I need to tie the information together so that I can see the related connections (Access Details) for each session.

The information exported from the UserActivity command only contains 3 columns which is pretty useless seeing as it doesn't really correlate to anything other than the username.

Another thing is that I can see additional activity in the Management Console where the User Name is logged as "-" but the host name is the client of a specific user. There doesn't seem to be a way to include this in the output of any of the PS commands.

Thanks for any help regarding this matter!

Answer 1

Hi ,

Based on my understanding, you want to run the command of Get-RemoteAccessConnectionStatistics to build a list or array of the UserNames, then pipe that into the command of Get-RemoteAccessUserActivity? Is that right? Please feel free to let me correct me if my understanding is wrong.

Here is a similar thread discussed before, you could have a look:

Windows VPN Server (RRAS) User Activity Export

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

If it still doesn't help you, I would suggest you have this asked in PowerShell forum to know how to tie the information together with two cmdlets.

Best Regards,

Candy

--------------------------------------------------------------

If the Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.