Tag Archives: microsoft
Camera with black screen
Hello, I have encountered a black screen issues with the windows camera app on my laptop. I have tried various ways such as reinstalling the app and updating the windows driver but does not work.
The camera is able to detect the faces but does not show any images. May I know how can I fix this issue?
Thank you in advance.
Hello, I have encountered a black screen issues with the windows camera app on my laptop. I have tried various ways such as reinstalling the app and updating the windows driver but does not work. The camera is able to detect the faces but does not show any images. May I know how can I fix this issue? Thank you in advance. Read More
Adding 1 to Every Number in Formula String
Hi All,
I am working on many workbooks and for all of them, I am using conditional formatting for hundreds of cells. Specifically, I am using 7 different cell ranges, and the cells themselves are always one cell apart. For example, this is for one of the ranges (with hundreds more references in this range and in each range):
B$4:AS$4,B$9:AS$9,B$14:AS$14,B$19:AS$19
Is there a formula I can use to add +1 to every number, so I don’t have to do it manually? I can’t find an answer anywhere. Here is what I would need:
B$5:AS$5,B$10:AS$10,B$15:AS$15,B$20:AS$20
Thank you for the help.
Hi All, I am working on many workbooks and for all of them, I am using conditional formatting for hundreds of cells. Specifically, I am using 7 different cell ranges, and the cells themselves are always one cell apart. For example, this is for one of the ranges (with hundreds more references in this range and in each range): B$4:AS$4,B$9:AS$9,B$14:AS$14,B$19:AS$19 Is there a formula I can use to add +1 to every number, so I don’t have to do it manually? I can’t find an answer anywhere. Here is what I would need: B$5:AS$5,B$10:AS$10,B$15:AS$15,B$20:AS$20 Thank you for the help. Read More
Login failed for user ‘sp’. Reason: Password did not match that for the login provided
Please excuse my ignorance of basic SQL Server admin. Any advice much appreciated. I cannot login using passwords. For example:
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat -e
1> create login sp with password=’sp’;
2> go
create login sp with password=’sp’;
1> create user sp for login sp;
2> go
create user sp for login sp;
1> alter server role sysadmin add member [sp];
2> go
alter server role sysadmin add member [sp];
1> exit
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat,1433 -U sp -P ‘sp’
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user ‘sp’..
C:Usersjohn>
In the SQL Server log I see this,
Date Sun 21 07 2024 14:26:33
Log SQL Server (Current – Sun 21 07 2024 14:26:00)
Source Logon
Message
Login failed for user ‘sp’. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
I have tried any number of variations on case and quotes. I must be missing something really basic?
Thankyou for any insight.
Please excuse my ignorance of basic SQL Server admin. Any advice much appreciated. I cannot login using passwords. For example:C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat -e
1> create login sp with password=’sp’;
2> go
create login sp with password=’sp’;
1> create user sp for login sp;
2> go
create user sp for login sp;
1> alter server role sysadmin add member [sp];
2> go
alter server role sysadmin add member [sp];
1> exit
C:Usersjohn>
C:Usersjohn>sqlcmd -s jw-lat,1433 -U sp -P ‘sp’
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user ‘sp’..
C:Usersjohn>In the SQL Server log I see this,Date Sun 21 07 2024 14:26:33
Log SQL Server (Current – Sun 21 07 2024 14:26:00)
Source Logon
Message
Login failed for user ‘sp’. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]I have tried any number of variations on case and quotes. I must be missing something really basic?Thankyou for any insight. Read More
Latest Threat Intelligence (July 2024)
Latest Threat Intelligence (July 2024)
Microsoft Defender for IoT has released the July 2024 Threat Intelligence package. The package is available for download from the Microsoft Defender for IoT portal (click Updates, then Download file).
Threat Intelligence updates reflect the combined impact of proprietary research and threat intelligence carried out by Microsoft security teams. Each package contains the latest CVEs (Common Vulnerabilities and Exposures), IOCs (Indicators of Compromise), and other indicators applicable to IoT/ICS/OT networks (published during the past month) researched and implemented by Microsoft Threat Intelligence Research – CPS.
The CVE scores are aligned with the National Vulnerability Database (NVD). Starting with the August 2023 threat intelligence updates, CVSSv3 scores are shown if they are relevant; otherwise the CVSSv2 scores are shown.
Guidance
Customers are recommended to update their systems with the latest TI package in order to detect potential exposure risks and vulnerabilities in their networks and on their devices. Threat Intelligence packages are updated every month with the most up-to-date security information available, ensuring that Microsoft Defender for IoT can identify malicious actors and behaviors on devices.
Update your system with the latest TI package
The package is available for download from the Microsoft Defender for IoT portal (click Updates, then Download file), for more information, please review Update threat intelligence data | Microsoft Docs.
MD5 Hash: 323c19d85bc31e035d9154643b99a69c
For cloud connected sensors, Microsoft Defender for IoT can automatically update new threat intelligence packages following their release, click here for more information. Read More
Fastest way to read entire Word text to array
ReDim arr(1 To wdDoc.Paragraphs.Count)
For i = 1 To wdDoc.Paragraphs.Count
arr(i) = wdDoc.Paragraphs(i).Range
Next i
I got above code to read all Word text to a array. It’s very slow. What is the most efficient way? I guess even copy/paste in VBA would be faster, but I think there should be a better way.
Thanks in advance.
ReDim arr(1 To wdDoc.Paragraphs.Count)For i = 1 To wdDoc.Paragraphs.Countarr(i) = wdDoc.Paragraphs(i).RangeNext i I got above code to read all Word text to a array. It’s very slow. What is the most efficient way? I guess even copy/paste in VBA would be faster, but I think there should be a better way. Thanks in advance. Read More
[Mitigated] Azure Lab Services – Maintenance update outage
Hi,
We are experiencing a service outage due to ongoing maintenance since around July 21st, 4 pm PDT. The service is currently not available in any region. We will provide the next update as soon as we have additional progress to share.
Cheers,
Fawad
Microsoft Tech Community – Latest Blogs –Read More
Identity Source
Does anyone know where I can see the source of an identity (i.e. OKTA)?
Does anyone know where I can see the source of an identity (i.e. OKTA)? Read More
“Error using `Update-Help -UICulture zh-CN` in PowerShell v7.4.3.0.”
I am unable to update the Chinese help files using the Update-Help -UICulture zh-CN command in PowerShell version v7.4.3.0. The following error occurs:
Update-Help : Failed to update Help for the modules “ConfigDefender, ConfigDefenderPerformance, PSReadline” with UI culture {zh-CN}: Cannot retrieve the HelpInfo XML file for UI culture zh-CN. Make sure the HelpInfoUri property in the module manifest is valid or check your network connection and then try the command again.At line:1 char:1
+ Update-Help -UICulture zh-CN
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ResourceUnavailable: (:) [Update-Help], Exception
+ FullyQualifiedErrorId : UnableToRetrieveHelpInfoXml,Microsoft.PowerShell.Commands.UpdateHelpCommand
I have tried the mainstream solutions, such as running the command Update-Help -ErrorAction SilentlyContinue, but it is still not working. Can anyone provide a solution?
I am unable to update the Chinese help files using the Update-Help -UICulture zh-CN command in PowerShell version v7.4.3.0. The following error occurs: Update-Help : Failed to update Help for the modules “ConfigDefender, ConfigDefenderPerformance, PSReadline” with UI culture {zh-CN}: Cannot retrieve the HelpInfo XML file for UI culture zh-CN. Make sure the HelpInfoUri property in the module manifest is valid or check your network connection and then try the command again.At line:1 char:1
+ Update-Help -UICulture zh-CN
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ResourceUnavailable: (:) [Update-Help], Exception
+ FullyQualifiedErrorId : UnableToRetrieveHelpInfoXml,Microsoft.PowerShell.Commands.UpdateHelpCommandI have tried the mainstream solutions, such as running the command Update-Help -ErrorAction SilentlyContinue, but it is still not working. Can anyone provide a solution? Read More
Azure Lab Services – Maintenance update outage
Hi,
We are experiencing a service outage due to ongoing maintenance since around July 21st, 4 pm PDT. The service is currently not available in any region. We will provide the next update as soon as we have additional progress to share.
Cheers,
Fawad
Microsoft Tech Community – Latest Blogs –Read More
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
