none
RdWeb Usage reports RRS feed

  • Question

  • I want to generate usage reports for RdWeb month on month to know how many users have logged in each day. I'm doing it manually by exporting the terminal gateway event logs as csv, trim, sort out date format, etc.. which is a tedious job as I have to do it for 14 environments. Looking for automation ideas to avoid manual work and set up a dashboard which will display as on date usage and option to download the data. 

    Can someone throw some light as how a dashboard can be created directly by reading the event logs


    RDP -George


    • Edited by George K U Thursday, November 21, 2019 3:40 AM
    Thursday, November 21, 2019 3:39 AM

All replies

  • Hi George,

     

    Please verify if this powershell command could achieve your requirements. And you can check the Q&A section if anything unclear.

     

    RDPConnectionParser.ps1

    https://gallery.technet.microsoft.com/Remote-Desktop-Connection-3fe225cd

    Sample Output

     


    Thanks,

    Jenny


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, November 21, 2019 6:18 AM
  • Hi,

    Is there any update? Have you got a chance to verify above suggestions?

     

    Please feel free to let us know if more assistance needed.

     

    Thanks,

    Jenny


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, November 26, 2019 3:01 AM
  • Hi Jenny, 

    Thanks for your response, let me try the solution you suggested. I will update you in couple of days. 

    sorry about the delay in response as I'm little busy with my newborn :)


    -George

    Wednesday, November 27, 2019 6:33 AM
  • Hi Jenny,

    Thanks for your response, I will give a try on what you suggested and update in couple of days.

    sorry about the delay in response as I'm busy caring my newborn :)


    -George

    Thursday, November 28, 2019 12:45 AM
  • How wonderful to hear such great news! Just take your time and update when you have time to test.

     

    Have a nice day.

     

    Thanks,

    Jenny


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, November 28, 2019 6:25 AM