Category: Microsoft
Category Archives: Microsoft
Can DHCP Server detect client windows version?
I have a DHCP server and several clients, some running Windows 10 and some Windows 7. I want the DHCP server to be able to identify the Windows version of the clients using the vendor class and assign the settings I’ve specified accordingly. Also, I don’t want to configure anything on the clients; I want the DHCP server to be able to detect the Windows version by itself. Is there a way to do this?
I have a DHCP server and several clients, some running Windows 10 and some Windows 7. I want the DHCP server to be able to identify the Windows version of the clients using the vendor class and assign the settings I’ve specified accordingly. Also, I don’t want to configure anything on the clients; I want the DHCP server to be able to detect the Windows version by itself. Is there a way to do this? Read More
How to access Bigpond account outlook
I am away from home- Australia and have not been able to access my bigpond email account. Can anyone help? Does outlook not allow bigpond accounts any more?
I am away from home- Australia and have not been able to access my bigpond email account. Can anyone help? Does outlook not allow bigpond accounts any more? Read More
Text.Remove a specific word in Power Query
Am I able to use Text.Remove in power Query to remove specific words from a column such as “BLACK” :WHITE” “RED”. if so what is the formula? I have been trying with a custom column and the using Text.Remove and Text.Select
Thank you Eqa
Am I able to use Text.Remove in power Query to remove specific words from a column such as “BLACK” :WHITE” “RED”. if so what is the formula? I have been trying with a custom column and the using Text.Remove and Text.Select Thank you Eqa Read More
Unable to delete outlook from my machine (using windows11 home version 23H2).
Hi, I am unable to delete outlook from my startup/laptop (using windows11 home version 23H2).
when I go into installed apps, there is no outlook as you can see here…
it shows up on my startup and when I click on it, it actually opens outlook… Please help
Thanks
Hi, I am unable to delete outlook from my startup/laptop (using windows11 home version 23H2). when I go into installed apps, there is no outlook as you can see here… it shows up on my startup and when I click on it, it actually opens outlook… Please help Thanks Read More
Windows 10 Updates resetting local ethernet
Hi Microsoft Tech Team,
Riddle me this – why o why do your updates reset all my Ethernet settings??? I mean seriously?
Every time there is an update it scrambles my Ethernet and I can spend up to a week meticulously checking every conceivable setting (mainly power management) in the deep dark catacombs of Windows to get a stable connection. It’s infuriating!!
I’ve just come home from an overseas trip, Windows Update required, now my Ethernet is cycling connect-disconnect every 10 second…. I mean why? It was perfectly stable before the update?
Are you hiring monkeys for the Dev Team now?
Hi Microsoft Tech Team, Riddle me this – why o why do your updates reset all my Ethernet settings??? I mean seriously? Every time there is an update it scrambles my Ethernet and I can spend up to a week meticulously checking every conceivable setting (mainly power management) in the deep dark catacombs of Windows to get a stable connection. It’s infuriating!! I’ve just come home from an overseas trip, Windows Update required, now my Ethernet is cycling connect-disconnect every 10 second…. I mean why? It was perfectly stable before the update? Are you hiring monkeys for the Dev Team now? Read More
Create an IFOR formula
I am trying to create a formula to find any fields that are greater than $1,000, if true, then 0, if false, then $5.00. Below are the fields I created and the formula I am trying to use.
=IF(OR(A1>1000,B1>1000,C1>1000,D1>1000,E1>1000,F1>1000,G1>1000), 0,H2)
I am trying to create a formula to find any fields that are greater than $1,000, if true, then 0, if false, then $5.00. Below are the fields I created and the formula I am trying to use. =IF(OR(A1>1000,B1>1000,C1>1000,D1>1000,E1>1000,F1>1000,G1>1000), 0,H2) Read More
A columns’ data under custom sort but still report to subsequent sheets
Hi Everyone,
This is the leaderboard in our sales office at work. In every Sheet (Month), column BP shows each salesman’s total sales for the month in green. It is custom filtered to order the salesmen from most sales to the least in descending order. Resulting in column BP constantly rearranging; so I am struggling to make the final totals in column BP report on the following months column B titled “Last Month” with the correct corresponding salesman. Does anyone know how I can make each sheets column BP report to column B on the following sheet although they sort every day?
Thank you for your time.
Hi Everyone, This is the leaderboard in our sales office at work. In every Sheet (Month), column BP shows each salesman’s total sales for the month in green. It is custom filtered to order the salesmen from most sales to the least in descending order. Resulting in column BP constantly rearranging; so I am struggling to make the final totals in column BP report on the following months column B titled “Last Month” with the correct corresponding salesman. Does anyone know how I can make each sheets column BP report to column B on the following sheet although they sort every day? Thank you for your time. Read More
Defender API – querying IndentityInfo in Advanced Hunting
Hi,
Is any of you having issues with Defender API in Python when running advanced hunting queries that involve the IdentityInfo table?
When i run anything that involves IdentityInfo, i get error 400: bad request. However, if i remove the IdentityInfo from the query, it simply works.
Hi, Is any of you having issues with Defender API in Python when running advanced hunting queries that involve the IdentityInfo table?When i run anything that involves IdentityInfo, i get error 400: bad request. However, if i remove the IdentityInfo from the query, it simply works. Read More
“Repair your computer” from media creation tool doesn’t start
I’ve been having an issue with starting my windows today, as a result of the “reboot and select proper boot device today” error, to which I have already tried rearranging boot disk order in bios, not working. If anyone knows a way to fix that, that would be great, but that is not the relevant problem here. I’m trying to back up my C drive so I can fix a (presumably) corrupted windows booter, and I’ve used the media creation tool to put a windows installation on a USB drive, however when it starts and I try clicking on the “repair your computer” button, it just goes to a blue screen and does nothing. I’ve waited on this for around an hour and tried multiple times again, but it is still the same and never goes to the windows recovery environment as shown in this video.
I’ve been having an issue with starting my windows today, as a result of the “reboot and select proper boot device today” error, to which I have already tried rearranging boot disk order in bios, not working. If anyone knows a way to fix that, that would be great, but that is not the relevant problem here. I’m trying to back up my C drive so I can fix a (presumably) corrupted windows booter, and I’ve used the media creation tool to put a windows installation on a USB drive, however when it starts and I try clicking on the “repair your computer” button, it just goes to a blue screen and does nothing. I’ve waited on this for around an hour and tried multiple times again, but it is still the same and never goes to the windows recovery environment as shown in this video. Read More
Connect to a Linux VM using Bastion and Key Vault without a private key file
In enterprise environments, requirements often demand the use of private networks, resulting in VMs not being assigned Public IP addresses. In such cases, Azure Bastion offers an extremely useful feature for accessing these VMs without complexity. When logging into Linux VMs on Azure via Azure Bastion using an SSH Private Key, the key is often managed as a local file. Managing SSH Private Key files on individual devices poses risks such as potential key leakage. Therefore, centralized management, including proper role assignment, is preferable from a security standpoint. A common need in such scenarios is to manage SSH Private Keys using Key Vault. This article provides such a comprehensive step-by-step guide.
There are two huge benefits here.
SSH Private Key is no longer required to store as a local file Local file by storing it in Azure Key Vault.
Access to Linux VM can be be controlled using RBAC assignment for Azure Key Vault.
Regarding the first point, storing the SSH Private Key locally after creating it through the Azure Portal can be issues such as loss the file or difficulty in identifying which VM it is for. Additionally, it has the benefit of reducing the risk of file leakage if a developer leaves the company or the project.
Regarding the second point, using Key Vault for access management allows you to control VM access through Key Vault. You can manage access control to specific VMs.
Here is the architecture diagram for the current setup. When creating a Linux VM, the SSH Private Key generated through the Azure portal is registered in Key Vault. This SSH Private Key is then used to access the Linux VM via Azure Bastion.
Prerequisites
Before following this article, you have to create Azure resources as follows:
Virtual Network
Key Vault
Azure Bastion
Setup
First, we create a new SSH Key when creating the Linux VM through the Azure portal. While it is possible to create an SSH Private Key when creating a Linux VM through the Azure portal, you can also create it separately. Once you input the parameters and create the Linux VM, you can download the SSH Private Key and save it as a local file.
If you choose to create the SSH Private Key separately, note that you need to select “Reset password” from the VM menu on Azure Portal and use “Add SSH public key” to set the SSH Key information for the Linux VM. The first link in the References section contains relevant information.
Next, you have to acquire proper RBAC role to manage Azure Key Vault. It’s not enough just having subscription Owner role. In this article, we assign Key Vault Administrator role.
We can use Key Vault Secrets Officer role for developers who access your Linux VM. Please refer to the article as follows to assign proper RBA roles.
Provide access to Key Vault keys, certificates, and secrets with an Azure role-based access control
Then, we register the SSH Private Key in the secrets of Azure Key Vault (you cannot select Keys or Certificates with Azure Bastion). There is a tip here that the SSH Private Key contains a multi-line file, but the Key Vault portal does not support the registration of multi-line strings. Therefore, we have to execute this via command line as follows:
az keyvault secret set –name “your-secret-name” –vault-name “your-key-name” –file “my-ssh-private-key.pem”
If the command works well, you can find your SSH Private Key on the Azure Key Vault.
Then, we can access the Linux VM via Azure Bastion. Select the Linux VM, choose “SSH Private Key from Azure Key Vault” from the Authentication Type options, and use the the SSH Private Key you have registered.
Error #1: Register SSH Private Key without RBAC role assignment
You got error as follows if you do not have proper RBAC. I have assigned Key Vault Administrator role to the operator to solve this issue.
Error #2: Access Linux VM without RBAC role assignment
You got error as follows if you do not have proper RBAC. I have assigned Key Vault Secrets Officer role to the operator to solve this issue.
References
ssl – How to use a certificate from a Azure Key Vault to connect to a Azure Virtual Machine through Bastion? – Stack Overflow
az keyvault secret | Microsoft Learn
az sshkey | Microsoft Learn
Connect to a Linux VM using SSH – Azure Bastion | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Support for Com4 ManagedInProcessServer and others
Com servers may generally be written in managed or unmanaged code. The COM4 schema extensions include elements such as com4:ManagedInProcessServer which allows for the specification of a COM Clsid that is implemented in managed code.
Unfortunately, the foundation manifest was not extended to include these new categories when performing the uniqueness test to ensure that when other element references a CLSID that the ID is defined once and only once in the document. This was done when COM2 was added to the schema set but seems to have been missed here.
These are the lines from the latest SDK version of the FoundationManifestSchema.xsd (starting on line 134) which appear problematic to me:
<xs:unique name=”Class_Id”>
<xs:selector xpath=”f:Applications/f:Application/f:Extensions/com:Extension/com:ComServer/com:ExeServer/com:Class | f:Applications/f:Application/f:Extensions/com:Extension/com:ComServer/com:SurrogateServer/com:Class | f:Applications/f:Application/f:Extensions/com:Extension/com:ComServer/com:TreatAsClass | f:Applications/f:Application/f:Extensions/com:Extension/com:ComInterface/com:ProxyStub | f:Extensions/com:Extension/com:ComInterface/com:ProxyStub | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComServer/com:ExeServer/com:Class | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComServer/com:SurrogateServer/com:Class | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComServer/com:TreatAsClass | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComInterface/com:ProxyStub | f:Extensions/com2:Extension/com2:ComInterface/com:ProxyStub”/>
<xs:field xpath=”@Id”/>
</xs:unique>
This means that while we are able to add the ManagedInProcessServer element to define the com server component (as either a PackageExtension or ApplicationExtension as needed), we cannot reference the Clsid in any other element that would need it, such as a ShellExtension.
Fixing the above in the Foundation (and updating all tooling that verifying the schemas) will be necessary in order to build and package up more modern COM components.
Tagging @Fizza for visibility.
Com servers may generally be written in managed or unmanaged code. The COM4 schema extensions include elements such as com4:ManagedInProcessServer which allows for the specification of a COM Clsid that is implemented in managed code.
Unfortunately, the foundation manifest was not extended to include these new categories when performing the uniqueness test to ensure that when other element references a CLSID that the ID is defined once and only once in the document. This was done when COM2 was added to the schema set but seems to have been missed here.
These are the lines from the latest SDK version of the FoundationManifestSchema.xsd (starting on line 134) which appear problematic to me:
<xs:unique name=”Class_Id”><xs:selector xpath=”f:Applications/f:Application/f:Extensions/com:Extension/com:ComServer/com:ExeServer/com:Class | f:Applications/f:Application/f:Extensions/com:Extension/com:ComServer/com:SurrogateServer/com:Class | f:Applications/f:Application/f:Extensions/com:Extension/com:ComServer/com:TreatAsClass | f:Applications/f:Application/f:Extensions/com:Extension/com:ComInterface/com:ProxyStub | f:Extensions/com:Extension/com:ComInterface/com:ProxyStub | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComServer/com:ExeServer/com:Class | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComServer/com:SurrogateServer/com:Class | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComServer/com:TreatAsClass | f:Applications/f:Application/f:Extensions/com2:Extension/com2:ComInterface/com:ProxyStub | f:Extensions/com2:Extension/com2:ComInterface/com:ProxyStub”/><xs:field xpath=”@Id”/></xs:unique>
This means that while we are able to add the ManagedInProcessServer element to define the com server component (as either a PackageExtension or ApplicationExtension as needed), we cannot reference the Clsid in any other element that would need it, such as a ShellExtension.
Fixing the above in the Foundation (and updating all tooling that verifying the schemas) will be necessary in order to build and package up more modern COM components.
Tagging @Fizza for visibility. Read More
Schedule View By Event
I have a given excel schedule, similar to the “Input” table shown in the attachment. I have a need to organize this table by event and show participants in individual columns. I have this table shown as “Desired Output” in the attachment I also have Power BI available to me, if that provides an easier solution.
Any and all help would be greatly appreciated, thank you.
I have a given excel schedule, similar to the “Input” table shown in the attachment. I have a need to organize this table by event and show participants in individual columns. I have this table shown as “Desired Output” in the attachment I also have Power BI available to me, if that provides an easier solution. Any and all help would be greatly appreciated, thank you. Sheet Read More
Hotmail is conflicting with OneDrive through my Microsoft 365 account
I’ve been struggling for about one month, thus far, with my OneDrive through my Microsoft 365 account. Suddenly, my 40-year-old Hotmail account is frozen, and I cannot send, nor receive email because, the system indicates, my OneDrive is full. When I click on that, to be led to my OneDrive, it shows that I have used less than 0.2 GB from the 15 GB allocated space. In the meantime, I cannot use my Hotmail, where I have deleted about 10 GB of files. This has not helped me, and I cannot reach someone from Microsoft for assistance. Does anyone have any clue about how to resolve this mystery?
I’ve been struggling for about one month, thus far, with my OneDrive through my Microsoft 365 account. Suddenly, my 40-year-old Hotmail account is frozen, and I cannot send, nor receive email because, the system indicates, my OneDrive is full. When I click on that, to be led to my OneDrive, it shows that I have used less than 0.2 GB from the 15 GB allocated space. In the meantime, I cannot use my Hotmail, where I have deleted about 10 GB of files. This has not helped me, and I cannot reach someone from Microsoft for assistance. Does anyone have any clue about how to resolve this mystery? Read More
Issue with WSL Installation on Windows 11 Insider Program 24H2
I am encountering an issue while trying to install WSL on my Windows 11 Insider Program 24H2. The installation process fails with the following error message:
“`
Installing, this may take a few minutes…
WslRegisterDistribution failed with error: 0x80070003
Error: 0x80070003 The system cannot find the path specified.
Press any key to continue…
“`
This problem started after I accidentally deleted the WSL folder from the Program Files directory. Since then, I have been unable to install WSL (Ubuntu) on my system.
Could someone please guide me on how to resolve this issue?
Thank you in advance for your help!
I am encountering an issue while trying to install WSL on my Windows 11 Insider Program 24H2. The installation process fails with the following error message:“`Installing, this may take a few minutes…WslRegisterDistribution failed with error: 0x80070003Error: 0x80070003 The system cannot find the path specified.Press any key to continue…“`This problem started after I accidentally deleted the WSL folder from the Program Files directory. Since then, I have been unable to install WSL (Ubuntu) on my system.Could someone please guide me on how to resolve this issue?Thank you in advance for your help! Read More
Mixed Exchange Server ECP portal not accessible
We have 4 servers, 2 exchange 2013 servers and 2 exchange 2016 servers, if all the servers are on ECP porta is accessible, but if we turn off 2 exchange 2013 servers, then ECP portal is not accessible, checked all the internal & External URL’s for ECP and OWA, checked the bindings, checked, SPN’s, checked DNS and all the configurations are Good, nothing we are able to get from Event logs also
Can anyone help on this… we want to get rid of exchange 2013 and run with exchange 2016 servers
We have 4 servers, 2 exchange 2013 servers and 2 exchange 2016 servers, if all the servers are on ECP porta is accessible, but if we turn off 2 exchange 2013 servers, then ECP portal is not accessible, checked all the internal & External URL’s for ECP and OWA, checked the bindings, checked, SPN’s, checked DNS and all the configurations are Good, nothing we are able to get from Event logs also Can anyone help on this… we want to get rid of exchange 2013 and run with exchange 2016 servers Read More
Windows 11 Can’t Log In and Won’t Let Me Set Pin
Hi all,
Just updated today to Windows 11. Upon my computer restarting, I got a ‘sign in’ button beneath my account instead of a box to enter my pin. When I sign in, it takes me to Microsoft account sign in and says “That Microsoft account doesn’t exist”. Before updating my PC, I changed the account associated with my Microsoft account to an Outlook one from the Gmail one I had been using, which is what comes up when I initially go to log in.
I go through the sign in process with my new email and it takes me to the Create a Pin screen. I click next and it says “Something went wrong. We weren’t able to set up your PIN.” It gives me the option to retry, which just takes me back to the “Something went wrong.”, or “Skip for now”, which takes me back to my computer’s lock screen and makes me go through the whole process again.
What can I do to get back into my computer? I’m not reliant on it for work, but I do have important files and some games installed on there.
Thanks in advance.
Hi all, Just updated today to Windows 11. Upon my computer restarting, I got a ‘sign in’ button beneath my account instead of a box to enter my pin. When I sign in, it takes me to Microsoft account sign in and says “That Microsoft account doesn’t exist”. Before updating my PC, I changed the account associated with my Microsoft account to an Outlook one from the Gmail one I had been using, which is what comes up when I initially go to log in. I go through the sign in process with my new email and it takes me to the Create a Pin screen. I click next and it says “Something went wrong. We weren’t able to set up your PIN.” It gives me the option to retry, which just takes me back to the “Something went wrong.”, or “Skip for now”, which takes me back to my computer’s lock screen and makes me go through the whole process again. What can I do to get back into my computer? I’m not reliant on it for work, but I do have important files and some games installed on there. Thanks in advance. Read More
Unraveling the future of POP3 on Outlook email accounts
Does 365 allow POP3 email?
For email, I use the Outlook 2016 desktop client with POP3. This client software reportedly ends in about 15 months. Is there any way I could stay with both POP3 and Outlook email after next year, other than by using third party clients like Thunderbird or Em-Client? Is it correct that 365 Outlook does not, or soon will not, support POP3 for Outlook email? [I assume outgoing Windows Mail and now Outlook for Windows excludes POP3.]
Does 365 allow POP3 email?For email, I use the Outlook 2016 desktop client with POP3. This client software reportedly ends in about 15 months. Is there any way I could stay with both POP3 and Outlook email after next year, other than by using third party clients like Thunderbird or Em-Client? Is it correct that 365 Outlook does not, or soon will not, support POP3 for Outlook email? [I assume outgoing Windows Mail and now Outlook for Windows excludes POP3.] Read More
Seeking Tables help
Looking for help on tables. I have a long list (140+) of names. I’m trying to set up to have 2 columns of limited rows, (so it shows at 2 tables on a printed page) but want to have it so that if I add a name in the middle of a data set, it’ll move everything below it down 1, and across other tables.
Example, when I go to print, Column 1 on page 1 has names A-C, column 2 has D-F. column 1 on page 3 has g-p. If I need to add a name in A-C, it’ll push the list down one, going into D-F and G-P, etc.
I hope that sort of explains what I’m looking for…
Looking for help on tables. I have a long list (140+) of names. I’m trying to set up to have 2 columns of limited rows, (so it shows at 2 tables on a printed page) but want to have it so that if I add a name in the middle of a data set, it’ll move everything below it down 1, and across other tables.Example, when I go to print, Column 1 on page 1 has names A-C, column 2 has D-F. column 1 on page 3 has g-p. If I need to add a name in A-C, it’ll push the list down one, going into D-F and G-P, etc.I hope that sort of explains what I’m looking for… Read More
My Windows Security stucked on Black Screen
I cant use Windows Security because everytime i open its just a black screen and after i do something, new window just pop up
I searched all over internet for fix, i found some “fixes” that dont work, i used commands, reseting, repairing and also used “SecurityHealthSetup.exe” that was on other blog with this exact problem used as fix, but it did nothing to me
I cant use Windows Security because everytime i open its just a black screen and after i do something, new window just pop upI searched all over internet for fix, i found some “fixes” that dont work, i used commands, reseting, repairing and also used “SecurityHealthSetup.exe” that was on other blog with this exact problem used as fix, but it did nothing to me Read More