Tag Archives: microsoft
Microsoft Copilot in Azure Series – AKS Cluster configuration and management
In addition to helping you in deploying applications and identifying resources in your Azure Kubernetes Service (AKS) cluster, Microsoft Copilot in Azure can help you with insights into best practices for configuration and management.
Microsoft Copilot in Azure can:
Look at the AKS documentation and identify best practices for configuration and management of your cluster. While it can’t directly apply these to the cluster, you can get insights on what the settings are, get more information on each recommendation, and ask Copilot to help you implement them.
Examples of these include restricting access to the Cluster API to certain known IP addresses, changing the AKS pricing tier, and enabling the AKS backup extension.
We hope you enjoy watching our video and learning how to use Copilot in Azure for managing and configuring your AKS cluster. To learn more about Copilot in Azure, you can check out the documentation page. Let us know what you think about Copilot in Azure and share your feedback with us in the comments section below.
Microsoft Tech Community – Latest Blogs –Read More
macro or vba
I would like to show the dates of a subform. When line 5 is completed, I need those dates, if not, the dates of line 4 should be taken, if not, the dates of line 3 and so on till line 0. Can someone tell me how to do?
Thanks
I would like to show the dates of a subform. When line 5 is completed, I need those dates, if not, the dates of line 4 should be taken, if not, the dates of line 3 and so on till line 0. Can someone tell me how to do?Thanks Read More
How to recover accidentally deleted desktop folder on Windows 11?
Hi everyone,
I hope someone can help me out here. I accidentally deleted my entire Desktop folder in Windows 11 and I’m not sure how to recover it. I’ve already checked the Recycle Bin and unfortunately, it’s not there. Here’s what I’ve tried so far:
Checking the Recycle Bin (folder isn’t there)Using File Explorer to search for the folderLooking into OneDrive backups (no luck)
I’m really in a pinch because I had some important files and shortcuts on my Desktop that I need to retrieve. Can anyone suggest any reliable tool for recovering accidentally deleted desktop folder on Windows 11? Any input would be greatly appreciated
Hi everyone, I hope someone can help me out here. I accidentally deleted my entire Desktop folder in Windows 11 and I’m not sure how to recover it. I’ve already checked the Recycle Bin and unfortunately, it’s not there. Here’s what I’ve tried so far:Checking the Recycle Bin (folder isn’t there)Using File Explorer to search for the folderLooking into OneDrive backups (no luck)I’m really in a pinch because I had some important files and shortcuts on my Desktop that I need to retrieve. Can anyone suggest any reliable tool for recovering accidentally deleted desktop folder on Windows 11? Any input would be greatly appreciated Read More
Manipulable objects incorrect physics behavior with kinematic
Hi
I have a “mesh interactable setup” manipulable object with constraints on rotation and movement. I can move object only up and down and I can’t rotate. the object in the rigidbody component has the kinamatic property active. Until a few days ago it worked perfectly. inside mesh I raised and lowered the object and it stayed exactly where I left it iwthout momentum. Exactly what i wanted. Today it no longer works. I can no longer move the object. It is selected. It is hovered but i cannot move.
In unity editor I have mesh toolkit 5.2402.240 and from the editor in play mode it is still working, but inside a custom mesh event it no longer works. Has anything changed about the physics of manipulable objects?
Thank you
HiI have a “mesh interactable setup” manipulable object with constraints on rotation and movement. I can move object only up and down and I can’t rotate. the object in the rigidbody component has the kinamatic property active. Until a few days ago it worked perfectly. inside mesh I raised and lowered the object and it stayed exactly where I left it iwthout momentum. Exactly what i wanted. Today it no longer works. I can no longer move the object. It is selected. It is hovered but i cannot move.In unity editor I have mesh toolkit 5.2402.240 and from the editor in play mode it is still working, but inside a custom mesh event it no longer works. Has anything changed about the physics of manipulable objects? Thank you Read More
Personal BYOD – filter contacts
Hi
We are a college and need to enrol BYOD devices to meet CE requirements, which includes staff personal mobiles for when they access email etc. Android works really well with Personal/Work split, iOS devices, not so well.
We’ve noticed that when a personal phone is enrolled and they search contacts, it is pulling back all contacts within the tenant and there is no way to switch this off when just using on a personal basis. I need to filter this to search staff only, excluding students. How can this be achieved.
Thanks
Hi We are a college and need to enrol BYOD devices to meet CE requirements, which includes staff personal mobiles for when they access email etc. Android works really well with Personal/Work split, iOS devices, not so well. We’ve noticed that when a personal phone is enrolled and they search contacts, it is pulling back all contacts within the tenant and there is no way to switch this off when just using on a personal basis. I need to filter this to search staff only, excluding students. How can this be achieved. Thanks Read More
Bicep Deploy Azure
{“code”:”DeploymentFailed”,”target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Resources/deployments/AzFuncs”,”message”:”At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.”,”details”:[{“target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Web/sites/saphir-webshop-order”,”message”:”There was a conflict. The remote name could not be resolved: ‘mtvpprlfzkau2azfunctions.file.core.windows.net'”}]}
Here is my bicep file!
@description(‘The name of the function app that you wish to create.’)
param appName string = ‘saphir-webshop-order’
@description(‘Storage Account type’)
@allowed([
‘Standard_LRS’
‘Standard_GRS’
‘Standard_RAGRS’
])
param storageAccountType string = ‘Standard_LRS’
@description(‘Location for all resources.’)
param location string = resourceGroup().location
@description(‘Location for Application Insights’)
param appInsightsLocation string
@description(‘The language worker runtime to load in the function app.’)
@allowed([
‘node’
‘dotnet’
‘java’
])
param runtime string = ‘dotnet’
var functionAppName = appName
var hostingPlanName = appName
var applicationInsightsName = appName
var storageAccountName = ‘${uniqueString(resourceGroup().id)}azfunctions’
var functionWorkerRuntime = runtime
resource storageAccount ‘Microsoft.Storage/storageAccounts@2022-05-01’ = {
name: ‘earthwebshopstorage’
location: location
sku: {
name: storageAccountType
}
kind: ‘Storage’
properties: {
supportsHttpsTrafficOnly: true
defaultToOAuthAuthentication: true
}
}
resource hostingPlan ‘Microsoft.Web/serverfarms@2021-03-01’ = {
name: hostingPlanName
location: location
sku: {
name: ‘Y1’
tier: ‘Dynamic’
}
properties: {}
}
resource functionApp ‘Microsoft.Web/sites@2023-12-01’ = {
name: appName
location: ‘West Europe’
kind: ‘functionapp’
identity: {
type: ‘SystemAssigned’
}
properties: {
serverFarmId: hostingPlan.id
siteConfig: {
appSettings: [
{
name: ‘FUNCTIONS_EXTENSION_VERSION’
value: ‘~4’
}
{
name: ‘WEBSITE_NODE_DEFAULT_VERSION’
value: ‘~14’
}
{
name: ‘APPINSIGHTS_INSTRUMENTATIONKEY’
value: applicationInsights.properties.InstrumentationKey
}
{
name: ‘FUNCTIONS_WORKER_RUNTIME’
value: functionWorkerRuntime
}
]
ftpsState: ‘FtpsOnly’
minTlsVersion: ‘1.2’
}
httpsOnly: true
}
}
resource applicationInsights ‘Microsoft.Insights/components@2020-02-02’ = {
name: applicationInsightsName
location: appInsightsLocation
kind: ‘web’
properties: {
Application_Type: ‘web’
Request_Source: ‘rest’
}
}
{“code”:”DeploymentFailed”,”target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Resources/deployments/AzFuncs”,”message”:”At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.”,”details”:[{“target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Web/sites/saphir-webshop-order”,”message”:”There was a conflict. The remote name could not be resolved: ‘mtvpprlfzkau2azfunctions.file.core.windows.net'”}]}Here is my bicep file! @description(‘The name of the function app that you wish to create.’)
param appName string = ‘saphir-webshop-order’
@description(‘Storage Account type’)
@allowed([
‘Standard_LRS’
‘Standard_GRS’
‘Standard_RAGRS’
])
param storageAccountType string = ‘Standard_LRS’
@description(‘Location for all resources.’)
param location string = resourceGroup().location
@description(‘Location for Application Insights’)
param appInsightsLocation string
@description(‘The language worker runtime to load in the function app.’)
@allowed([
‘node’
‘dotnet’
‘java’
])
param runtime string = ‘dotnet’
var functionAppName = appName
var hostingPlanName = appName
var applicationInsightsName = appName
var storageAccountName = ‘${uniqueString(resourceGroup().id)}azfunctions’
var functionWorkerRuntime = runtime
resource storageAccount ‘Microsoft.Storage/storageAccounts@2022-05-01’ = {
name: ‘earthwebshopstorage’
location: location
sku: {
name: storageAccountType
}
kind: ‘Storage’
properties: {
supportsHttpsTrafficOnly: true
defaultToOAuthAuthentication: true
}
}
resource hostingPlan ‘Microsoft.Web/serverfarms@2021-03-01’ = {
name: hostingPlanName
location: location
sku: {
name: ‘Y1’
tier: ‘Dynamic’
}
properties: {}
}
resource functionApp ‘Microsoft.Web/sites@2023-12-01’ = {
name: appName
location: ‘West Europe’
kind: ‘functionapp’
identity: {
type: ‘SystemAssigned’
}
properties: {
serverFarmId: hostingPlan.id
siteConfig: {
appSettings: [
{
name: ‘FUNCTIONS_EXTENSION_VERSION’
value: ‘~4’
}
{
name: ‘WEBSITE_NODE_DEFAULT_VERSION’
value: ‘~14’
}
{
name: ‘APPINSIGHTS_INSTRUMENTATIONKEY’
value: applicationInsights.properties.InstrumentationKey
}
{
name: ‘FUNCTIONS_WORKER_RUNTIME’
value: functionWorkerRuntime
}
]
ftpsState: ‘FtpsOnly’
minTlsVersion: ‘1.2’
}
httpsOnly: true
}
}
resource applicationInsights ‘Microsoft.Insights/components@2020-02-02’ = {
name: applicationInsightsName
location: appInsightsLocation
kind: ‘web’
properties: {
Application_Type: ‘web’
Request_Source: ‘rest’
}
} Read More
Team Owners Can Rename the General Channel
In what seems to be a small change, team owners can rename general channels (naturally with ‘meaningful names.’ The change is more important than it seems because it’s associated with an effort to make users think about using channels as the basis for collaboration instead of always creating a new team. Being able to rename the General channel might make the channel more useful. After all, it’s just a regular channel.
https://office365itpros.com/2024/07/17/rename-general-channel/
In what seems to be a small change, team owners can rename general channels (naturally with ‘meaningful names.’ The change is more important than it seems because it’s associated with an effort to make users think about using channels as the basis for collaboration instead of always creating a new team. Being able to rename the General channel might make the channel more useful. After all, it’s just a regular channel.
https://office365itpros.com/2024/07/17/rename-general-channel/ Read More
SC-900 MCT material needed
Hello,
can someone please send me the MCT material for the SC-900 training?
Especially the PPTs?
This is my first request for this, so sorry, if I made a mistake!
Thank you
Arnd
Hello, can someone please send me the MCT material for the SC-900 training?Especially the PPTs? This is my first request for this, so sorry, if I made a mistake! Thank youArnd Read More
Secure Data Storage for WinUI application
UWP being a sandboxed application had a way to save data using PasswordVault/Credential Manager, but WinUI doesn’t offer the same level of security since other apps can access the data. DPAPI also doesn’t provide a good way to protect the data as any app running in the same User Context can unprotect it. Adding entropy helps, but where do I store the entropy? Can somebody help me understand the mechanism for storing data securely in Windows App SDK?
UWP being a sandboxed application had a way to save data using PasswordVault/Credential Manager, but WinUI doesn’t offer the same level of security since other apps can access the data. DPAPI also doesn’t provide a good way to protect the data as any app running in the same User Context can unprotect it. Adding entropy helps, but where do I store the entropy? Can somebody help me understand the mechanism for storing data securely in Windows App SDK? Read More
Unable to patch windows server 2022 getting error 0x80240438
Hello Team, I am getting below error whenever I am trying to update my windows server 2022.
I tried to patch it manually but getting below error. I tried all possible fix that I can try.
Searching for all applicable updates…
An error occurred:
Exception from HRESULT: 0x80240438
(Press ENTER to continue):
Hello Team, I am getting below error whenever I am trying to update my windows server 2022.I tried to patch it manually but getting below error. I tried all possible fix that I can try. Searching for all applicable updates…An error occurred:Exception from HRESULT: 0x80240438(Press ENTER to continue): Read More
Select first and last dates subject appears
Hello,
I want to select the first recorded start date and the final recorded end date of clients with multiple entries (they can move across various locations in our housing service) to calculate the total number of months they were housed. Most clients have a single entry but many have multiple entries.
I have looked at using the XLOOKUP and AND functions… Any ideas? See screenshot.
Hello,I want to select the first recorded start date and the final recorded end date of clients with multiple entries (they can move across various locations in our housing service) to calculate the total number of months they were housed. Most clients have a single entry but many have multiple entries.I have looked at using the XLOOKUP and AND functions… Any ideas? See screenshot. Read More
Stream classic videos has been deleted and unable to access them from Team SharePoint site.
One of our DevOps SharePoint sites has multiple videos which were in stream classic and now we are unable to access those videos without receiving any notification (no email to the site owner as well).
Please help us to retrieve these videos as those are essential part of our site and not available anywhere else.
Thanks in advance.
One of our DevOps SharePoint sites has multiple videos which were in stream classic and now we are unable to access those videos without receiving any notification (no email to the site owner as well).
Please help us to retrieve these videos as those are essential part of our site and not available anywhere else.
Thanks in advance.
Read More
3 Ways to Effortlessly Embed YouTube channel on Website & Supercharge your Website
The secret of having a good web presence is having exciting content, and what can be more interesting than having a YouTube channel integrated into your website?
Think about a dynamic stream of interesting videos representing your field, services, products, or the story behind the brand embedded in the website. A brand needs to know how to embed YouTube channel on website effectively for maximum results.
Let us examine the intricacies of this strategy and how it benefits a brand in terms of marketing and ultimately, sales.
How do you embed a YouTube channel on the website?
You now know how awesome it is to have a YouTube channel embedded on your website, but how do you begin doing it? Let’s look at different ways to do it.
1. Tagembed for Embedding YouTube Channel in Website:
Tagembed offers a seamless process for embedding YouTube channels.
Just follow these simple steps:
Create a free account: Click on the link provided and create an account with Tagembed for free.
Choose “Social Widget”: Choose the “Social Widget” option to create the YouTube channel feed.
Pick Your Channel: From the options provided, select “YouTube” and click “Channel” to display your whole channel.
Search or Enter URL: You can search for the name of your YouTube channel by typing it in the search bar or typing the URL of your YouTube channel into the URL field.
Customize and Generate Code: Tagembed provides layout, size, and color scheme preferences that may be adjusted to the user’s preference. Once you are satisfied with the appearance, click on the ‘generate’ button to get the code for the embed.
Copy & Paste: The created embed code must be copied and inserted into the website’s back end.
Save the changes, and bang! You have now integrated your YouTube channel on your website.
Tagembed helps you embed your YouTube channel as simply and conveniently as possible.
2. Manually Embedding YouTube Channel on Website:
For those comfortable with a bit of code, YouTube offers a manual embedding option:
Step 1: Choose Your Video: Choose the video you want to embed in your website.
Step 2: Click “Share.”: Look for the “Share” button under the chosen video.
Step 3: Copy the Embed Code: Then click “Embed” and copy the generated code.
Step 4: Paste & Display: Copy the code and place it on the website’s back end where you wish to display the video. Click save, and the chosen YouTube video will be shown on your website!
While this method is simple, it has limitations:
One video at a time: Manual embedding involves using “embed” code for each video at a time, which is tedious for entire channels.
Limited customization: You have less control over the video’s look and feel here than when using a social media aggregator tool.
3. Through Plugins:
While using a Content Management System (CMS) like WordPress or Shopify, you can leverage dedicated plugins for YouTube embedding. Several third-party plugins like Tagembed can also help you embed YouTube channels on your CMS website. Research and choose one that best suits your needs and platform.
No matter your technical expertise, there’s a solution to embed your YouTube channel on your website and unlock its potential to boost website engagement!
Benefits of Embedding a YouTube Channel on a Website
Embedding a YouTube Channel on your website makes your online platform lively. Here’s how this strategy can supercharge your website:
Attention Grabber: Videos tend to grab the audience’s attention more than simple text. When you integrate your YouTube channel, you give your visitors something to do and watch, and they stay on your website and click for more.Credibility Booster: Use videos to present your brand’s message, advertise your products, or feature your specialists. This will make people more aware of your brand and position you as an expert. Laser-Targeted Traffic: Include playlists or videos related to your website’s content, products, and services. This will spark visitors’ interest and direct them to other parts of your website, thus bringing traffic to the right areas.Conversion machine: When you embed YouTube channel on website, product demonstrations, explainer videos, and customer testimonials become practical conversion tools. Education and sales videos are highly effective in increasing conversion.SEO: Videos are preferred over text in search results. Enhancing a site’s SEO performance and getting organic traffic from people interested in the video content uploaded to the channel is possible.Community Catalyst: Encourage the audience to click on the “like” and “subscribe” buttons on your YouTube channel from your website. This creates a social feel and engagement, which is good for your relations with the audience.
Conclusion
By now, it is pretty evident that embedding a YouTube channel on your website is a stroke of genius with many benefits. From capturing people’s attention with exciting videos to amassing an involved community, YouTube is a titan, and thus, Tagembed emerges as your best bet in this YouTube embedding process.
It has a user-friendly interface, can be customized, and delivers current information. However, with Tagembed, you get more than just the simple embedding option. You can get helpful information about the audience and enhance your content.
Suppose you are interested in transforming your simple website into an eye-catching one. Visit Tagembed right now and learn how YouTube and Tagemebed can improve your business.
The secret of having a good web presence is having exciting content, and what can be more interesting than having a YouTube channel integrated into your website?Think about a dynamic stream of interesting videos representing your field, services, products, or the story behind the brand embedded in the website. A brand needs to know how to embed YouTube channel on website effectively for maximum results. Let us examine the intricacies of this strategy and how it benefits a brand in terms of marketing and ultimately, sales. How do you embed a YouTube channel on the website?You now know how awesome it is to have a YouTube channel embedded on your website, but how do you begin doing it? Let’s look at different ways to do it. 1. Tagembed for Embedding YouTube Channel in Website:Tagembed offers a seamless process for embedding YouTube channels. Just follow these simple steps: Create a free account: Click on the link provided and create an account with Tagembed for free.Choose “Social Widget”: Choose the “Social Widget” option to create the YouTube channel feed. Pick Your Channel: From the options provided, select “YouTube” and click “Channel” to display your whole channel.Search or Enter URL: You can search for the name of your YouTube channel by typing it in the search bar or typing the URL of your YouTube channel into the URL field.Customize and Generate Code: Tagembed provides layout, size, and color scheme preferences that may be adjusted to the user’s preference. Once you are satisfied with the appearance, click on the ‘generate’ button to get the code for the embed.Copy & Paste: The created embed code must be copied and inserted into the website’s back end. Save the changes, and bang! You have now integrated your YouTube channel on your website.Tagembed helps you embed your YouTube channel as simply and conveniently as possible.2. Manually Embedding YouTube Channel on Website:For those comfortable with a bit of code, YouTube offers a manual embedding option: Step 1: Choose Your Video: Choose the video you want to embed in your website.Step 2: Click “Share.”: Look for the “Share” button under the chosen video.Step 3: Copy the Embed Code: Then click “Embed” and copy the generated code.Step 4: Paste & Display: Copy the code and place it on the website’s back end where you wish to display the video. Click save, and the chosen YouTube video will be shown on your website!While this method is simple, it has limitations:One video at a time: Manual embedding involves using “embed” code for each video at a time, which is tedious for entire channels.Limited customization: You have less control over the video’s look and feel here than when using a social media aggregator tool.3. Through Plugins:While using a Content Management System (CMS) like WordPress or Shopify, you can leverage dedicated plugins for YouTube embedding. Several third-party plugins like Tagembed can also help you embed YouTube channels on your CMS website. Research and choose one that best suits your needs and platform. No matter your technical expertise, there’s a solution to embed your YouTube channel on your website and unlock its potential to boost website engagement! Benefits of Embedding a YouTube Channel on a WebsiteEmbedding a YouTube Channel on your website makes your online platform lively. Here’s how this strategy can supercharge your website:Attention Grabber: Videos tend to grab the audience’s attention more than simple text. When you integrate your YouTube channel, you give your visitors something to do and watch, and they stay on your website and click for more.Credibility Booster: Use videos to present your brand’s message, advertise your products, or feature your specialists. This will make people more aware of your brand and position you as an expert. Laser-Targeted Traffic: Include playlists or videos related to your website’s content, products, and services. This will spark visitors’ interest and direct them to other parts of your website, thus bringing traffic to the right areas.Conversion machine: When you embed YouTube channel on website, product demonstrations, explainer videos, and customer testimonials become practical conversion tools. Education and sales videos are highly effective in increasing conversion.SEO: Videos are preferred over text in search results. Enhancing a site’s SEO performance and getting organic traffic from people interested in the video content uploaded to the channel is possible.Community Catalyst: Encourage the audience to click on the “like” and “subscribe” buttons on your YouTube channel from your website. This creates a social feel and engagement, which is good for your relations with the audience.ConclusionBy now, it is pretty evident that embedding a YouTube channel on your website is a stroke of genius with many benefits. From capturing people’s attention with exciting videos to amassing an involved community, YouTube is a titan, and thus, Tagembed emerges as your best bet in this YouTube embedding process. It has a user-friendly interface, can be customized, and delivers current information. However, with Tagembed, you get more than just the simple embedding option. You can get helpful information about the audience and enhance your content.Suppose you are interested in transforming your simple website into an eye-catching one. Visit Tagembed right now and learn how YouTube and Tagemebed can improve your business. Read More
Windows 11 single app kiosk disabling Wifi and Scanner
Hello,
I have installed a tablet with embedded scanner in Windows 11 and single app kiosk mode.
The kiosk mode is correctly applied but when I shutdown the tablet and power it up again, the Scanner and the Wifi are disabled.
I can plug the tablet to the wired network and the network card is perfectly fine.
Before the shutdown, I can restart the tablet and still be connected to the Wifi or use the scanner.
If I deactivate the kiosk mode and reboot the tablet, I get Wifi and Scanner back.
Where and how can I specify that the Wifi and Scanner need to still run when in kiosk mode ?
Thank you for your help.
Matthieu De Bonnaires
Hello, I have installed a tablet with embedded scanner in Windows 11 and single app kiosk mode.The kiosk mode is correctly applied but when I shutdown the tablet and power it up again, the Scanner and the Wifi are disabled.I can plug the tablet to the wired network and the network card is perfectly fine.Before the shutdown, I can restart the tablet and still be connected to the Wifi or use the scanner.If I deactivate the kiosk mode and reboot the tablet, I get Wifi and Scanner back. Where and how can I specify that the Wifi and Scanner need to still run when in kiosk mode ? Thank you for your help. Matthieu De Bonnaires Read More
July 2024 – OneDrive Opening in Browser
Hello Everybody
OneDrive (Office365 Family) on user computers are opening in browser. Are anybody else experiencing this problem?
Hello Everybody OneDrive (Office365 Family) on user computers are opening in browser. Are anybody else experiencing this problem? Read More
Need help to burn dmg to USB for making Mac bootable USB drive?
I bought an used MacBook Pro from eBay and there is no OS on it. I need to make a bootable USB for macOS in order to reinstall macOS on it. Unfortunately, I don’t have a Mac for doing this, which could be an easy task.
I heard this could be done on a Windows PC as well by burning dmg to USB but don’t know how to make a bootable USB from macOS dmg file. Currently, I am using a Windows 11 laptop. Pls help!
I bought an used MacBook Pro from eBay and there is no OS on it. I need to make a bootable USB for macOS in order to reinstall macOS on it. Unfortunately, I don’t have a Mac for doing this, which could be an easy task. I heard this could be done on a Windows PC as well by burning dmg to USB but don’t know how to make a bootable USB from macOS dmg file. Currently, I am using a Windows 11 laptop. Pls help! Read More
COUNTIF not working with arguments defined by LET function
I have a data table with key index as XXX_ID (Data!$A:$A), including a list of XXX IDs for each data rows, and there are repetitive IDs in the column as data in other columns are different.
I need the median for the list of how many times each unique XXX ID shows up in XXX_ID column, so I wrote =LET(filter,FILTER(Data!$A:$A,filter criteria),unique,UNIQUE(filter),count_times,COUNTIF(filter,unique),MEDIAN(count_times))
However, the COUNTIF(filter,unique) part returns error!
I tested filter and unique parts in separate columns, and use COUNTIF in the third column as COUNTIF(filter result data list, unique result data list), I get a correct result data list showing how many times each unique XXX ID shows up in the filter result data list.
I changed COUNTIF(filter,unique) to DROP(FREQUENCY(filter,unique),-1)
This time it works! Not sure if it is a bug with COUNTIF.
I have a data table with key index as XXX_ID (Data!$A:$A), including a list of XXX IDs for each data rows, and there are repetitive IDs in the column as data in other columns are different.I need the median for the list of how many times each unique XXX ID shows up in XXX_ID column, so I wrote =LET(filter,FILTER(Data!$A:$A,filter criteria),unique,UNIQUE(filter),count_times,COUNTIF(filter,unique),MEDIAN(count_times))However, the COUNTIF(filter,unique) part returns error! I tested filter and unique parts in separate columns, and use COUNTIF in the third column as COUNTIF(filter result data list, unique result data list), I get a correct result data list showing how many times each unique XXX ID shows up in the filter result data list. I changed COUNTIF(filter,unique) to DROP(FREQUENCY(filter,unique),-1)This time it works! Not sure if it is a bug with COUNTIF. Read More
“Failed to mount the Azure file share” looks like a false alarm?
Hi,
I have been using Azure and the Azure shell (Bash) on the Azure portal for nearly half a year.
Yesterday when I started the Azure shell, I got this warning message:
Warning: Failed to mount the Azure file share. Your cloud drive won’t be available.
Your Cloud Shell session will be ephemeral so no files or system changes will persist beyond your current session.
As far as I know, I never unmounted or changed any permission of the storage account to the clouddrive folder.
However, I found that my cloud drive (mounted to the clouddrive/ folder) was still accessible, and the files I created there could still be found when I started another Cloud Shell session.
I tried to reset my user settings and remount the same storage account to the clouddrive/ folder, and restarted the Bash Cloud Shell again. The warning message still appeared while the clouddrive/ could still be accessible.
So I wonder if the warning message was a false alarm, or if it referred to something else. May I ask if there is any command I can run to display the mounting log that resulted in the warning message, so I can check if it is really a false alarm?
Best Regards,
Benny (@evergrn_tree).
Hi, I have been using Azure and the Azure shell (Bash) on the Azure portal for nearly half a year. Yesterday when I started the Azure shell, I got this warning message: Warning: Failed to mount the Azure file share. Your cloud drive won’t be available.
Your Cloud Shell session will be ephemeral so no files or system changes will persist beyond your current session. As far as I know, I never unmounted or changed any permission of the storage account to the clouddrive folder. However, I found that my cloud drive (mounted to the clouddrive/ folder) was still accessible, and the files I created there could still be found when I started another Cloud Shell session. I tried to reset my user settings and remount the same storage account to the clouddrive/ folder, and restarted the Bash Cloud Shell again. The warning message still appeared while the clouddrive/ could still be accessible. So I wonder if the warning message was a false alarm, or if it referred to something else. May I ask if there is any command I can run to display the mounting log that resulted in the warning message, so I can check if it is really a false alarm? Best Regards,Benny (@evergrn_tree). Read More
windows 11 non-admin user IIS Pool access issue in local machine
By creating a non-admin user in Windows 11 home edition, I allowed him full control over inetsrv
%SystemRoot%System32inetsrv
folder, after logging in with this user and running this command from CMD
%SystemRoot%System32inetsrvappcmd list apppool /name:poolname/text:state
Results show : Unknown. But “poolname” is a pool running.
%SystemRoot%System32inetsrvappcmd start apppool /apppool.name:poolname
The result shows : “ERROR ( message:The WAS service is not available – try starting the service first. )”. But a “WAS” is running.
By creating a non-admin user in Windows 11 home edition, I allowed him full control over inetsrv %SystemRoot%System32inetsrvfolder, after logging in with this user and running this command from CMD%SystemRoot%System32inetsrvappcmd list apppool /name:poolname/text:stateResults show : Unknown. But “poolname” is a pool running.%SystemRoot%System32inetsrvappcmd start apppool /apppool.name:poolnameThe result shows : “ERROR ( message:The WAS service is not available – try starting the service first. )”. But a “WAS” is running. Read More
Microsoft Team Calendar wont let me book meetings
I have had a mare of a day, trying to sort out teams calendar. I have had no issued making appointments until yesterday, now it is saying ‘something went wrong’ unable to create meeting? Any help appreciated, I cannot work if it is not working
Thanks
I have had a mare of a day, trying to sort out teams calendar. I have had no issued making appointments until yesterday, now it is saying ‘something went wrong’ unable to create meeting? Any help appreciated, I cannot work if it is not working Thanks Read More