That was actually a brilliant Idea, as I already have Redis running :) The number of devices will hopefully increase 10 to a 100-fold, but this will still scale. So will it with additional transformations in the future. Thanks! The only drawback with this solution is that I have no excuse to sit down and play with Datalakes and all its tools... :laugh:

Thanks! :)

Volume, Yes. As of today, the volume is not a problem at all. But when we get thousands of devices online, I'm a little bit afraid that the Job generating the aggregates will struggle/lead to locks. Also, who knows what other Post-processing needs will occur in the future.

Scenario: We have (as of today, will be more) 200 devices sending telemetry into an SQL server with a frequency of 5 rows each pr. second. Each row contains 6 decimal values to be processed into another dataset/table containing min/max/avg of these values in 1 minute intervals. I have never worked with DataLakes and similar tech, so I wonder: Should i read up on storing the raw telemetry in a datalake, and set up post processing there, or Just go for my existing SQL server and create a c# job post processing the data in the background myself? TIA...

If you don't know... I have trouble finding it in the spec. I don't ask for help on things before I've tried to look it up myself. ;)

I have a set of IoT devices that connects to Azure IoT hub regularly to send in telemetry. Sometimes I need to send messages to the device. I do this my using the:

devices/{device_id}/messages/devicebound/#

queue. The device are using a built-in MQTT library. If I send something to the device while it is offline, it was my impression that the message should be retained in the devicebound queue until the device came online again, and read the queue. If I send the messeage when the device is online, everything works ok, and the device gets the message. If sent while offline, the queue is empty when the device come online again, and the message is lost. Am I right in assuming that the devicebound queue should retain the message until the device comes online and read it? TIA...

First, if this isn't the right forum, my apologies, and please direct me to the correct one... I have read, and searched for a week now, and I just don't seem to get it. I have a Microsoft Partner Center Global Admin User; "SvcUser" Using the Partner Center API with this user, I can list all our customers, and get their tennantIds. Using a TennantId, I gan get the customers users and subscriptions, and all is well. The App registered in Azure have all the permissions set up... Now I need to get all domains of a specific tennant... The Partner Center API does not support this, so I turn to Microsoft Graph. The concept, as I understand it, is to use the "common" endpoint to log in with my "SvcUser" and get a Autherntication code. Then connect to the specific tennant endpoint, supplying the code from the previous step, to get an Authorization token. Once I have this "Authorization token", I should be home free... A.) Can anyone provide me with a clear example on how to implement the Authentication and Authorization calls (C# preferably :rolleyes: ) ? B.) secondary; straighten me out, if all of the above is completely rubbish ? Thanks! :)

Its a Norwegian proverb... Don't know where/why... But it is a good one! :) Still got some small problems, thou... I turned on ExecutionPolicy so it looks like this:

$li = New-WinUserLanguageList "nb-NO";
$li[0].InputMethodTips.Add("0414:A0000414");
$li[0].InputMethodTips.Remove("0414:00000414");
Set-WinUserLanguageList $li -Force;
$li = Get-WinUserLanguageList;
$li[0].InputMethodTips.Add("0414:00000414");
Set-WinUserLanguageList $li -Force;

- This creates a new languagelist with Norwegian standard culture, - Adds the Norwegian Apple input (keyboard). - Removes the Standard Norwegian keyboard. - Set the list to be the current one in windows. - Add back the Norwegian standard keyboard. - Reapply the list to windows. The sole purpose of the operation is to set the language bar to "Norwegian, with Apple Keyboard" with Norwegian with std. keyboard as a second option. And it *ALWAYS* does, when run from Powershell/Command prompt. When run embedded in c#, it sets Input to Norwegian Standard, and does NOT show Apple keyboard as a first (or second) alternative... This drives me NUTS! -- Dag.

Yeah... It looks like that is where the dog is buried... ;P Thanks...

Thanks for commenting... Thats not it, thou... Just me trying small adjustments. With or without quotes, and with or without re-getting the newly set list. Results are the same. -- Dag.

Thanks for commenting... The differences are just me trying small differences. They where the same. Didn't work in c# when they were identical either... (But I should of course have posted them equal, to avoid confusion). -- Dag.

I know this isn't a Powershell forum, but the question is about PS in C#.. I have the following Powershell, that clears my languagebar, Setting Norwegian language. Adds Norwegian Apple Keyboard, removes, then Adds back to the end normal Norwegian keyboard:

$li = New-WinUserLanguageList "nb-NO";
$li[0].InputMethodTips.Add("0414:A0000414");
$li[0].InputMethodTips.Remove("0414:00000414");
Set-WinUserLanguageList $li -Force
$li = Get-WinUserLanguageList
$li[0].InputMethodTips.Add("0414:00000414");
Set-WinUserLanguageList $li -Force

This works Peachy when run from the powershell commandline. It updates the Language bar, and set the Apple keyboard as default. But when embedding it in C# like this:

string script = "";
script += "$li = New-WinUserLanguageList nb-NO;";
script += "$li[0].InputMethodTips.Add(\"0414:A0000414\");";
script += "$li[0].InputMethodTips.Remove(\"0414:00000414\");";
script += "Set-WinUserLanguageList $li -Force;";
script += "$li[0].InputMethodTips.Add(\"0414:00000414\");";
script += "Set-WinUserLanguageList $li -Force;";

using ( PowerShell ps = PowerShell.Create() ) {

ps.AddScript( script );
var result = ps.Invoke();

foreach ( var item in result ) {
    //Nothing.
}

}

The language bar does not get updated, although the language IS switched to Norwegian... Is there any limitations on what kind of ps-scripts you can embed in C#? (Both the script and the c# code runs as me/current user)... TIA. -- Dag.

Say I have a userTable and an orderTable. the criteria for the usertable is such that I WILL get the same user more than once How do I do a DISTINCT and a SUM(...) in Linq? In SQL it is : SELECT DISTINCT u.Name, u.Phone, SUM(o.Amount) FROM User u JOIN Order o ON u.UserId = o.UserId WHERE u.Type = 1 OR u.External = 1 GROUP BY Name, Phone TIA... -- Dag