(whenever you fix this, get someone else from the team to shadow you so we know how+where to do it?)

The Single Page Applications Workbook has a broken link for "React based sites" and for "Angular based sites". Both links currently return a 404.

We have a workbook created manually for an application insight and I am trying to deploy workbook instance to application insight using the arm template. ARM template was copied from the portal , by going to the advanced settings of workbook in an edit mode.
But, when deployed the arm template using PowerShell or even used visual studio, it is deploying like a individual resource in the resource group and not getting associated to the application insight.

I did check this sample arm template mentioned here : https://github.com/microsoft/Application-Insights-Workbooks/blob/master/Documentation/Programmatically.md

Workbook types I tried using 'tsg' as suggested and also type 'workbook' , but both of these are not getting associated to an application insight, rather, they are just getting deployed like a individual resource. Am I missing something here ?. Please let me know.

Also, in the same link, at the bottom of the section, in the Limitations : it is mentioned like "For an technical reason, this mechanism cannot be used to create workbook instances in the Workbooks gallery of Application Insights. We are working on addressing this limitation."

Is there any updates on this limitation mentioned ?
or How can I deploy programmatically workbook instance to an application insight.

Please help.

Thank you.

While testing other things in workbooks today, i noticed that in this template (and probably other versions of this template):
Application-Insights-Workbooks/Workbooks/Virtual Machines - Performance Analysis/Performance Analysis for a Group of VMs (Perf)/Performance Analysis for a Group of VMs.workbook

have a bunch of params that run logs queries that don't need to. in this case, since they are parameters and not marked to not run when hidden, all of those 12 parameter queries run when the workbook is loaded to just to format some strings, which aren't actually used until someone switches to that tab.

there is a repeated section of charts that look like this:

each chart has this section of params repeated on each chart:

and 3 of those 4 params are logs queries but don't need to be. they can all be replaced either with critiera or just a "json" provider that formats a string:

(and in this case you could switch the aggregation to an optionsgroup if you wanted to, i think you guys originally requested that and it now is a thing, which would get you this:

And in this case, all those params steps in the secondary tab should be marked to not run when not visible (though this matters less when they switch to not doing logs queries):

Hello, I was using this github to implement dashboards via the soon deprecated view designer of azure monitor https://github.com/MicrosoftDocs/azure-docs/commits/master/articles/firewall/log-analytics-samples.md
The feature being now replaced by workbooks is there some work planned in order to produce workbooks on azure firewall or is there any way to transit easily from .omsview to .workbook without having to manually reconstruct ?
For now the most fitted alternative I found is to monitor the azure firewall via sentinel and the workbooks developed for it like for example https://github.com/Azure/Azure-Sentinel/blob/master/Workbooks/AzureFirewall.json but any other suggestion is welcomed

When I deploy a Workbook ARM template to a resource group then the Workbook appears in the Workbook gallery of the resource group. Here's a simple example:

{
    "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
    "contentVersion": "1.0.0.0",
    "resources": [
        {
            "apiVersion": "2018-06-17-preview",
            "kind": "shared",
            "location": "westus2",
            "name": "18a15b48-f071-4728-b954-54be8e85755d",
            "properties": {
                "category": "workbook",
                "displayName": "LegacyWorkBook",
                "serializedData": "{\"version\":\"Notebook/1.0\",\"items\":[{\"type\":1,\"content\":{\"json\":\"Blank workbook\"},\"name\":\"text - 0\"}]}",
                "sourceId": "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/my-rg",
                "version": "1.0"
            },
            "type": "microsoft.insights/workbooks"
        }
    ]
}

But when I try to deploy to Application Insights (Exact same template as above with this one change.)

"sourceId": "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/my-rg/providers/microsoft.insights/components/my-appinsights",

Then the Workbook shows as linked to Application Insights but when trying to view the Workbook it says the resource cannot be found.

⚠ This item could not be restored.
Could not find Workbook with id /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/phoenix-monitor-rg/providers/microsoft.insights/workbooks/18a15b48-f071-4728-b954-54be8e85755d in subscription xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx. It may have been deleted or moved, or you may not have access to it.

And the Workbook does not show in Application Insight's Workbook gallery.

If I go back to the Workbook resource and save a new Workbook then that new version does display in Application Insight's gallery, but it seems to be detached from the Workbook resource it was originally created under because it does not appear under the Workbook resource.

(As an aside, if I create several new Workbooks under the Workbook resource and then delete one of them it then shows a gallery view containing all of the Workbooks under that Workbook resource. The URL to this gallery view is in the form of:

https://portal.azure.com/#@xxxxxxxxxxxxxxxx.onmicrosoft.com/resource/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/my-rg/providers/microsoft.insights/workbooks/18a15b48-f071-4728-b954-54be8e85755d/workbook

However, once I navigate away I can't get back to this gallery view. If I try going directly back to that URL in my browser I end up at the original Workbook which was created. This doesn't have to do with Application Insight Workbooks but is another possibly helpful observation.)

Also, when creating a Workbook in the portal within the Workbook gallery of a Resource Group it gives the option to "Save content to an Azure Storage Account." But Workbooks created within Application Insights Workbooks gallery do not have this option. Will Application Insight Workbooks eventually have this option?

The Usage through the day Workbook orders by the string variable used for display purposes.

KQL Snippet:
| extend Day = strcat(monthofyear(timestamp), '/', dayofmonth(timestamp), ' - ', case(WeekDay == 0d, 'Sun', WeekDay == 1d, 'Mon', WeekDay == 2d, 'Tue', WeekDay == 3d, 'Wed', WeekDay == 4d, 'Thu', WeekDay == 5d, 'Fri', 'Sat'))
| extend Day1 = bin(timestamp, 1d)
| order by Day asc, Hour asc

Visualization screenshot:

Potential solution KQL snippet:
| extend Day = strcat(monthofyear(localTimestamp), '/', dayofmonth(localTimestamp), ' - ', case(WeekDay == 0d, 'Sun', WeekDay == 1d, 'Mon', WeekDay == 2d, 'Tue', WeekDay == 3d, 'Wed', WeekDay == 4d, 'Thu', WeekDay == 5d, 'Fri', 'Sat'))
| extend Day1 = bin(localTimestamp, 1d)
| order by localTimestamp asc, Hour asc

And the visualization:

Happy to submit a PR for this.

Hi John,

Hope you are doing good.

I have pinned number of backup reports widgets to azure dashboard but some widgets have meaningful name and some are showing Workbook so i want to change the widget names n azure dashboard.

Hi,
I'm trying to run the Workspace Usage workbook from my Log Analytics workspace, but I'm getting an error:

union: column named 'TableName' already exists Click to Retry.

I've tried to edit the query but since my knowledge is lacking I cannot fix this myself, hence this issue.

Hey,

I have created a workbook which contains some kusto queries that reference my application insights through a parameter.
This looks something like this in the gallery template json:

      "id": "97c8b655-3fa7-4fdd-be92-1fa391c35b61",
      "version": "KqlParameterItem/1.0",
      "name": "Application",
      "value": "/subscriptions/xxxx/resourceGroups/yyyy/providers/Microsoft.Insights/components/zzzzz",
      "typeSettings": {"resourceTypeFilter": {"microsoft.insights/components": true} }

This parameter is then used in the query something like this:

  "content": {
    "version": "KqlItem/1.0",
    "query": "<query removed for brevity> ",
    "title": "Some title", 
    "queryType": 0,
    "resourceType": "microsoft.insights/components",
    "crossComponentResources": ["{Application}"]

When I now generate an ARM template for my workbook, the parameter value (e.g /subscriptions/xxxx/...) will be part of the serializedData in the resource "microsoft.insights/workbooks". Is there any possibility that I can supply the parameter value through the parameters of the ARM template? I like to deploy this workbook for several (similar) resource groups, where I would like to supply the application insights it needs to use for queries.

Note that I already tried to replace the value with a reference in ARM style (e.g. through [parameters('aaaa')]), but that does not work. The ARM deploy does not validate (likely because it is is part of some serializedData ) and the deployed workbook did not find the parameter.

Is there anything I can use to get this done? My fallback scenario is to create a script to replace the values just before deploy, but I rather use an easier and more generic solution.

Hello @ericc1103,
Translator has reported possible source content issue.
Link to Github file: https://github.com/Microsoft/Application-Insights-Workbooks/blob/master/Workbooks/TSG/Performance%20Counter%20TSG/Performance%20Counter%20TSG.workbook
Row where the issue is located: 217
Comment: Translator asks to confirm the meaning of "serviced from the box" here, since they could not find a definition for this expression.

Can you please review the comment and provide answer/explanation? Also, if source fix is needed please provide link to the PR that will include the fix, so we can confirm and close this Issue.
Many thanks in advance.

Hi,
We been working on a Ai Workbook template to show the data generated from the https://github.com/Microsoft/ApplicationInsights-JS-Mezzurite plugin. We have our template but need to know where to check it into. The data is sent up via the pageviewperformance method, and shows up in the browser timings folder.

The timerange is currently updatable only through user interaction either directly at the component or through brushing (via global param).

It is not possible to update it by other means, i.e providing from/to or and expression (ago(1h).

This limitation is big, since almost all metric components are encapsulated and only accept timerange from UI or existing variables.
If I bind the metric to a variable I can't control it from the workbook code, only the user can.

In my scenario, we provide insights for a logical process in our domain, for example user uploading a file which triggers a lot of internal domain logic.

I can identify the start time and end time of this process and I would like to update the various metrics to reflect the data for that exact time frame, but I cant.

I could write queries that use the start/end to extract the metrics manually and display charts, but this is way much work and not everything is available in the workspace, some data requires explicitly adding a diagnostic settings to expose it to the log analytics workspace. Even with that, i need to know where the data is, how to query and display it...

A lot of work for something that already exists through metrics, I just need to be able to update the time range

Clearly this is possible at the JS level, since the UI TimeRange component does that.
We just need some syntax that will allow updating specific properties in the time range from kusto response or through some special component in the UI

Hi, I have a workbook that contains 3 queries:

1. Azure Resource Graph
2. Log Analytics
3. Merged query of the above two.

When I am pinning the workbook steps (or queries - as described above) to a dashboard, only the first two are shown in the dashboard. the merged query is not showing up. I can't find any documentation that tells me which steps can be pinned or not.

Any idea?

1. How do I select dashboard when pinning? It pins the workbook to a dashboard I dont want, but cant select anything else
2. Why is dropdown with parameters not able to be pinned do dashboard?
3. How to integrate the time settings on the Application Dashboard with the workbook query time range?

Btw, is the Workbook feature being abandoned soon? I see it's quite unstable and some feature were promised to be added but there aren't, like unstacked barchart columns

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Hi John,

Regarding the original issue #752 which is closed.

7208272: Workbooks: add ability to edit title of workbook pins? Is it a reference Doc which i could follow to change the Workbook title/names. I am unable to locate it. Please help.

Hello, can this work be put on hold please?

• “Save as private workbook” is quite useful, and we would like it to remain.
  Test workbooks will fill up the shared area unnecessary otherwise.
  Probably better to provide a choice instead of removing it completely.

• The git doc does not explain the reason for this change or value (2nd time the document is published, first one in November).

• No explanation on role changes for users and work required for admins.

• It seems a user role for the update to workbooks as a whole does not exist. Can a document on workbook access be created please?

Thanks

Do workbook for update management available, i cant find from the list.

Add a template that uses the Application Change Analysis preview data source to Individual Storage.

Note this can't be deployed until after the necessary portal changes for access are deployed. ETA end of May.

In reviewing the CA GAP Analysis workbook, in the Unprotected Applications section, the report of Number of Users Signing in to Applications with Conditional Access Policies Not applied, it includes the Windows Sign-In "app"

This is the sign in to the Windows device and PRT acquisition process and would not be in scope of CA. This causes lots of "noise" in the report since most users will have this event.

Can we remove the "Windows Sign-In" app from this report?

With a grid output the the field widths seem to be set some arbitrary value sometimes either hiding the field title or the cell content. When adjusting the width manually this does not save. Also when making the field width wider a scrollbar appears as if there is additional hidden content to the right of the visible fields.

Modifying percent width (even setting to 0) or the maximum width does not have any positive effect.

A good example of this is the Virtual Machines Key Metrics workbook.

The JSON validation test fails if Byte-Order Mark (BOM) is present in the file and throws an ambiguous error. The validation test should be updated to warn the user to take corrective action to remove BOM. It is recommended that BOM should not be used in UTF-8.

https://tools.ietf.org/html/rfc3629#page-6

Steps to reproduce:

1. Use notepad++ or some text editor that prepends a UTF-8 BOM
2. Save a new workbook as UTF-8
3. Execute jsonValidationTest.js
4. Test will fail, throwing an error saying unexpected "blank" token was found

SyntaxError: Unexpected token  in JSON at position 0
      at TryParseJson (test/jsonValidationTest.js:149:16)
      at validateJsonStringAndGetObject (test/jsonValidationTest.js:115:15)
      at results.filter.forEach.file (test/jsonValidationTest.js:55:21)
      at Array.forEach (<anonymous>)
      at browseDirectory (test/jsonValidationTest.js:54:18)
      at next (test/jsonValidationTest.js:96:31)
      at /home/travis/build/Microsoft/Application-Insights-Workbooks/test/jsonValidationTest.js:102:25
      at next (test/jsonValidationTest.js:96:31)
      at /home/travis/build/Microsoft/Application-Insights-Workbooks/test/jsonValidationTest.js:106:21
      at FSReqCallback.oncomplete (fs.js:161:5)

Fix diff for the workbook to remove the BOM:

@@ -1,4 +1,4 @@                                                                                                                                                       
-<EF><BB><BF>{                                                                                                                                                        
+{                                                                                                                                                                    
   "version": "Notebook/1.0",

Hi John / Team,

Does azure backup reports support hana db log backup jobs? I am able to monitor the hana db full backup jobs but not the log backup success/failed jobs.

Please assist how we could incorporate the hana db log backup jobs with backup reports.

Thanks

Hi, I discovered interactive parameters from documentation over here.
https://docs.microsoft.com/en-us/azure/azure-monitor/platform/workbooks-interactive

When I tried on pie, it was not working. I thought I did something wrong. When I change the visualization to grid, it works. May I know will this be supported in the future? or is there already a preview that supports this. What I'm trying to do is to create a pie chart with a grid after to show interacted clicks on the pie in relative to the grid. There is a donut tile conversion for dashboard that does that. Would like to recreate in workbook

these templates have "isLocked": false, so when they open from the gallery they open in edit mode. is this correct?

• Workbooks/Virtual Machines/Key Metrics/Key Metrics.workbook
• Workbooks/Usage/Usage Calendar/Usage Calendar.workbook
• Workbooks/Azure Active Directory/SignIns/SignIns.workbook
• Workbooks/Azure Active Directory/SignInsUsingLegacyAuth/SignIns.workbook
• Workbooks/Azure Active Directory TroubleShooting/SignInFailureAnalysis/SignInFailureAnalysis.workbook
• Workbooks/Azure Active Directory/SignInsAndConditionalAccess/SignInsAndConditionalAccess.workbook

Hey, our team would like to add a new workbook under SapMonitor to be able to demo to our partners on Monday (12/7 in the morning).
Can that be qualified as a hotfix so we can demo it?

Hi!
I am trying to run the Deprecated Workbook Retrieval Tool as described here - https://github.com/microsoft/Application-Insights-Workbooks/blob/master/Documentation/LegacyAI/DeprecatedWorkbookRetrievalTool.md.

When I try to load it in a new Workbook, I get an error. After further review, there are unnecessary double quotes in some locations. After I removed the double quotes (Using Visual Studio Code) it loads. After selecting a Subscription and Resource Group though, another section has an error where it says an API parameter must be added and the Subscription path was not passed. I added the subscription path manually and a API, but nothing else loads.

Can you take a look please?

Thank you,
Jeff Kozloff

It looks like the mezzurite library itself: https://github.com/microsoft/Mezzurite/

is now "archived" and read only. If that is the case, we should probably also remove the mezzurite appinsights template here?

https://github.com/microsoft/Application-Insights-Workbooks/blob/master/Workbooks/Performance/Single%20Page%20Application%20Insights/Single%20Page%20Application%20Website%20Insights.workbook

@JerryBlake can we remove this if it no longer works?

Validation test should fail when dropdown has improperly formatted JSON or else the dropdown will not show anything.

I have been struggling to make use of workbooks for any but the simplest of tasks. This is largely due to the fact that there is no language reference guide that would afford the user the ability to specify "type" and other parameters in a meaningful way. Last time I checked type 0 type 2 type 9 etc are not Microsoft standard ways of naming things and have not been since ms-dos.

Yet here they are in each workbook as it to tell us that they are necessary but we are going to give you any more info about them.

I am really hoping that Microsoft is not up to its old tricks again by selectively providing info that gives the user a distinct disadvantage while creating workbooks on azure data.

For example, while it is clear how to use parameters in kql queries it is not clear how to conditionally show various dropdowns as a function of previous dropdown selections. This conditional display is critical to our ability to make appInsights workbooks customizable for each of our spa's requirements. The docs do not appear to have a solution to this very common problem.

Dropdown a value requires the display of dropdown b or dropdown c... which then requires dropdown e or dropdown f.
The conditional display values do not appear to work in such a scenario.

And there does not appear to be any docs about how to do this.

I have downloaded the entire corpus of documentation that is many thousand pages and at best disorganized and incomplete.
very disappointing indeed

none of the current workbooks have descriptions in their settings.json?
and worse, the cohorts apparently have "description goes here" in their descriptions?

things like using timerange params in queries, doing filtering up front, etc. just general things.

and samples how to do json dropdowns/etc instead of doing them as datatable queries?

possibly also more complicated things like hidden params that do queries to hide/show parts of a workbook

at some point in the packaging/deployment process, it unpacks the templates to turn them into an npm package, and the long path/names and the build’s directory structure mean it exceeds some limits, either in tar/gz itself or in the build pipeline system:

D:\a\r1\a\npm-publish_azure_monitor_workbook_templates-1.0.0-build.15583.tgz_\azure_monitor_workbook_templates-1.0.0-build.15583.tar\package\en-us\workbooks\Network Insights-ExpressRouteCircuitsWorkbooks-NetworkInsights-ExpressRouteCircuitMetrics-Minified_

The “minified” file gets truncated and loses its suffix, that file was ...-Minified.json. (the path as above is 257 ch, which implies a 255 limit (not sure where the extra 2 are, but i want to say the actual path above doesn't actually have _ prefix/suffix but the build output might be adding that? or perhaps the drive specifier doesn't count as part of the length? unsure)

I have a workbook with a global parameter for holding selections made from an initial query table. I then want to use that selection to filter results in a later query.

I also want to default to showing all data when no selection has been made, and only filter when the multi-value parameter is populated.

I've set set the initial query to export it's selection parameters as follows:

I see results when I have made a selection, but I can't figure out how to create value KQL when the parameter has no selections, and is a null.

For example:

| where AppService has_any ({AppServices})
is rendered as
| where AppService has_any ()

and similarly something like this to try and work around the null doesn't parse either:
| extend myFilter = iff({AppServices:label} = '<unset>','',{AppServices})
because it's rendered as
| extend myFilter = iff('<unset>' = '<unset>','',)

Basically, I need a value other than :label that won't be nulll when the parameter is unset. Are there any tips for doing this? I can't see anything in the docs that helps me and I can't figure out how to create KQL that will be valid when the the parameter is null.

We have a below kusto query in log analytics work books for azure data factory .

now we need a kusto query for each activity of the pipeline and also it should display error message

Could you please help me put

let data = ADFTriggerRun
| where TimeGenerated {TimeRange}
| where Status != "Running" and Status !contains "Waiting"
| where TriggerName contains "isd"
| where ResourceId contains "ESWFDHYUT01";
data
| summarize LastTriggerTime = max(TimeGenerated) by TriggerName
| join kind = leftouter
(
data
| summarize LastTriggerStatus = max(Status) by TriggerName,TimeGenerated
)
on TriggerName, $left.LastTriggerTime == $right.TimeGenerated
| join kind = leftouter
(
data
| summarize RunCount = count() by TriggerName
)
on TriggerName
| join kind = leftouter
(
data
| where Status == "Succeeded"
| summarize SuccessCount = count() by TriggerName
)
on TriggerName
| join kind = leftouter
(
data
| where Status == "Failed"
| summarize FailCount = count() by TriggerName
)
on TriggerName
| join kind = leftouter
(
data
| where Status == "Cancelled"
| summarize CancelCount = count() by TriggerName
)
on TriggerName
| project TriggerName, RunCount, SuccessCount, FailCount,CancelCount,LastTriggerTimeUTC = LastTriggerTime,LastTriggerTimeIST = LastTriggerTime + 5h + 30m ,LastTriggerStatus
| order by LastTriggerStatus asc,TriggerName asc;

Need contributor access to Application-Insights-Workbooks for completing PR for adding Service Bus AtResource Template: #1447

Hi I see some stranges drops in Workbook of my IoT Hub

@micahl you told me of some new ux polish, i think since the update is this behavior?!?

See 31.01

When i Zoom in this range

I can see this drops on all charts, somethimes at the same thime, somthimes not 🤔

I am not shure, is this now the real behavior, because of missing data or is it now wrong.

Sorry if I missed the obvious but how are we able to use these workbooks? I went to "Azure monitor > workbooks > public templates" but I can't find the majority of these there. Any help much appreciated.

https://github.com/microsoft/Application-Insights-Workbooks/blob/master/Documentation/Parameters/DropDown.md

there are samples there for json, query dropdowns, but they don't explain the "advanced" behaviors for

column 0 = value, column 1 = name, column 2 = selected, column 3 (or named "group") = group

which applies to all of the various dropdowns.

not sure how/why/when it stopped running but it isn't running anymore.

Is there any REST API or dedicated azure CLI commands that can help in the deployment of the workbook.
Workbook deployment mentions ARM deployment, but maintaining a huge "serializedData" in the arm template is nowhere practical.

Hi Guys,

I enabled the vault diagnostic settings with new resource specific mode and integrated it with Log Analytics and now i am able to see the backup reports but when i pin the report to azure dashboard then widget is pinned but no data displays on it. Get the below error on widget:

This query could not run because some parameters are not set.
Please set: JobOperation, JobStatus, JobFailureCode, ContainerNameWithBackupItemName, JobMetricSortBy, JobMetricOrder, JobMetricRowsPerGrid, JobMetricPageNumber

Could anyone help me in this?

Thanks,
Shavez Ali

1. warning: edit mode - Workbooks that are unlocked (in edit mode) are rare, but possible. but it's almost always never what you want.

so the validator should warn if a workbook is in edit mode, so we catch it in PRs here.

2. error: defaultResourceIds, fallbackResourceIds - these should always be not set, they're for workbooks, not for templates

3. warning: crossComponentResources that aren't using parameters?

Connections workbook doesn't support custom time range

heWhen switching metrics from CPU->Mem the hive dashboard (Average Cluster utilization % by nodepool) does not change. It only always shows the same value on the hive.
There is also something wrong with the nodepool names, if you have more than one nodepool.
All my linux nodepools (which naturally have other names rather than "default" )are shown as default. So I end up with 3 "default" nodepools in my cluster

When selecting an icon threshold for "normal" it displays an i with a circle, but in the workbook it displays the same blue icon for informational.

Is it currently possible to use parameters to populate metric settings? I can choose a parameter for the Metric (e.g. using cpu_percent) however even though the parameter seems to be correct I'm unable to select an Aggregation. I'm not clear how this would work with multiple parameters either.

I was attempting to duplicate the functionality of Database Resource Utilization in Azure SQL Elastic Pools.

Hi,

I am trying to create a workbook with a multi-select.
You have an example here: https://github.com/microsoft/Application-Insights-Workbooks/blob/master/Documentation/Interactivity.md#example

Can you please provide me the workbook or the Kusto Query for it?
I am having troubles to display the selected rows and use them in my other queries.

When I select two rows and print it with:
print d = '{SelectedRow}'

"{"Computer":"WW00001S","Workspace":"az1-dedicated-large-log","Average":3239,"P90th":3377,"P95th":3445,"Max":3674]","Apps":"[\"app1\",\"app2\",\"app3\"]","Properties":"{\"Fully Qualified Domain Name\":\"WW00001S\",\"Workspace\":\"az1-dedicated-large-log\",\"OS Type\":\"windows\",\"Operating System\":\"Windows Server 2016 Version 1607\",\"Ipv4 Addresses\":[\"10.0.8.146\"],\"DNS Names\":[\"WW00001S\"],\"CPUs\":\"4 @ 2594 MHz\",\"Physcial Memory\":\"8191 MB\",\"Virtualization State\":\"virtual\"}"}","{"Computer":"WW00000M","Workspace":"az2-dedicated-large-log","Average":3399,"P90th":3708,"P95th":3763,"Max":3843]","Apps":"[\"app1\",\"app4\"]","Properties":"{\"Fully Qualified Domain Name\":\"WW00000M\",\"Workspace\":\"az2-dedicated-large-log\",\"OS Type\":\"windows\",\"Operating System\":\"Windows Server 2016 Version 1607\",\"Ipv4 Addresses\":[\"10.0.8.56\"],\"DNS Names\":[\"WW00000M\"],\"CPUs\":\"4 @ 2594 MHz\",\"Physcial Memory\":\"8191 MB\",\"Virtualization State\":\"virtual\"}"}"

How can I parse it? I just need the combination of Computer and Workspace

If I remove the Apps and Properties it does work. But I need this data.

Thanks!