Forum Discussion

Dawn M Wertz's avatar
Dawn M Wertz
Brass Contributor
Mar 30, 2023

How to report on connection information?

I need to justify moving some of my Cloud PCs to Azure regions closer to the users.  I want to create a report listing the computer, the round tip time, and the sign-in location.  I started by pulling information from the Graph API on the user’s last login time and attempted to match it to the Azure sign-in audit logs.  However, I cannot match the cloud pc last login timestamp with an audit event for all the computers.  Does anyone know what triggers this field to be updated?

 

Once I had that information, I wanted to tie it into the connection information report.  However, when I  use Graph to attempt to pull the connection information, it exports the data into a JSON file with a schema.  I am unable to pull this JSON file into Excel.  Does anyone have any experience on pulling the connection history from Graph?

 

Any help is appreciated.

enterprise

3 Replies

  • Doug_Coombs's avatar
    Doug_Coombs
    Icon for Microsoft rankMicrosoft
    Mar 31, 2023
    Will add this as a use case to be considered for native Windows 365 reporting.
  • expertopinionsa12's avatar
    expertopinionsa12
    Copper Contributor
    Mar 30, 2023
    Hi,

    Try using the "From JSON" option in the "Data" tab. This allows you to easily import JSON data into Excel so you can manipulate it and analyze it as needed. Simply open a new workbook in Excel, select "From Text/CSV" in the "Data" tab, browse to the JSON file you want to import, and select it. Then choose "JSON" as the file type in the "Text Import Wizard" dialog and select the format for the data. Excel will create a new table with the imported JSON data, which you can then manipulate as needed. If you encounter any issues with the import, make sure that the JSON file is properly formatted and that it contains the required data fields. I hope this helps.

Resources