public async Task <string> FetchZoneForTraceId(string uxoTraceId, ICslQueryProvider queryProvider)
{
var query = $"UxoTrace | where TraceId == \"{uxoTraceId}\" | project Zone | take 1";
var queryResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Uxo_Connection, DatabaseConstants.Uxo_Database, query, queryProvider);
object[] result = (object[])queryResult.Results[0];
return(result[0].ToString());
}
public async Task <HttpResponseMessage> GetUxoLogs(string traceId)
{
try
{
if (string.IsNullOrEmpty(traceId))
{
throw new Exception($"Invalid traceId {traceId}");
}
string token = "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IkJCOENlRlZxeWFHckdOdWVoSklpTDRkZmp6dyIsImtpZCI6IkJCOENlRlZxeWFHckdOdWVoSklpTDRkZmp6dyJ9.eyJhdWQiOiJkYjY2MmRjMS0wY2ZlLTRlMWMtYTg0My0xOWE2OGU2NWJlNTgiLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC83MmY5ODhiZi04NmYxLTQxYWYtOTFhYi0yZDdjZDAxMWRiNDcvIiwiaWF0IjoxNTc0MTg4ODYyLCJuYmYiOjE1NzQxODg4NjIsImV4cCI6MTU3NDE5Mjc2MiwiYWlvIjoiQVZRQXEvOE5BQUFBbmpyTlpDVVFWNEFaeVg0dlk1aHVwKzBHVTRKcUJxSm5qMGNqQnJsVHllejNXWXRRalNQc2hLRHgvU3NWK0hFaGdGV2s0RUdyUCtZQnRqMXpTaEd0VG8zcFpGS0ZOMUVtTWFVNG8veVI0OGs9IiwiYW1yIjpbInB3ZCIsIm1mYSJdLCJmYW1pbHlfbmFtZSI6IlBvZHVyaSIsImdpdmVuX25hbWUiOiJTYWljaGFyYW4iLCJpcGFkZHIiOiIxNjcuMjIwLjI0LjExMSIsIm5hbWUiOiJTYWljaGFyYW4gUG9kdXJpIiwibm9uY2UiOiJiZmUxMWM3Mi0yODZkLTQ5ZjgtOWEwMi02NzMxOTEzNDY3YTIiLCJvaWQiOiI5Mzk5Yzk1YS03YjhlLTQwNzktODM5MS1lYTEyMjM3ZTg2ZDkiLCJvbnByZW1fc2lkIjoiUy0xLTUtMjEtMjEyNzUyMTE4NC0xNjA0MDEyOTIwLTE4ODc5Mjc1MjctMzI4MzczOTgiLCJyaCI6IkkiLCJzdWIiOiJZWVh4d29FWUg4cG9yRVZxTW5rY3ZyUDJBczlCd2R4UEhxb0E5LTR0UTF3IiwidGlkIjoiNzJmOTg4YmYtODZmMS00MWFmLTkxYWItMmQ3Y2QwMTFkYjQ3IiwidW5pcXVlX25hbWUiOiJzYXBvZHVyaUBtaWNyb3NvZnQuY29tIiwidXBuIjoic2Fwb2R1cmlAbWljcm9zb2Z0LmNvbSIsInV0aSI6ImxHbmF2Yjh3ZkVpWEQ4Qk02QkVCQUEiLCJ2ZXIiOiIxLjAifQ.GmgoMwnBYFFe1VnJ3Usqeh9p6GVjHZ1JgyhJWe7fuzMNXsxZE9A7l4tWH_4HQUTRwUrgpBd54e_glDN1QIVw8xRfjLUA8ATHsBG_ctpyTK5RmYIK3E58JKPPJgr7PxS3tSlZhRGWFiNBYo-K9qrQtdTUq2Uky-JEEMZapFBOIBzrW6Ut5xivUmGD8lEligk5Z6tsZm3Vc-pAZiGnNturp0lSgonMJ-ijpY7oMqB2SyMYlkuguBedpFbHY4Og5BIZG-kUKM0nUZomQl3RAqGn09W6DWC8-DISEbicZ761WtWebQ-cCNDyoBFFjFOFX6l-PPTLaY3w-cK_MBdxG8F7qw&state=412d483e-5f55-4674-84f0-d247ddfe663f&session_state=e55787ff-0b9e-4e2d-9969-b943ffa0ee14";
var jwtHandler = new JwtSecurityTokenHandler();
var readableToken = jwtHandler.ReadJwtToken(token);
var claims = readableToken.Claims;
string oid = "9399c95a-7b8e-4079-8391-ea12237e86d9";
string clientId = "db662dc1-0cfe-4e1c-a843-19a68e65be58";
string redirectUrl = "https://microsoft/kustoclient";
var userIdentifier = new UserIdentifier(oid, UserIdentifierType.UniqueId);
string authority = "https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47";
AuthenticationContext authContext = new AuthenticationContext(authority);
AuthenticationResult authResult = await authContext.AcquireTokenAsync(DatabaseConstants.Uxo_Connection, clientId, new Uri(redirectUrl), new PlatformParameters(PromptBehavior.Never), userIdentifier);
Console.WriteLine(authResult.AccessToken);
var kustoConnectionStringBuilder = new KustoConnectionStringBuilder(DatabaseConstants.Uxo_Connection)
{
FederatedSecurity = true,
InitialCatalog = "NetDefaultDB",
Authority = authority,
UserToken = authResult.AccessToken
};
var queryProvider = KustoClientFactory.CreateCslQueryProvider(kustoConnectionStringBuilder);
var UxoRequestResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Uxo_Connection, DatabaseConstants.Uxo_Database, GetQuery("UxoRequest", traceId), queryProvider);
var UxoConnectionResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Uxo_Connection, DatabaseConstants.Uxo_Database, GetQuery("UxoConnection", traceId), queryProvider);
var UxoTraceResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Uxo_Connection, DatabaseConstants.Uxo_Database, GetQuery("UxoTrace", traceId), queryProvider);
var UxoWebSocketMessageResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Uxo_Connection, DatabaseConstants.Uxo_Database, GetQuery("UxoWebSocketMessage", traceId), queryProvider);
var UxoEventResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Uxo_Connection, DatabaseConstants.Uxo_Database, GetQuery("UxoEvent", traceId), queryProvider);
var result1 = new List <DatabaseResult>()
{
UxoRequestResult, UxoConnectionResult, UxoTraceResult, UxoWebSocketMessageResult, UxoEventResult
};
return(new HttpResponseMessage()
{
Content = new StringContent(JsonConvert.SerializeObject(result1))
});
}
catch (Exception e)
{
Console.Write(e);
return(new HttpResponseMessage()
{
Content = new StringContent(e.Message),
StatusCode = System.Net.HttpStatusCode.InternalServerError
});
}
}
public async Task <HttpResponseMessage> GetCortexLogs(string traceId)
{
try
{
if (string.IsNullOrEmpty(traceId))
{
throw new Exception($"Invalid traceId {traceId}");
}
string authority = "https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47";
string clientId = "db662dc1-0cfe-4e1c-a843-19a68e65be58";
string redirectUrl = "https://microsoft/kustoclient";
AuthenticationContext authContext = new AuthenticationContext(authority);
AuthenticationResult authenticationResult = authContext.AcquireTokenAsync(DatabaseConstants.Uxo_Connection, clientId, new Uri(redirectUrl), new PlatformParameters(PromptBehavior.Always)).GetAwaiter().GetResult();
Console.WriteLine(authenticationResult.AccessToken);
var kustoConnectionStringBuilder = new KustoConnectionStringBuilder(DatabaseConstants.Uxo_Connection)
{
FederatedSecurity = true,
InitialCatalog = "NetDefaultDB",
Authority = authority,
UserToken = authenticationResult.AccessToken
};
var queryProvider = KustoClientFactory.CreateCslQueryProvider(kustoConnectionStringBuilder);
zone = await uxoLoggerController.FetchZoneForTraceId(traceId, queryProvider);
if (string.IsNullOrEmpty(zone))
{
throw new Exception($"No Zone found for {traceId}");
}
if (string.Equals(zone, "WestUS2", StringComparison.InvariantCultureIgnoreCase))
{
Database = DatabaseConstants.Cortex_PPE_Database;
}
else
{
Database = DatabaseConstants.Cortex_Prod_Database;
}
var CortexTraceResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Cortex_Connection, Database, GetQuery("CortexTraceMDS", traceId), queryProvider);
var CortexMonitoredScopeResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Cortex_Connection, Database, GetQuery("CortexMonitoredScopeMDS", traceId), queryProvider);
var result = new List <DatabaseResult>()
{
CortexTraceResult, CortexMonitoredScopeResult
};
return(new HttpResponseMessage()
{
Content = new StringContent(JsonConvert.SerializeObject(result))
});
}
catch (Exception e)
{
Console.Write(e);
return(new HttpResponseMessage()
{
Content = new StringContent(e.Message),
StatusCode = System.Net.HttpStatusCode.InternalServerError
});
}
}
public async Task <HttpResponseMessage> GetSpeechLogs(string traceId)
{
try
{
if (string.IsNullOrEmpty(traceId))
{
throw new Exception($"Invalid traceId {traceId}");
}
string authority = "https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47";
string clientId = "db662dc1-0cfe-4e1c-a843-19a68e65be58";
string redirectUrl = "https://microsoft/kustoclient";
AuthenticationContext authContext = new AuthenticationContext(authority);
AuthenticationResult authenticationResult = authContext.AcquireTokenAsync(DatabaseConstants.Uxo_Connection, clientId, new Uri(redirectUrl), new PlatformParameters(PromptBehavior.Always)).GetAwaiter().GetResult();
Console.WriteLine(authenticationResult.AccessToken);
var kustoConnectionStringBuilder = new KustoConnectionStringBuilder(DatabaseConstants.Uxo_Connection)
{
FederatedSecurity = true,
InitialCatalog = "NetDefaultDB",
Authority = authority,
UserToken = authenticationResult.AccessToken
};
var queryProvider = KustoClientFactory.CreateCslQueryProvider(kustoConnectionStringBuilder);
speechTraceId = await uxoLoggerController.FetchSpeechTraceId(traceId, queryProvider);
if (string.IsNullOrEmpty(speechTraceId))
{
throw new Exception("No Speech logs found");
}
var phraseTextResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Speech_Connection, DatabaseConstants.Speech_Database, GetQuery("phrasetext", "ImpressionId", speechTraceId), queryProvider);
var websocketDebugInfoResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Speech_Connection, DatabaseConstants.Speech_Database, GetQuery("websocketdebuginfo", "impressionId", speechTraceId), queryProvider);
var traceDebugInfoResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Speech_Connection, DatabaseConstants.Speech_Database, GetQuery("tracedebuginfo", "impressionId", speechTraceId), queryProvider);
var decoderEventsDebugInfoResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Speech_Connection, DatabaseConstants.Speech_Database, GetQuery("decodereventsdebuginfo", "impressionId", speechTraceId), queryProvider);
var turnStopResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Speech_Connection, DatabaseConstants.Speech_Database, GetQuery("turnstop", "impressionId", speechTraceId), queryProvider);
var outboundgrpcDebugInfoResult = await DatabaseQueryRunner.RunQuery(DatabaseConstants.Speech_Connection, DatabaseConstants.Speech_Database, GetQuery("outboundgrpcdebuginfo", "impressionId", speechTraceId), queryProvider);
var result = new List <DatabaseResult>()
{
phraseTextResult, websocketDebugInfoResult, traceDebugInfoResult, decoderEventsDebugInfoResult, turnStopResult, outboundgrpcDebugInfoResult
};
return(new HttpResponseMessage()
{
Content = new StringContent(JsonConvert.SerializeObject(result))
});
}
catch (Exception e)
{
Console.Write(e);
return(new HttpResponseMessage()
{
Content = new StringContent(e.Message),
StatusCode = System.Net.HttpStatusCode.InternalServerError
});
}
}
