Category: Microsoft
Category Archives: Microsoft
Risky sign-ins not showing anything
Hi,
For some time already, I am not sure why but I cannot see anything in risky sign-ins in Identity Protection (MS Entra). Even when I receive a summary email (Microsoft Entra ID Protection Weekly Digest) mentioning there were risky sinn-ings detected.
When I click on the risky signings directly in the email to take me to the report, I see no data there at all… When I modify filters to include all, nothing shows up either. It has been like this for few months already. Before, I could see them with no issues.
Has anything changed? Or why I can’t see any records?
Hi, For some time already, I am not sure why but I cannot see anything in risky sign-ins in Identity Protection (MS Entra). Even when I receive a summary email (Microsoft Entra ID Protection Weekly Digest) mentioning there were risky sinn-ings detected. When I click on the risky signings directly in the email to take me to the report, I see no data there at all… When I modify filters to include all, nothing shows up either. It has been like this for few months already. Before, I could see them with no issues. Has anything changed? Or why I can’t see any records? Read More
Working with Calendar Permissions using the Microsoft Graph PowerShell SDK
The Set-MailboxFolderPermission cmdlet is usually used to set calendar permissions, including the permission for the default user to allow everyone in an organization to see each other’s calendars. But you can use cmdlets from the Microsoft Graph PowerShell SDK too. The Graph SDK cmdlets are faster, but not enough to warrant replacing the Exchange cmdlet in scripts. We explain why here.
https://office365itpros.com/2024/06/18/set-default-calendar-permission/
The Set-MailboxFolderPermission cmdlet is usually used to set calendar permissions, including the permission for the default user to allow everyone in an organization to see each other’s calendars. But you can use cmdlets from the Microsoft Graph PowerShell SDK too. The Graph SDK cmdlets are faster, but not enough to warrant replacing the Exchange cmdlet in scripts. We explain why here.
https://office365itpros.com/2024/06/18/set-default-calendar-permission/ Read More
Formula for finding product of factors.
I am looking for a formula to calculate the product of cells a1, b2 and c3. The formula should only calculate the cells with value greater than 0. If a cell is 0, it must not be included in the calculation.
I am looking for a formula to calculate the product of cells a1, b2 and c3. The formula should only calculate the cells with value greater than 0. If a cell is 0, it must not be included in the calculation. Read More
How do I resolve Quick.Books Error 6000 when opening a company file?
I’m encountering Quick.Books Error 6000 when trying to open my company file. This error is preventing me from accessing my financial data, and I need a quick solution to get back on track. What steps can I take to troubleshoot and resolve this issue effectively?
I’m encountering Quick.Books Error 6000 when trying to open my company file. This error is preventing me from accessing my financial data, and I need a quick solution to get back on track. What steps can I take to troubleshoot and resolve this issue effectively? Read More
tab key doesn’t type tab character in code editor
i’m writing scripts in the automate tab. when i’m in the code editor and press the tab key, it does not type a tab character, nor does it properly autocomplete the suggestion. Instead, it switches focus to the “Insert action” button. Subsequent tab presses switch focus to other elements of the GUI until the focus ends up on a cell and then just keeps moving over to the right.
I used to be able to type tabs and select autocompletes with the tab button. Then, this behavior seemed to appear after the first time I used the “insert action” button to record something. I can’t find any setting to change back to the original behavior. quitting excel or restarting doesn’t fix it. It’s so frustrating.
Using excel for Mac.
i’m writing scripts in the automate tab. when i’m in the code editor and press the tab key, it does not type a tab character, nor does it properly autocomplete the suggestion. Instead, it switches focus to the “Insert action” button. Subsequent tab presses switch focus to other elements of the GUI until the focus ends up on a cell and then just keeps moving over to the right. I used to be able to type tabs and select autocompletes with the tab button. Then, this behavior seemed to appear after the first time I used the “insert action” button to record something. I can’t find any setting to change back to the original behavior. quitting excel or restarting doesn’t fix it. It’s so frustrating. Using excel for Mac. Read More
Lesson Learned #503: Lessons Learned Using JDBC Logging with Microsoft JDBC Driver for SQL Server
A few days ago, our customer encountered connectivity issues while using HikariCP in their Java application. To troubleshoot the problem, we enabled detailed logging for the Microsoft JDBC Driver for SQL Server. This logging gave me a lot of information and details, following I would like to share my lessons learned here.
To capture detailed logs, we configured the Java logging framework to record the operations of the JDBC driver at a fine-grained level.
To enable the logging I included these instrucctions in the code:
import java.util.logging.*;
public static void main(String[] args) throws Exception{
Logger globalLogger1 = Logger.getLogger(Logger.GLOBAL_LOGGER_NAME);
globalLogger1.setLevel(Level.FINE);
Logger rootLogger1 = Logger.getLogger(“”);
rootLogger1.setLevel(Level.FINE); // Set the root logger level
// Create a custom formatter
Formatter customFormatter = new Formatter() {
@Override
public String format(LogRecord record) {
return String.format(“[%1$tF %1$tT] [%2$s] %3$s %n”,
record.getMillis(),
record.getLevel().getName(),
record.getMessage());
}
};
// Remove all existing handlers
// Create a new console handler
ConsoleHandler consoleHandler = new ConsoleHandler();
consoleHandler.setLevel(Level.FINE); // Set the level for console handler
consoleHandler.setFormatter(customFormatter);
//consoleHandler.setFormatter(new SimpleFormatter()); // Set the formatter
// Add the new handler to the root logger
rootLogger1.addHandler(consoleHandler);
// Set specific log levels for SQL Server JDBC driver
Logger sqlLogger = Logger.getLogger(“com.microsoft.sqlserver.jdbc”);
sqlLogger.setLevel(Level.FINE);
Logger sqlDataSourceLogger = Logger.getLogger(“com.microsoft.sqlserver.jdbc.SQLServerDataSource”);
sqlDataSourceLogger.setLevel(Level.FINE);
}
Basically, after enabling this information we could see the following details (as an example):
ConnectionID.
Redirection (depending on connection policy).
Login Timeout.
[2024-06-18 10:27:21] [FINE] ConnectionID:1 created by (SQLServerDataSource:1)
[2024-06-18 10:27:21] [FINE] ConnectionID:1 This attempt server name: servername.database.windows.net port: 1433 InstanceName: null useParallel: false
[2024-06-18 10:27:21] [FINE] ConnectionID:1 This attempt endtime: 1718699261215
[2024-06-18 10:27:21] [FINE] ConnectionID:1 This attempt No: 0
[2024-06-18 10:27:21] [FINE] ConnectionID:1 Connecting with server: servername.database.windows.net port: 1433 Timeout slice: 19934 Timeout Full: 20
[2024-06-18 10:27:21] [FINE] ConnectionID:1 ClientConnectionId: 80f77dcf-5d20-47bc-be53-025868ac76e6 Server returned major version:12
[2024-06-18 10:27:22] [FINE] ConnectionID:1 This attempt server name: aabeaXXX.trXXXX.northeurope1-a.worker.database.windows.net port: 11002 InstanceName: null useParallel: false
[2024-06-18 10:27:22] [FINE] ConnectionID:1 This attempt endtime: 1718699261215
[2024-06-18 10:27:22] [FINE] ConnectionID:1 This attempt No: 1
[2024-06-18 10:27:22] [FINE] ConnectionID:1 Connecting with server: aabeaXXX.trXXXX.northeurope1-a.worker.database.windows.net port: 11002 Timeout slice: 19074 Timeout Full: 20
[2024-06-18 10:27:22] [FINE] ConnectionID:1 ClientConnectionId: 0bb41f4c-dcac-4a32-9e04-8f9395055527 Server returned major version:12
[2024-06-18 10:27:22] [FINE] SQLServerStatement:1 created by (ConnectionID:1 ClientConnectionId: 0bb41f4c-dcac-4a32-9e04-8f9395055527)
[2024-06-18 10:27:22] [FINE] SQLServerStatement:1 Executing (not server cursor) select 1
[2024-06-18 10:27:23] [FINE] SQLServerResultSet:1 created by (SQLServerStatement:1)
[2024-06-18 10:27:23] [FINE] SQLServerStatement:2 created by (ConnectionID:1 ClientConnectionId: 0bb41f4c-dcac-4a32-9e04-8f9395055527)
[2024-06-18 10:27:23] [FINE] SQLServerStatement:2 Executing (not server cursor) SELECT 1
[2024-06-18 10:27:23] [FINE] ConnectionID:2 created by (SQLServerDataSource:1)
[2024-06-18 10:27:23] [FINE] sp_executesql SQL: SELECT 1 AS ID: calling sp_executesql: SQL:SELECT 1 AS ID
[2024-06-18 10:27:23] [FINE] ConnectionID:2 ClientConnectionId: 3161a9ac-f8f4-4eab-bf80-999f48859d26 Server returned major version:12
[2024-06-18 10:27:23] [FINE] SQLServerResultSet:3 created by (sp_executesql SQL: SELECT 1 AS ID)
Microsoft Tech Community – Latest Blogs –Read More
Why is My Quick-Books Keeps Crashing after update?
Why does Quick-Books keep crashing on my computer, and how can I fix this issue to ensure it runs smoothly?
Why does Quick-Books keep crashing on my computer, and how can I fix this issue to ensure it runs smoothly? Read More
Edge Update Policy is not applied on WIN 11 PRO for workstation device, (MDM by Intune)
Hello,
We found Edge (V125) Update Policies are not applied on WIN 11 PRO for workstation (23H2) device, which is managed by MDM-enrollment. Not sure if it is by design purpose or not.
Even we enrolled the device into Intune, and configure the policy using admin template, and the device has received the policy and updated in the registry, however on edge://policy page, there are not policies displayed at all (in Microsoft EdgeUpdte Policy section). Only normal edge policies are applied.
Could you pls look into it, coz it works on win 11 pro version and can not understand why it is not working on proworkstation, anyway, it is just a branch of pro version.
Hello, We found Edge (V125) Update Policies are not applied on WIN 11 PRO for workstation (23H2) device, which is managed by MDM-enrollment. Not sure if it is by design purpose or not. Even we enrolled the device into Intune, and configure the policy using admin template, and the device has received the policy and updated in the registry, however on edge://policy page, there are not policies displayed at all (in Microsoft EdgeUpdte Policy section). Only normal edge policies are applied. Could you pls look into it, coz it works on win 11 pro version and can not understand why it is not working on proworkstation, anyway, it is just a branch of pro version. Read More
Lookup column and List template
1.) Lookup column can return the value from another list, but can it work like excel vlookup where i can indicate col_index_num? For example, the column is looking up “staffID” column from another list, but after selection of “staffID”, it shows the “staffName” as column value.
2.) If new columns are added to a list template, how to reflect the updates in existing lists using this template? Or is it about content type? Please advice, thanks!
1.) Lookup column can return the value from another list, but can it work like excel vlookup where i can indicate col_index_num? For example, the column is looking up “staffID” column from another list, but after selection of “staffID”, it shows the “staffName” as column value.2.) If new columns are added to a list template, how to reflect the updates in existing lists using this template? Or is it about content type? Please advice, thanks! Read More
Find/Replace highlight cells with nothing in them
Hi all
Find/Replace highlight cells with nothing in them, and when I delete these cells the new ones are just the same.
Any ideas?
Hi allFind/Replace highlight cells with nothing in them, and when I delete these cells the new ones are just the same.Any ideas? Read More
Specific meeting sessions issues
Hi all,
So, we have a few members of our organisation who are keen to use Microsoft Bookings. Having the ability for them to have 1 training session but has potentially two or three dates to ensure all staff can attend would be a game changer for them.
I have gone ahead and set this up for them based on the following requirements.
Training session ‘A’ takes place on
Thursday the 4th of July (Daytime) 10:00-12:00
Saturday the 6th of July (Daytime) 10:00-12:00
Monday the 8th of July (Evening) 18:00-20:00
I have set up the service with the following settings
Availability Options
Time increments – 2 Hours
General Availability – Not bookable
Availability during these dates – (customised hours) 04/07/24 10:00 – 12:00
Availability during these dates – (customised hours) 06/07/24 10:00 – 12:00
Availability during these dates – (customised hours) 08/07/24 18:00 – 20:00
General business hours are set from 09:00 – 23:00 every day
So, in theory I want people to be given the option to book in at 10:00 or 18:00 relative to the date, however on the booking page I am being presented with an option for 11:00 or 19:00. (See example below)
Would anyone be able to help with this matter please? I’d greatly appreciate it.
Many thanks,
Matthew
Hi all, So, we have a few members of our organisation who are keen to use Microsoft Bookings. Having the ability for them to have 1 training session but has potentially two or three dates to ensure all staff can attend would be a game changer for them. I have gone ahead and set this up for them based on the following requirements. Training session ‘A’ takes place onThursday the 4th of July (Daytime) 10:00-12:00Saturday the 6th of July (Daytime) 10:00-12:00Monday the 8th of July (Evening) 18:00-20:00 I have set up the service with the following settingsAvailability OptionsTime increments – 2 HoursGeneral Availability – Not bookableAvailability during these dates – (customised hours) 04/07/24 10:00 – 12:00Availability during these dates – (customised hours) 06/07/24 10:00 – 12:00Availability during these dates – (customised hours) 08/07/24 18:00 – 20:00 General business hours are set from 09:00 – 23:00 every day So, in theory I want people to be given the option to book in at 10:00 or 18:00 relative to the date, however on the booking page I am being presented with an option for 11:00 or 19:00. (See example below) Would anyone be able to help with this matter please? I’d greatly appreciate it. Many thanks,Matthew Read More
Lock some cells for editing at the same time lock another range from pasting
Dear Community,
I have browsed several threads on the platform to find solution to this specific problem but havnt got it anywhere. I know that there is a methodology to lock the cells in a spreadsheet from editing as well as lock in formats to stop users from changing them however how do I do both in one.
For example, I have a spreadsheet in which there is a table. I would like to lock the columns A,B and C such that users are not able to edit value, at the same time I would like to lock cells in column D,E,F such that users cannot paste in values but access the drop down lists in cells to select values.
Is there anyway to achieve this?
Your inputs are highly appreciated 🙂
Dear Community, I have browsed several threads on the platform to find solution to this specific problem but havnt got it anywhere. I know that there is a methodology to lock the cells in a spreadsheet from editing as well as lock in formats to stop users from changing them however how do I do both in one. For example, I have a spreadsheet in which there is a table. I would like to lock the columns A,B and C such that users are not able to edit value, at the same time I would like to lock cells in column D,E,F such that users cannot paste in values but access the drop down lists in cells to select values. Is there anyway to achieve this? Your inputs are highly appreciated 🙂 Read More
Create Plans from Planner Plans
There are very many Planner plans (Included tier) around the organization. I want to import these into Planner Plans (Planner Plan 1 & Project Plan 3 i.e. ‘Project for web’) so that they can be included in a Roadmap (Project Plan 3 tier).
How do I do that, please?
Thank you
There are very many Planner plans (Included tier) around the organization. I want to import these into Planner Plans (Planner Plan 1 & Project Plan 3 i.e. ‘Project for web’) so that they can be included in a Roadmap (Project Plan 3 tier). How do I do that, please? Thank you Read More
Upgrade SP2016 to hybrid with one drive
Hi,
My organization is currently running on SP2016 on-premises without one drive access. Recently, we have kicked off discussions to upgrade SP2016 to Hybrid with one drive for file storage.
We use MS365 for teams and other desktop apps such as excel, word, PowerPoint etc. I was wondering if we go down the path of upgrading to hybrid solution, then:
Do we need to setup one drive in hybrid environment?
Can we use one drive to replace network shares for file storage?
what sort of configuration do we need to put in place to store sensitive documents with security labels?
Any input will be highly appreciated.
Thanks
Hi, My organization is currently running on SP2016 on-premises without one drive access. Recently, we have kicked off discussions to upgrade SP2016 to Hybrid with one drive for file storage. We use MS365 for teams and other desktop apps such as excel, word, PowerPoint etc. I was wondering if we go down the path of upgrading to hybrid solution, then: Do we need to setup one drive in hybrid environment?Can we use one drive to replace network shares for file storage?what sort of configuration do we need to put in place to store sensitive documents with security labels? Any input will be highly appreciated. Thanks Read More
Recommend me a safe & best YouTube to mp3 converter for my Windows 11
I’m currently on the lookout for a reliable and safe YouTube to MP3 converter that works seamlessly on Windows 11. I need a tool that can efficiently convert videos to high-quality audio files, ideally without compromising on sound quality. Additionally, it’s important that the software is user-friendly and free from excessive ads or security risks. If anyone has recommendations for such a tool, especially one that has proven to be dependable over time, please share your experiences. Your input will be greatly appreciated as it will help streamline my workflow and enhance my multimedia projects.
I’m currently on the lookout for a reliable and safe YouTube to MP3 converter that works seamlessly on Windows 11. I need a tool that can efficiently convert videos to high-quality audio files, ideally without compromising on sound quality. Additionally, it’s important that the software is user-friendly and free from excessive ads or security risks. If anyone has recommendations for such a tool, especially one that has proven to be dependable over time, please share your experiences. Your input will be greatly appreciated as it will help streamline my workflow and enhance my multimedia projects. Read More
Why is My Quick-Books pay-roll update not working after update?
Quick-Books pay-roll update not working. Getting errors during the update process. How can I resolve this issue and ensure my pay-roll updates successfully?
Quick-Books pay-roll update not working. Getting errors during the update process. How can I resolve this issue and ensure my pay-roll updates successfully? Read More
How to Fix Quick-Books Error 1920 after windows update?
What is Quick-Books Error 1920, and how can I fix it? I’m having trouble installing Quick-Books Desktop due to this error.
What is Quick-Books Error 1920, and how can I fix it? I’m having trouble installing Quick-Books Desktop due to this error. Read More
Exchange admin center Delegation permissions error
I am having a strange issue with Exchange Admin Centre
I am signed in as a Global Administrator but when I go to a user’s mailbox and then to the delegation tab I get the following error.
Error:
I am having a strange issue with Exchange Admin Centre I am signed in as a Global Administrator but when I go to a user’s mailbox and then to the delegation tab I get the following error. Failed to get mailbox permissionsError:User is not allowed to call Get-MailboxPermission Is this a bug? I wouldn’t think it was a permissions issue as I have been fine for years with my current ones. Read More
How to Resolve Quick-Books Database Manager failed to start issue after update?
I am facing an issue where the Quick-Books Database Manager failed to start. What could be causing this, and what are the possible troubleshooting steps to resolve it?
I am facing an issue where the Quick-Books Database Manager failed to start. What could be causing this, and what are the possible troubleshooting steps to resolve it? Read More
Platform engineering: Monitor Backstage with Application Insights
The platform engineering journey requires abundant information to make informed decisions. Understanding how developers use the platform—how frequently and for how long—is invaluable. Since the internal developer portal (IDP) serves as the central hub for developers’ regular tasks, it becomes the ideal location for monitoring these activities and collecting essential data.
Backstage, a common IDP implementation, provides an excellent opportunity to demonstrate how to integrate monitoring. In this article, we’ll explore how to add monitoring to the Backstage portal using Azure Monitor, specifically Application Insights.
Upon reviewing the Backstage documentation, we find that the portal is already instrumented using OpenTelemetry. Furthermore, Application Insights is a supported provider for OpenTelemetry.
This is excellent news, as it streamlines the process and saves time that would otherwise be spent manually adding tracing calls to the Backstage code.
To enable OpenTelemetry instrumentation, follow the steps in the official documentation(https://backstage.io/docs/tutorials/setup-opentelemetry/). Start by adding the required packages using the following command:
yarn –cwd packages/backend add
@opentelemetry/sdk-node
@opentelemetry/auto-instrumentations-node
/monitor-opentelemetry-exporter
Next, create a new file named instrumentation.js inside the backend/src folder.
The content of the file should be:
const { NodeSDK } = require(‘@opentelemetry/sdk-node’);
const {
getNodeAutoInstrumentations,
} = require(‘@opentelemetry/auto-instrumentations-node’);
const { AzureMonitorTraceExporter } = require(“@azure/monitor-opentelemetry-exporter”);
const { AzureMonitorMetricExporter } = require(“@azure/monitor-opentelemetry-exporter”);
// Create an exporter instance
const azTraceExporter = new AzureMonitorTraceExporter({
connectionString:
process.env[“APPLICATIONINSIGHTS_CONNECTION_STRING”] || “<YourAppInsightsConnectionString>”
});
const sdk = new NodeSDK({
traceExporter: azTraceExporter,
instrumentations: [getNodeAutoInstrumentations()],
});
sdk.start();
And with that…we are done!
Browse some pages within the Backstage portal and in a few minutes, telemetry will be available in Application Insights.
Here are some samples of information that has been gathered. All this information is out-of-the-box reports, so without any other customization, we can obtain a wealth of information.
We can check if the portal is returning errors, if the response time is within acceptable parameters, how many requests are made and the usage pattern…
Examine the details of a request to Backstage, the time taken to serve the request and the time spent on all dependencies…
Retrieve information from the accessed URLs, for example, to identify the most common searches and ascertain developers’ interests.
Microsoft Tech Community – Latest Blogs –Read More