{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/ApplicationInsights-dotnet/issues/768","repository_url":"https://api.github.com/repos/Microsoft/ApplicationInsights-dotnet","labels_url":"https://api.github.com/repos/Microsoft/ApplicationInsights-dotnet/issues/768/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/ApplicationInsights-dotnet/issues/768/comments","events_url":"https://api.github.com/repos/Microsoft/ApplicationInsights-dotnet/issues/768/events","html_url":"https://github.com/Microsoft/ApplicationInsights-dotnet/issues/768","id":313671674,"number":768,"title":"SQL dependency missing command text","user":{"login":"andygjp","id":1445933,"avatar_url":"https://avatars0.githubusercontent.com/u/1445933?v=4","gravatar_id":"","url":"https://api.github.com/users/andygjp","html_url":"https://github.com/andygjp","followers_url":"https://api.github.com/users/andygjp/followers","following_url":"https://api.github.com/users/andygjp/following{/other_user}","gists_url":"https://api.github.com/users/andygjp/gists{/gist_id}","starred_url":"https://api.github.com/users/andygjp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andygjp/subscriptions","organizations_url":"https://api.github.com/users/andygjp/orgs","repos_url":"https://api.github.com/users/andygjp/repos","events_url":"https://api.github.com/users/andygjp/events{/privacy}","received_events_url":"https://api.github.com/users/andygjp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-04-12T10:42:14Z","updated_at":"2018-04-12T21:39:17Z","closed_at":null,"author_association":"NONE","body":"## Repro Steps\r\nI browse an entity set in the browser (my app is an OData Web API app) that causes a query to be executed. The SQL dependency event is captured, but its missing the command. I have restarted and stop/started the web app many times.\r\n\r\nThe ApplicationInsights.config, containing the key, is deployed with the app. I have added the same key to the APPINSIGHTS_INSTRUMENTATIONKEY web app application setting.\r\n\r\nWhere am I going wrong?\r\n\r\n##  Actual Behavior\r\nThe SQL dependency event does not show the command, just the database server and database name. The SDK version is reported as rddf:2.5.1-195\r\n\r\n## Expected Behavior\r\nThe command should be populated with the command\r\n\r\n## Version Info \r\nAzure Web App\r\n\r\n.NET 4.7.1\r\n\r\nAutofac v=4.6.2   \r\nAutofac.WebApi2 v=4.1.0\r\nEntityFramework v=6.2.0\r\nFeatureSwitcher.Configuration v=1.0.1\r\nMicrosoft.ApplicationInsights.DependencyCollector v=2.5.1\r\nMicrosoft.ApplicationInsights.TraceListener v=2.5.0\r\nMicrosoft.ApplicationInsights.Web v=2.5.1\r\nMicrosoft.AspNet.OData v=6.1.0\r\nMicrosoft.AspNet.WebApi.Owin v=5.2.4\r\nMicrosoft.OData.Core v=7.4.1\r\nMicrosoft.Owin.Cors v=4.0.0\r\nMicrosoft.Owin.Host.SystemWeb v=4.0.0\r\nSerilog v=2.6.0\r\nSerilog.Enrichers.Environment v=2.1.2\r\nSerilog.Enrichers.Process v=2.0.1\r\nSerilog.Settings.AppSettings v=2.1.2\r\nSerilog.Sinks.ApplicationInsights v=2.6.0\r\nSystem.Net.Http v=4.3.3\r\n\r\n![image](https://user-images.githubusercontent.com/1445933/38670757-9884e2be-3e41-11e8-8b33-80b80e7c08d6.png)"},"comment":{"url":"https://api.github.com/repos/Microsoft/ApplicationInsights-dotnet/issues/comments/380952536","html_url":"https://github.com/Microsoft/ApplicationInsights-dotnet/issues/768#issuecomment-380952536","issue_url":"https://api.github.com/repos/Microsoft/ApplicationInsights-dotnet/issues/768","id":380952536,"user":{"login":"andygjp","id":1445933,"avatar_url":"https://avatars0.githubusercontent.com/u/1445933?v=4","gravatar_id":"","url":"https://api.github.com/users/andygjp","html_url":"https://github.com/andygjp","followers_url":"https://api.github.com/users/andygjp/followers","following_url":"https://api.github.com/users/andygjp/following{/other_user}","gists_url":"https://api.github.com/users/andygjp/gists{/gist_id}","starred_url":"https://api.github.com/users/andygjp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andygjp/subscriptions","organizations_url":"https://api.github.com/users/andygjp/orgs","repos_url":"https://api.github.com/users/andygjp/repos","events_url":"https://api.github.com/users/andygjp/events{/privacy}","received_events_url":"https://api.github.com/users/andygjp/received_events","type":"User","site_admin":false},"created_at":"2018-04-12T21:39:17Z","updated_at":"2018-04-12T21:39:17Z","author_association":"NONE","body":"Hi @cijothomas,\r\n\r\nI've tried as you've suggested, but I still get rddf.\r\n\r\nDoes the type of app plan matter? (I'm using the free tier.)\r\n\r\nAnymore information I can add that'll help diagnose the issue?\r\n\r\nCheers,\r\nAndy"}}
{"actor":{"display_login":"andygjp"}}