Tag Archives: microsoft
How to get Free vouchers for az-400
Anyone help me how to get the vouchers for writing the az-400 certification exam !!!
Anyone help me how to get the vouchers for writing the az-400 certification exam !!! Read More
Array Filter not working as expected
This flow works with one glitch. If there were two schools with the same date (which is probable) then, the violations for each school are being included in the email for both schools.
Here is the code for my filter:
{
“type”: “Query”,
“inputs”: {
“from”: “@outputs(‘Get_items_-_All_Violations_from_30_days_ago’)?[‘body/value’]”,
“where”: “@equals(items(‘Apply_to_each_-_for_each_”Get_Item”‘)?[‘School’],variables(‘Unique School’))”
},
“runAfter”: {
“Set_variable_-_Unique_School”: [
“Succeeded”
]
},
“metadata”: {
“operationMetadataId”: “86fb4366-e227-42eb-bf2b-07d9219c316d”
}
}
The string variable at the point where the filter is occurring has only one school in the string and I’ve been able to confirm things on the data side. The data is good.
Thanks for any help that can be offered.
This flow works with one glitch. If there were two schools with the same date (which is probable) then, the violations for each school are being included in the email for both schools. Here is the code for my filter: {
“type”: “Query”,
“inputs”: {
“from”: “@outputs(‘Get_items_-_All_Violations_from_30_days_ago’)?[‘body/value’]”,
“where”: “@equals(items(‘Apply_to_each_-_for_each_”Get_Item”‘)?[‘School’],variables(‘Unique School’))”
},
“runAfter”: {
“Set_variable_-_Unique_School”: [
“Succeeded”
]
},
“metadata”: {
“operationMetadataId”: “86fb4366-e227-42eb-bf2b-07d9219c316d”
}
} The string variable at the point where the filter is occurring has only one school in the string and I’ve been able to confirm things on the data side. The data is good. Thanks for any help that can be offered. Read More
Billing Account Type can only be ‘US Exempt’?
This relates to: https://partner.microsoft.com/en-us/dashboard/account/v3/accountsettings/billingprofile
Been a partner for years. Now I apparently must create a Billing Account (and Profile). When I attempt to create a new ‘Billing Account’ most of the information is correctly populated with my company’s information. However, when I enter the firm’s EIN (TAX ID) then I see under it that ‘Type’ only has the option ‘US Exempt’. My company is not tax exempt.
How do I create a correct ‘billing account’ for my LLC?
This relates to: https://partner.microsoft.com/en-us/dashboard/account/v3/accountsettings/billingprofileBeen a partner for years. Now I apparently must create a Billing Account (and Profile). When I attempt to create a new ‘Billing Account’ most of the information is correctly populated with my company’s information. However, when I enter the firm’s EIN (TAX ID) then I see under it that ‘Type’ only has the option ‘US Exempt’. My company is not tax exempt. How do I create a correct ‘billing account’ for my LLC? Read More
Formula based on a combination of two other cells where the combination varies
Hello forum friends
I need a formula that will look at two other cells and depending on the combination in those cells populate the third cell. For example:
If A1 says Critical and B1 says High then C1 will = Priority 1.
For example, the combinations will be as follows:
A1B1C1 (cell with the formula)CriticalHighPriority 1Critical MediumPriority 2Critical LowPriority 3Urgent High Priority 1Urgent MediumPriority 2Urgent LowPriority 3RoutineHighPriority 2Routine MediumPriority 3Routine LowPriority 4
Thanks in advance for your help!
Hello forum friends I need a formula that will look at two other cells and depending on the combination in those cells populate the third cell. For example: If A1 says Critical and B1 says High then C1 will = Priority 1.For example, the combinations will be as follows:A1B1C1 (cell with the formula)CriticalHighPriority 1Critical MediumPriority 2Critical LowPriority 3Urgent High Priority 1Urgent MediumPriority 2Urgent LowPriority 3RoutineHighPriority 2Routine MediumPriority 3Routine LowPriority 4 Thanks in advance for your help! Read More
Flormatting a Table including columns, rows
Dear MS Word Communiy Specialist:
I would like to create a Table with a row consisting of 8 columns of varying widths. I would like to do so from a source Word docx doc into a destination docx doc and trying to maintain the souce Table’s column width properties and set each indiv. column cell to leave the max space avail forr text and min. space set for margins?
David C.
Dear MS Word Communiy Specialist: I would like to create a Table with a row consisting of 8 columns of varying widths. I would like to do so from a source Word docx doc into a destination docx doc and trying to maintain the souce Table’s column width properties and set each indiv. column cell to leave the max space avail forr text and min. space set for margins? David C. Read More
passcode expiry on personal devices
My work has enabled enforcement of minimum password security requirements for personal mobile devices accessing work email.
Unfortunately, this imposes a requirement to frequently change the device pin code which is annoying everyone.
Our IT admin wants to remove this requirement while still enforcing a minimum requirement that devices must have a pin code but doesn’t know where to find the relevant setting in Azure AD. We don’t have any devices enrolled in Intune as that requires a P2 licence which we don’t have.
Any guidance that I could pass on would be appreciated.
My work has enabled enforcement of minimum password security requirements for personal mobile devices accessing work email.Unfortunately, this imposes a requirement to frequently change the device pin code which is annoying everyone.Our IT admin wants to remove this requirement while still enforcing a minimum requirement that devices must have a pin code but doesn’t know where to find the relevant setting in Azure AD. We don’t have any devices enrolled in Intune as that requires a P2 licence which we don’t have.Any guidance that I could pass on would be appreciated. Read More
C: Users Documents folder empty
Greetings,
I have encountered an unexpected issue and require assistance in resolving it.
Upon exploring my User folder located on the desktop (accessed through Desktop Icons), I noticed that the Documents folder contains various items.
Interestingly, when I navigate to the Documents folder using Quick Actions in a file explorer window, I also find items stored within.
However, when I access This PC > C: > Users > MyUsername > Documents through a file explorer window, the folder appears to be empty.
Could you kindly provide guidance on how to address this discrepancy?
Greetings, I have encountered an unexpected issue and require assistance in resolving it. Upon exploring my User folder located on the desktop (accessed through Desktop Icons), I noticed that the Documents folder contains various items.Interestingly, when I navigate to the Documents folder using Quick Actions in a file explorer window, I also find items stored within.However, when I access This PC > C: > Users > MyUsername > Documents through a file explorer window, the folder appears to be empty. Could you kindly provide guidance on how to address this discrepancy? Read More
New Recovery Tool to help with CrowdStrike issue impacting Windows endpoints
As a follow-up to the CrowdStrike Falcon agent issue impacting Windows clients and servers, we have released a USB tool to help IT Admins expedite the repair process. The signed Microsoft Recovery Tool can be found in the Microsoft Download Center: https://go.microsoft.com/fwlink/?linkid=2280386. The steps to use the tool are detailed below.
Prerequisites
A Windows 64-bit client with at least 8GB of free space from which the tool can be run to create the bootable USB drive.
Administrative privileges on the Windows client from prerequisite #1.
USB drive with (1GB). All existing data on this USB will be wiped.
BitLocker recovery key for each BitLocker-enabled impacted device on which the generated USB device will be used.
Instructions
To generate the USB repair solution, from the 64-bit Windows client in prerequisite #1 above, execute the following steps:
Download the signed Microsoft Recovery Tool from the Microsoft Download Center.
Extract the PowerShell script from the downloaded solution.
Run MsftRecoveryToolForCS.ps1 from an elevated PowerShell prompt.
ADK download and install will start, may take several minutes to complete.
You will be prompted to optionally select a driver directory for image import. We recommend you select “N” to skip this step. Some devices may need specific keyboard and/or mass storage drivers, however “N” is sufficient for most devices. NOTE: The tool will import any SYS and INI recursively under the specified directory.
Insert the USB drive when prompted and provide the drive letter.
Once the USB creation is complete, remove the USB from the Windows client.
To repair an impacted device using the BitLocker recovery key from prerequisite #4 above:
Insert the USB key into an impacted device.
Reboot the device.
During restart, press F12 (or follow manufacturer-specific instructions for booting to BIOS).
From the BIOS boot menu, choose Boot from USB and continue.
The tool will run.
If BitLocker is enabled, the user will be prompted for the BitLocker recovery key. Include the dashes in for the BitLocker recovery key when entering. The recovery key options are provided here.
The tool will run the issue-remediation scripts as recommended by CrowdStrike.
Once complete, reboot the device normally.
For more information on the issue impacting Windows clients and servers running the CrowdStrike Falcon agent, please see:
A wide variety of Windows information is available at aka.ms/WRH
Recovery steps are available here
For Windows Virtual Machines running on Azure follow the mitigation steps in Azure status
Additional details from CrowdStrike are available here: Statement on Falcon Content Update for Windows Hosts – CrowdStrike Blog
Please note this tool does not use Microsoft Intune, but we’re sharing as a Support tip to help customers. Let us know if you have any questions by replying to this post or reaching out to @IntuneSuppTeam on X. We’ll continue to provide updates to this post as needed.
Microsoft Tech Community – Latest Blogs –Read More
Unable to directly reply to an email
When I write a Reply to an email and Send the reply, the message goes into Drafts and does not send. I can open Drafts and select the reply, but it still will not send.
There is no problem sending a new email message. Only a Reply message will not send.
When I write a Reply to an email and Send the reply, the message goes into Drafts and does not send. I can open Drafts and select the reply, but it still will not send. There is no problem sending a new email message. Only a Reply message will not send. Read More
Help with excel formulas
Good evening,
I am trying to create a holiday tracker to track my colleagues holiday allowance.
So my plan is the following.
Cell A1 hours Used
Cell B1 hours remaining
Cell C1 Annual holiday Allowance
So now let say the holiday allowance is 265. John Smith booked 10 hours so that 10 hours will be deducted from the 265 which would be 255. This part is easy enough just by doing
=SUM(A1-C1)
But the problem I have got is if John Smith booked a 5-hour holiday a few weeks later, and you updated the cell “Hours Used” from 10 hours to 5 hours, the total would be then 260. But realistically, it should be 250 instead due to previous holiday . So my question is how would I go about doing this. Any help or advice would be highly appreciated.
Thank you
Good evening,I am trying to create a holiday tracker to track my colleagues holiday allowance.So my plan is the following.Cell A1 hours UsedCell B1 hours remainingCell C1 Annual holiday AllowanceSo now let say the holiday allowance is 265. John Smith booked 10 hours so that 10 hours will be deducted from the 265 which would be 255. This part is easy enough just by doing=SUM(A1-C1)But the problem I have got is if John Smith booked a 5-hour holiday a few weeks later, and you updated the cell “Hours Used” from 10 hours to 5 hours, the total would be then 260. But realistically, it should be 250 instead due to previous holiday . So my question is how would I go about doing this. Any help or advice would be highly appreciated.Thank you Read More
How to maintain a fixed range when cell is added
=SUM(J10:J58+G10:G58)
The above formula works perfectly fine
However, each week an additional cell needs to be inserted in J10:J58
This causes the formula to return an error
For example:
J34 is moved down one cell by performing the step Insert/Shift Cell Down.
By doing this my original formula changes from:
=SUM(J10:J58+G10:G58)
to:
=SUM(J10:J59+G10:G58)
To fix it I manually change it back to
=SUM(J10:J58+G10:G58)
How can I prevent J58 changing to J59 when a cell is inserted into the range.
=SUM(J10:J58+G10:G58) The above formula works perfectly fine However, each week an additional cell needs to be inserted in J10:J58 This causes the formula to return an error For example: J34 is moved down one cell by performing the step Insert/Shift Cell Down. By doing this my original formula changes from:=SUM(J10:J58+G10:G58)to:=SUM(J10:J59+G10:G58) To fix it I manually change it back to=SUM(J10:J58+G10:G58) How can I prevent J58 changing to J59 when a cell is inserted into the range. Read More
TOC RD generating page 1 instead of correct page numbers
I am using Word Version 2407 (Build 17830.20084) with Office 365 Apps for Business. For years, we have created TOCs pulling from multiple files using the TOC RD field. However, now instead of the correct page numbers, it shows 1 (or occasionally the first page number of one of the files). This first started on someone else’s machine and until now, I was able to successfully generate a correct TOC for them. This is happening with multiple documents. We’ve tried manipulating the page number and TOC fields, safe mode, replacing normal.dotm, and repairing the Office install. Note that the TOC works just fine on an individual document (i.e., when not using RD). Any ideas?
I am using Word Version 2407 (Build 17830.20084) with Office 365 Apps for Business. For years, we have created TOCs pulling from multiple files using the TOC RD field. However, now instead of the correct page numbers, it shows 1 (or occasionally the first page number of one of the files). This first started on someone else’s machine and until now, I was able to successfully generate a correct TOC for them. This is happening with multiple documents. We’ve tried manipulating the page number and TOC fields, safe mode, replacing normal.dotm, and repairing the Office install. Note that the TOC works just fine on an individual document (i.e., when not using RD). Any ideas? Read More
Can I restore a file from an over written partition?
I recently had to restore a backed-up system partition, which unfortunately resulted in the overwriting of all data on my C drive. As a result, I ended up losing certain files that were stored in my AppData/Local/Kemper Amps folder prior to the restore. Despite trying multiple recovery programs, I have been unsuccessful in recovering those specific files.
Do you have any suggestions or solutions that do not involve the common advice of backing up files in advance? Any assistance would be greatly appreciated. Thank you.
I recently had to restore a backed-up system partition, which unfortunately resulted in the overwriting of all data on my C drive. As a result, I ended up losing certain files that were stored in my AppData/Local/Kemper Amps folder prior to the restore. Despite trying multiple recovery programs, I have been unsuccessful in recovering those specific files. Do you have any suggestions or solutions that do not involve the common advice of backing up files in advance? Any assistance would be greatly appreciated. Thank you. Read More
Change cell between 2 colours based on upcoming date 2+ years in advance
Hi there,
I’ve got a project on at the minute, where I need to have cells containing dates change between colours under 2 conditions. (Technically 3 but I’ve already sorted the last one out.)
The dates are split into 2 columns, one for the date the source is deleted, and the other is when the source document should be downloaded by. The source deletion date is 6 years after the source date, and the source download by date is 2 years prior to the deletion date.
My requirements are as follows:
Orange
When the source deletion date is within 4 years and 25 days of today’s date.When the source download date is within 2 years and 25 days of today’s date.
Red
When the source deletion date is within 4 years of today’s date.When the source download date is within 2 years of today’s date.
Basically, I want a 25 day window where both cells in D and E go from white to orange – showing it needs to be tasked, and then orange to red – showing that the 25 day window has passed.
See example below:
I’ve spent a good time trying to work out the cell formatting for this, and just can’t get it to work. Either it stays orange, or doesn’t pick it up at all when I test it with different dates.
Any help would be appreciated, and step-by-step would also help as I’m still new to this type of Excel.
P.S. In my actual sheet, I’ve got a formula in the D and E columns to pick up the date in C, and add 6 years and 4 years respectively.
I’ve also already got a rule for the green colour whereby if “Yes” is noted in G column, then it will mark all dates as green (completed) regardless of today’s date.
Hi there, I’ve got a project on at the minute, where I need to have cells containing dates change between colours under 2 conditions. (Technically 3 but I’ve already sorted the last one out.) The dates are split into 2 columns, one for the date the source is deleted, and the other is when the source document should be downloaded by. The source deletion date is 6 years after the source date, and the source download by date is 2 years prior to the deletion date. My requirements are as follows:OrangeWhen the source deletion date is within 4 years and 25 days of today’s date.When the source download date is within 2 years and 25 days of today’s date.RedWhen the source deletion date is within 4 years of today’s date.When the source download date is within 2 years of today’s date.Basically, I want a 25 day window where both cells in D and E go from white to orange – showing it needs to be tasked, and then orange to red – showing that the 25 day window has passed. See example below: I’ve spent a good time trying to work out the cell formatting for this, and just can’t get it to work. Either it stays orange, or doesn’t pick it up at all when I test it with different dates. Any help would be appreciated, and step-by-step would also help as I’m still new to this type of Excel. P.S. In my actual sheet, I’ve got a formula in the D and E columns to pick up the date in C, and add 6 years and 4 years respectively.I’ve also already got a rule for the green colour whereby if “Yes” is noted in G column, then it will mark all dates as green (completed) regardless of today’s date. Read More
System Making Shortcuts | Desktop
I am experiencing a perplexing issue with my Windows 11 computer – it keeps re-adding shortcuts to the desktop for programs that were originally installed over a year ago, despite me having deleted them previously. It’s as if these shortcuts are reappearing out of nowhere, almost like a haunting presence. Interestingly, I do not have OneDrive installed on the system.
Windows Build/Version: V23H2 (OS Build 22631.3880)
I am experiencing a perplexing issue with my Windows 11 computer – it keeps re-adding shortcuts to the desktop for programs that were originally installed over a year ago, despite me having deleted them previously. It’s as if these shortcuts are reappearing out of nowhere, almost like a haunting presence. Interestingly, I do not have OneDrive installed on the system. Windows Build/Version: V23H2 (OS Build 22631.3880) Read More
The Importance of Validation HostPools in AVD Deployments: Lessons from the CrowdStrike Global Issue
In the rapidly evolving world of IT, ensuring the stability and reliability of virtual desktop environments is crucial. Azure Virtual Desktop (AVD) deployments offer a flexible and scalable solution for organizations, but with this flexibility comes the need for rigorous testing and validation. This article explores the importance of validation host pools in AVD deployments, particularly for testing updates before pushing them to production, and draws parallels to the recent global issue caused by CrowdStrike.
The Role of Validation Host Pools in AVD are a critical component in the deployment and maintenance of AVD environments. These pools allow organizations to test updates and changes in a controlled environment before they are applied to the production environment. This process helps in identifying potential issues that could disrupt user experience or cause downtime.
Key Benefits of Validation Host Pools:
Early Detection of Issues: By testing updates in a validation host pool, IT teams can identify and resolve issues before they impact the production environment.
Minimized Downtime: Validation helps in ensuring that updates do not introduce errors that could lead to downtime, thus maintaining business continuity.
Improved User Experience: Regular testing in a validation environment ensures that end-users experience fewer disruptions and maintain productivity.
The CrowdStrike Global Issue: A Case Study:
Recently, a faulty software update from CrowdStrike led to a massive global outage, affecting millions of Windows computers. This incident underscores the importance of thorough testing and validation before deploying updates to production environments.
What Happened:
A software update for CrowdStrike’s Falcon Sensor caused Windows computers to crash, leading to widespread disruptions across various sectors, including airlines, banks, and emergency services.
The issue was traced back to a logic error in the update, which was not detected before the update was pushed to production.
Lessons Learned:
Critical Need for Validation: The CrowdStrike incident highlights the necessity of having robust validation processes in place. If the update had been thoroughly tested in a validation environment, the issue could have been identified and rectified before causing widespread disruption.
Continuous Monitoring: Even after deploying updates, continuous monitoring in a validation environment can help in quickly identifying and mitigating any unforeseen issues.
To implement Validation Host Pools in AVD, follow these steps:
Create a Host Pool: Use the Azure portal, PowerShell, or Azure CLI to create a new host pool or configure an existing one as a validation environment.
Define the Validation Environment: In the Azure portal, select the host pool, go to properties, and enable the validation environment setting.
Regular Testing: Ensure that the validation host pool is used regularly for testing updates and changes. This should mimic the production environment as closely as possible.
The recent CrowdStrike global issue serves as a stark reminder of the importance of validation host pools in AVD deployments. By implementing and maintaining a robust validation environment, organizations can significantly reduce the risk of disruptions and ensure a seamless user experience. As the IT landscape continues to evolve, the role of validation host pools will only become more critical in maintaining the stability and reliability of virtual desktop environments.
In the rapidly evolving world of IT, ensuring the stability and reliability of virtual desktop environments is crucial. Azure Virtual Desktop (AVD) deployments offer a flexible and scalable solution for organizations, but with this flexibility comes the need for rigorous testing and validation. This article explores the importance of validation host pools in AVD deployments, particularly for testing updates before pushing them to production, and draws parallels to the recent global issue caused by CrowdStrike.
The Role of Validation Host Pools in AVD are a critical component in the deployment and maintenance of AVD environments. These pools allow organizations to test updates and changes in a controlled environment before they are applied to the production environment. This process helps in identifying potential issues that could disrupt user experience or cause downtime.
Key Benefits of Validation Host Pools:
Early Detection of Issues: By testing updates in a validation host pool, IT teams can identify and resolve issues before they impact the production environment.
Minimized Downtime: Validation helps in ensuring that updates do not introduce errors that could lead to downtime, thus maintaining business continuity.
Improved User Experience: Regular testing in a validation environment ensures that end-users experience fewer disruptions and maintain productivity.
The CrowdStrike Global Issue: A Case Study:
Recently, a faulty software update from CrowdStrike led to a massive global outage, affecting millions of Windows computers. This incident underscores the importance of thorough testing and validation before deploying updates to production environments.
What Happened:
A software update for CrowdStrike’s Falcon Sensor caused Windows computers to crash, leading to widespread disruptions across various sectors, including airlines, banks, and emergency services.
The issue was traced back to a logic error in the update, which was not detected before the update was pushed to production.
Lessons Learned:
Critical Need for Validation: The CrowdStrike incident highlights the necessity of having robust validation processes in place. If the update had been thoroughly tested in a validation environment, the issue could have been identified and rectified before causing widespread disruption.
Continuous Monitoring: Even after deploying updates, continuous monitoring in a validation environment can help in quickly identifying and mitigating any unforeseen issues.
To implement Validation Host Pools in AVD, follow these steps:
Create a Host Pool: Use the Azure portal, PowerShell, or Azure CLI to create a new host pool or configure an existing one as a validation environment.
Define the Validation Environment: In the Azure portal, select the host pool, go to properties, and enable the validation environment setting.
Regular Testing: Ensure that the validation host pool is used regularly for testing updates and changes. This should mimic the production environment as closely as possible.
The recent CrowdStrike global issue serves as a stark reminder of the importance of validation host pools in AVD deployments. By implementing and maintaining a robust validation environment, organizations can significantly reduce the risk of disruptions and ensure a seamless user experience. As the IT landscape continues to evolve, the role of validation host pools will only become more critical in maintaining the stability and reliability of virtual desktop environments. Read More
How to Import Gmail Contacts into Outlook?
I’ve been struggling for a long time to synchronize my Outlook contacts with my Gmail contacts, and I’m looking for a solution to import Gmail contacts into Outlook while avoiding duplicates. Is there a method that allows for seamless integration without having to delete all existing Outlook contacts before importing from Gmail? Furthermore, the limitation of being able to delete only 10 Outlook contacts at a time seems to hinder the process. Is there a workaround to streamline this tedious task and achieve efficient contact management between the two platforms?
I’ve been struggling for a long time to synchronize my Outlook contacts with my Gmail contacts, and I’m looking for a solution to import Gmail contacts into Outlook while avoiding duplicates. Is there a method that allows for seamless integration without having to delete all existing Outlook contacts before importing from Gmail? Furthermore, the limitation of being able to delete only 10 Outlook contacts at a time seems to hinder the process. Is there a workaround to streamline this tedious task and achieve efficient contact management between the two platforms? Read More
Can I see how much my IGPU is being used vs dedicated?
Hello, I’m interested in monitoring the utilization of my integrated graphics processor (IGPU) in comparison to dedicated graphics. I’m in the market for a new laptop and want to assess if I truly need dedicated graphics based on my usage patterns. Is there a tool available to track historical usage or is monitoring limited to real-time data only? Any assistance on this matter would be greatly appreciated. Thank you.
Hello, I’m interested in monitoring the utilization of my integrated graphics processor (IGPU) in comparison to dedicated graphics. I’m in the market for a new laptop and want to assess if I truly need dedicated graphics based on my usage patterns. Is there a tool available to track historical usage or is monitoring limited to real-time data only? Any assistance on this matter would be greatly appreciated. Thank you. Read More
How to click on hyperlink inside email message?
How to click on hyperlink inside email message (Outlook 2007 and above).
Do you have video or tutorial?
use the module of you email service and « Watch emails » (Outlook 2007 and above, …)Use a Webhook → Mailhook and configure a redirection in your email tool to redirect to that new mail hook address
How to click on hyperlink inside email message (Outlook 2007 and above).Do you have video or tutorial?use the module of you email service and « Watch emails » (Outlook 2007 and above, …)Use a Webhook → Mailhook and configure a redirection in your email tool to redirect to that new mail hook address Read More