question

therealjoeyj avatar image
therealjoeyj asked

Unable to query cross cluster to access PlayFab Insights from another Log Analytics Workspace

Query in Kusto Explorer from another workspace:

cluster("insights.playfab.com").database("REDACTED").['events.all'] | limit 1

Error:

{
    "error": {
        "code": "FailedToQueryDraft",
        "message": "failed to query Draft resource name: REDACTED, resource id: REDACTED;",
        "@type": "adxproxy.Exceptions.FailedToQueryDraft",
        "@message": "failed to query Draft resource name: REDACTED, resource id: REDACTED;",
        "@context": {
            "timestamp": "2022-03-10T23:59:27.653Z",
            "serviceAlias": "REDACTED",
            "machineName": "prod-adxproxy-64565ff5b9-7jx5n",
            "processName": "adxproxy",
            "processId": 1,
            "appDomainName": "DevExp-Proxy",
            "clientRequestd": "REDACTED",
            "activityId": "REDACTED",
            "activityType": "query",
            "version": "0.2.641",
            "productVersion": "AdxproxyOverAI_LA_2021.11.05.1",
            "buildTime": "2021-11-05T21:51:54.262Z",
            "environmentName": "prod-ai-oms-wus",
            "instanceResourceGroup": "azmon-prod-wus-0",
            "instanceCluster": "azmon-prod-wus-0",
            "instanceStamp": "prod-wus",
            "instanceRegion": "westus",
            "instanceGeography": "unitedstates"
        },
        "@url": "/subscriptions/REDACTED/resourcegroups/REDACTED/providers/microsoft.operationalinsights/workspaces/REDACTED/v1/rest/query",
        "@text": "cluster(\"insights.playfab.com\").database(\"REDACTED\").['events.all'] | limit 1",
        "@database": "REDACTED",
        "@cluster": "/subscriptions/REDACTED/resourcegroups/REDACTED/providers/microsoft.operationalinsights/workspaces/REDACTED/v1/rest/query",
        "@permanent": true
    }
}
analytics
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Gosen Gao avatar image
Gosen Gao answered

Here is the official documentation about how to do cross query of your Log Analytics or Application Insights workspace, you can have a look.

4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

therealjoeyj avatar image therealjoeyj commented ·

can you share the full azure resource url for insights?

0 Likes 0 ·
therealjoeyj avatar image therealjoeyj commented ·

ping? I can't try out the linked doc without the full azure resource url for the Log Analytics workspace that hosts Insights.

0 Likes 0 ·
Gosen Gao avatar image Gosen Gao therealjoeyj commented ·

You can follow Connecting Azure Data Explorer to Insights - PlayFab | Microsoft Docs to connect PlayFab insights to ADX.

0 Likes 0 ·
therealjoeyj avatar image therealjoeyj Gosen Gao commented ·

I don't use ADX. The post mentions using Kusto Explorer. Is this just not possible? Seems like a rather large omission.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.