Category: Microsoft
Category Archives: Microsoft
How to add rows based on qty value from another field with product tied to specific PO
Trying to add a number of rows with specific value based on a number of products. instead of having users circle the item. I want to have it automatically insert the product going down based on the qty field.
In this case need to find a way to have three rows with product “Fine” and 5 rows with product Flake.
Trying to add a number of rows with specific value based on a number of products. instead of having users circle the item. I want to have it automatically insert the product going down based on the qty field.In this case need to find a way to have three rows with product “Fine” and 5 rows with product Flake. Read More
Timeline for Copilot “auto-complete” feature
Does anyone know when this will be released?
This information comes from the microsoft blog – Copilot, but I have not found any information on when this new feature will be rolled out.
“If you’ve got the start of a prompt, Copilot will offer to auto-complete it to get to a better result, suggesting something more detailed to help ensure you get what you’re looking for. That not only speeds things up, it offers you new ideas for how to leverage Copilot’s power.”
Does anyone know when this will be released? This information comes from the microsoft blog – Copilot, but I have not found any information on when this new feature will be rolled out. “If you’ve got the start of a prompt, Copilot will offer to auto-complete it to get to a better result, suggesting something more detailed to help ensure you get what you’re looking for. That not only speeds things up, it offers you new ideas for how to leverage Copilot’s power.” Read More
Branding kit – product icons
I downloaded the Microsoft 365 branding kit from the Microsoft FastTrack web site as I’ve read that this is the only way to get access to the Microsoft 365 product icons. However, the branding kit only contains PDFs of the product icons, not actual graphic images. Is there a way to get the actual images?
I downloaded the Microsoft 365 branding kit from the Microsoft FastTrack web site as I’ve read that this is the only way to get access to the Microsoft 365 product icons. However, the branding kit only contains PDFs of the product icons, not actual graphic images. Is there a way to get the actual images? Read More
Using Microsoft Viva Pulse and Glint for Employee Reviews – 30, 60, 90 & Biannual Reviews
Hi MS Viva Community,
I have been looking into Microsoft Viva across the board, but specifically looking at Pulse and Glint as a solution for deploying and tracking employee reviews. We have been using a combination of Forms, Excel and BI to carry out this process. I’m working if Pulse and Glint can be a cleaner more turnkey solution than what we have been doing.
Hi MS Viva Community, I have been looking into Microsoft Viva across the board, but specifically looking at Pulse and Glint as a solution for deploying and tracking employee reviews. We have been using a combination of Forms, Excel and BI to carry out this process. I’m working if Pulse and Glint can be a cleaner more turnkey solution than what we have been doing. Read More
Remove SP list columns from search results
I have created an employee directory in a SharePoint list. Currently, when I search the list using my name all records are returned since I created the records. I would like to remove the “Created by” and “Modified by” columns from the search results so that when someone searches for me all records are not returned. I’m looking for a solution that can be applied at the site level as I do not want to change the default behavior for other sites in the tenant.
I have created an employee directory in a SharePoint list. Currently, when I search the list using my name all records are returned since I created the records. I would like to remove the “Created by” and “Modified by” columns from the search results so that when someone searches for me all records are not returned. I’m looking for a solution that can be applied at the site level as I do not want to change the default behavior for other sites in the tenant. Read More
Hibernation support now available for Azure Virtual Desktop
Today we are happy to announce the general availability of hibernation support in Azure Virtual Desktop. Explore additional capabilities that make it easier to save compute costs for your idle resources.
Hibernation support in Azure Virtual Desktop
In November 2023, we announced the public preview of hibernation support in Azure Virtual Desktop. Hibernating a session host virtual machine (VM) deallocates the machine while persisting the VM’s in-memory state. When a VM hibernates, you don’t pay for the compute cost associated with the VM. Instead you pay only for the storage and networking costs associated with the VM. When the session host virtual machine starts, the user will be able to quickly resume from where they left off.
The following capabilities are now generally available in Azure Virtual Desktop:
Hibernation can be enabled for session host VMs deployed to personal host pools.
Hibernation can be chosen as the scaling action for disconnect or logoff for personal host pools. For more details about configuring personal scaling plan, see Create a scaling plan.
These capabilities are available in addition to those released during the public preview, which included the following:
Hibernation can be enabled on existing session host VMs.
Resize is supported for session host VMs with hibernation enabled.
Hibernation support extended to more VM sizes and series.
Getting started
You can enable hibernation when deploying session host VMs for your personal host pools using Azure Portal, PowerShell, CLI, ARM, SDKs, and APIs. You can enable hibernation for existing VMs using PowerShell, CLI, ARM, SDKs, and APIs.
A screenshot of personal host pool Virtual Machines configuration in Azure Virtual Desktop with vTPM and Integrity monitoring, Virtual machine size is set to ’Standard D2as v5’, hibernate is enabled.
To enable hibernation in your scaling plan, you will need to:
Create a personal scaling plan.
Define whether to enable or disable Start VM on Connect.
Choose to perform hibernation after a user session has been disconnected or logged off for a configurable period of time.
Assign a personal scaling plan to one or more personal host pools.
A screenshot of a scaling plan in Azure Virtual Desktop with a schedule of ramp-up is shown as repeating Monday to Friday at 9:00 AM Beijing time, starting VM on Connect. Disconnect settings are set to hibernate at 30 minutes. Log off settings are set to hibernate after 10 minutes.
Helpful resources
We encourage you to learn more about setting up autoscale and review frequently asked questions for more details on how to use hibernation with autoscale for Azure Virtual Desktop personal host pools. You may also find these resources helpful:
Microsoft Mechanics: Automated scaling, imaging & monitoring
Azure Academy: Enabling and managing Personal Desktop Autoscale
Cost Optimization for General Purpose VMs using Hibernation now Generally Available
Microsoft Tech Community – Latest Blogs –Read More
Defender For Endpoint MacOS Scheduled Scan documentation error
Hi everybody!
First post here so I hope it goes to the right place. I´m configuring Defender for Endpoint on MacOS scheduled scans and found out that the examples in the documentation have errors. I got the “XML must be well formed” error and noticed that there were some end tags missing.
There is an error in the example XML files: How to schedule scans with Microsoft Defender for Endpoint on macOS – Microsoft Defender for Endpoint | Microsoft Learn
If anyone else is banging their head on the wall. The fix is to add end tag to the “array” part and a few “dict” end tags.
Hi everybody! First post here so I hope it goes to the right place. I´m configuring Defender for Endpoint on MacOS scheduled scans and found out that the examples in the documentation have errors. I got the “XML must be well formed” error and noticed that there were some end tags missing. There is an error in the example XML files: How to schedule scans with Microsoft Defender for Endpoint on macOS – Microsoft Defender for Endpoint | Microsoft Learn If anyone else is banging their head on the wall. The fix is to add end tag to the “array” part and a few “dict” end tags. Read More
Error after windows server update
Receiving error after installing updates – KB 5027283
System.InvalidOperationException: Operation is not valid due to the current state of the object.
Some site collections work and central admin works.
The updates ran successfully, SharePoint wizard ran successfully after updates, rebooted. Single server set up.
Anyone have any idea what’s wrong?
Receiving error after installing updates – KB 5027283 System.InvalidOperationException: Operation is not valid due to the current state of the object. Some site collections work and central admin works.The updates ran successfully, SharePoint wizard ran successfully after updates, rebooted. Single server set up.Anyone have any idea what’s wrong? Read More
Individuals Content in rows to two columns
I need to pull only names and emails from these rows (each person has 25 rows) and transverse them into two columns to just have the name and emails listed. Any ideas?
I need to pull only names and emails from these rows (each person has 25 rows) and transverse them into two columns to just have the name and emails listed. Any ideas? Read More
Will people I temporarily call into a teams meeting have access to the transcript after they leave?
Wondering if people who are called into a meeting temporarily (e.g. to present on a topic) will have access to the transcript. They are not invited to the meeting, just called in when needed. I know I can cancel them from the chat after they leave, but if I don’t do this will they still have access to the transcript after they leave? It’s a concern as discussions following their departure from the meeting may be confidential.
Wondering if people who are called into a meeting temporarily (e.g. to present on a topic) will have access to the transcript. They are not invited to the meeting, just called in when needed. I know I can cancel them from the chat after they leave, but if I don’t do this will they still have access to the transcript after they leave? It’s a concern as discussions following their departure from the meeting may be confidential. Read More
Disable Copilot on Mac
How do I disable Copilot on my Macbook Pro? I absolutely detest it.
How do I disable Copilot on my Macbook Pro? I absolutely detest it. Read More
Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server
Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. We know that uniqueidentifier store globally unique identifiers (GUIDs). GUIDs are widely used for unique keys due to their extremely low probability of duplication. One common method to generate a GUID in SQL Server is by using the NEWID() function. However, the ordering of GUIDs, especially those generated by NEWID(), can appear non-intuitive. I would like to share my lessons learned how to determine the ordering method using uniqueidentifier and NEWID().
We know that a GUID is a 16-byte value typically represented in a standard format of 32 hexadecimal characters separated by hyphens, for example, EB37F277-8A16-4DE3-B1E3-FFFCBA956A82.
Each section represents different parts of the GUID:
The first 8 characters (4 bytes)
The next 4 characters (2 bytes)
The following 4 characters (2 bytes)
The next 4 characters (2 bytes)
The final 12 characters (6 bytes)
When we generated a NEWID() function generates a random GUID. This randomness ensures uniqueness but can lead to seemingly arbitrary ordering when GUIDs are compared and sorted. The comparison is done byte-by-byte from left to right in lexicographical order.
Consider the following GUIDs generated by NEWID():
C2EB258A-147F-4F26-97D7-0000F053CCA8
6682BC4F-949E-478F-BBA2-0003C71CD035
A6D423B8-07F3-4F13-B34E-0004DC3317B7
EE2C394E-7AB0-468F-B959-0005C0CC598D
How the ordering works:
To understand how SQL Server orders these GUIDs, we need to break them down into their binary components and compare each part:
C2EB258A-147F-4F26-97D7-0000F053CCA8
Binary: C2 EB 25 8A 14 7F 4F 26 97 D7 00 00 F0 53 CC A8
6682BC4F-949E-478F-BBA2-0003C71CD035
Binary: 66 82 BC 4F 94 9E 47 8F BB A2 00 03 C7 1C D0 35
A6D423B8-07F3-4F13-B34E-0004DC3317B7
Binary: A6 D4 23 B8 07 F3 4F 13 B3 4E 00 04 DC 33 17 B7
EE2C394E-7AB0-468F-B959-0005C0CC598D
Binary: EE 2C 39 4E 7A B0 46 8F B9 59 00 05 C0 CC 59 8D
When these GUIDs are ordered, SQL Server compares each byte in sequence. The final sorted order is:
6682BC4F-949E-478F-BBA2-0003C71CD035
A6D423B8-07F3-4F13-B34E-0004DC3317B7
C2EB258A-147F-4F26-97D7-0000F053CCA8
EE2C394E-7AB0-468F-B959-0005C0CC598D
To better understand and work with GUIDs, you can create SQL functions that decompose GUIDs into their components and show their ordering. To understand how the GUID is decomposed I would like to share this function.
CREATE FUNCTION dbo.DescomponerGUIDString (@guid UNIQUEIDENTIFIER)
RETURNS NVARCHAR(100)
AS
BEGIN
DECLARE @part1 NVARCHAR(8) = CONVERT(NVARCHAR(8), SUBSTRING(CONVERT(BINARY(16), @guid), 1, 4), 2);
DECLARE @part2 NVARCHAR(4) = CONVERT(NVARCHAR(4), SUBSTRING(CONVERT(BINARY(16), @guid), 5, 2), 2);
DECLARE @part3 NVARCHAR(4) = CONVERT(NVARCHAR(4), SUBSTRING(CONVERT(BINARY(16), @guid), 7, 2), 2);
DECLARE @part4 NVARCHAR(4) = CONVERT(NVARCHAR(4), SUBSTRING(CONVERT(BINARY(16), @guid), 9, 2), 2);
DECLARE @part5 NVARCHAR(12) = CONVERT(NVARCHAR(12), SUBSTRING(CONVERT(BINARY(16), @guid), 11, 6), 2);
RETURN @part1 + ‘-‘ + @part2 + ‘-‘ + @part3 + ‘-‘ + @part4 + ‘-‘ + @part5;
END;
For example, we have this table and we are going to sort using the [Guid No_] column with NewID().
select [GUID No_], dbo.DescomponerGUIDString([GUID No_]) as x from dbo.ExampleTable
ORDER BY 1
For example, we have this table and we are going to sort using the sorted calculation column with NewID().
select [GUID No_], dbo.DescomponerGUIDString([GUID No_]) as x from dbo.ExampleTable
ORDER BY 2
Microsoft Tech Community – Latest Blogs –Read More
MS Project Online API to read calendar information
Hi,
I’m trying to retrieve calendar details from MS Project Online using a calendar ID.
I’m currently using this endpoint to get the calendar information:
https://<sitecollection>/<site>/pwa/_api/ProjectServer/Calendars(‘calendarid’)
However, this endpoint does not provide information about holidays and working days in a week.
Is there an API that can fetch all this data?
Thank you.
Hi,I’m trying to retrieve calendar details from MS Project Online using a calendar ID.I’m currently using this endpoint to get the calendar information:https://<sitecollection>/<site>/pwa/_api/ProjectServer/Calendars(‘calendarid’)However, this endpoint does not provide information about holidays and working days in a week.Is there an API that can fetch all this data?Thank you. Read More
Conditional Formatting 3 Colour options
Has anyone any guidance on how I can use Conditional formatting to do the following:
Compare a value in a cell to another cell and provide a red amber green fill based on being greater than, Equal to or lower than the cell it is compared to. I want to do this to a range of cells where the value may be different in each cell and is being compared to a different cell in eache instance (example below:
Reference cell – 3 4 5 3 5 3 4
Value – 3 5 4 2 5 5 7
Fill Colour – A R G G A R R
The only was I have foud to do this so far is 3 conditional formatting formulas per cell (using formula for < = >) and I then cant copy all 3 rules to the other cells as the cell references are fixed ($B$3)
Thanks
Has anyone any guidance on how I can use Conditional formatting to do the following: Compare a value in a cell to another cell and provide a red amber green fill based on being greater than, Equal to or lower than the cell it is compared to. I want to do this to a range of cells where the value may be different in each cell and is being compared to a different cell in eache instance (example below: Reference cell – 3 4 5 3 5 3 4 Value – 3 5 4 2 5 5 7 Fill Colour – A R G G A R R The only was I have foud to do this so far is 3 conditional formatting formulas per cell (using formula for < = >) and I then cant copy all 3 rules to the other cells as the cell references are fixed ($B$3) Thanks Read More
Allow password change only on VPN
Hey guys,
currently I’m supporting a customer who got a lot of remote workers which are not often in the office. I realized that there are a lot of password issues. The cloud journey of the customer just has begun. So there is a hybrid, but Intune is not a topic yet. They have SSPR activated, and the users use different option to change their passwords, either with Ctrl + Alt + Del or directly via MySecurityInfo. Unfortunately this leads to having two passwords, if the clients are not connected to VPN. So a resetted password would effect M365 services and On-Premises infrastructure, but not the password of the local device, because this one would keep the cached device password while not having connection to local AD.
For sure you can solve this with an operational order and just tell the users that they should only change their password while being on VPN, but I would prefer to manage this with a technical solution.
One idea would be to remove the password change feature for Ctrl + Alt + Del (hopefully via GPO) and add a Conditional Access policy which should only allow the SSPR while being on VPN. It’s just my personal brainstorming.
Is this feasible, or how would you deal with this, if your device are not directly joined to Entra?
Thanks in advance.
Hey guys,currently I’m supporting a customer who got a lot of remote workers which are not often in the office. I realized that there are a lot of password issues. The cloud journey of the customer just has begun. So there is a hybrid, but Intune is not a topic yet. They have SSPR activated, and the users use different option to change their passwords, either with Ctrl + Alt + Del or directly via MySecurityInfo. Unfortunately this leads to having two passwords, if the clients are not connected to VPN. So a resetted password would effect M365 services and On-Premises infrastructure, but not the password of the local device, because this one would keep the cached device password while not having connection to local AD. For sure you can solve this with an operational order and just tell the users that they should only change their password while being on VPN, but I would prefer to manage this with a technical solution.One idea would be to remove the password change feature for Ctrl + Alt + Del (hopefully via GPO) and add a Conditional Access policy which should only allow the SSPR while being on VPN. It’s just my personal brainstorming.Is this feasible, or how would you deal with this, if your device are not directly joined to Entra? Thanks in advance. Read More
highlight cells in a column, based on values in another sheet
Hi, i have a worksheet, one sheet (“Tracker”) has a row in column E with numbers that i would like to match in a seperate sheet called “Palletainer Lookup” whereby anything that matches any numbers from the Palletainer Lookup sheet in column A is highlighted in purple on the tracker sheet in column E.
i have looked at various posts and i believe its around the conditional formatting but i cannot fathom the correct formula !
Hi, i have a worksheet, one sheet (“Tracker”) has a row in column E with numbers that i would like to match in a seperate sheet called “Palletainer Lookup” whereby anything that matches any numbers from the Palletainer Lookup sheet in column A is highlighted in purple on the tracker sheet in column E. i have looked at various posts and i believe its around the conditional formatting but i cannot fathom the correct formula ! Read More
Change login email or account transfer
Hello, good morning,
The email with which I created this account in TechCommunity is from my university, but I already graduated and the university disabled our email, so I don’t have it anymore. It doesn’t let me change the email as in the image I share.
How could I change the access email of this account or, in any case, how could I receive help to make a transfer of all the information, questions and achievements obtained here to a new account with a personal email? I would like to move absolutely everything so as not to lose anything.
Thank you very much for your time and help.
Hello, good morning,The email with which I created this account in TechCommunity is from my university, but I already graduated and the university disabled our email, so I don’t have it anymore. It doesn’t let me change the email as in the image I share. How could I change the access email of this account or, in any case, how could I receive help to make a transfer of all the information, questions and achievements obtained here to a new account with a personal email? I would like to move absolutely everything so as not to lose anything. Thank you very much for your time and help. Read More
1 missing folder
I have received a new PC and my Outlook has also been reinstalled. All folders, as well as inboxes and outboxes were successfully transferred, only one folder that is very important to me was not transferred or was lost. I don’t know why, even when I check my emails directly on the server, this folder is missing. When I reactivate my old PC and open Outlook, I see my missing folder. What could be the reason for this, how can I find my missing folder again? Also, my settings under “View” – “Folder pane” are set to “normal” and not to “minimized”! I would appreciate some expert help.
I have received a new PC and my Outlook has also been reinstalled. All folders, as well as inboxes and outboxes were successfully transferred, only one folder that is very important to me was not transferred or was lost. I don’t know why, even when I check my emails directly on the server, this folder is missing. When I reactivate my old PC and open Outlook, I see my missing folder. What could be the reason for this, how can I find my missing folder again? Also, my settings under “View” – “Folder pane” are set to “normal” and not to “minimized”! I would appreciate some expert help. Read More
Upcoming event: Grow on the marketplace through resellers
The Microsoft Cloud Marketplace is a great opportunity for B2B software companies to reach new customers and grow their business, and having a good understanding of it can really impact your business, building revenue through different channels.
Join this upcoming session to You learn how to increase your sales through different channels, find new ways to sell using the Microsoft Commercial Marketplace and tap into its Microsoft Reseller network.
Agenda:
Microsoft Marketplace, a Partner-to-Partner platform . Understand how to use the Marketplace to increase your sales and work with the right resellers for your software. Discover advantages and the benefits of joint-selling.
Global Expansion Through More Than 90K+ Resellers. Learn effective actions to expand your reach within the Marketplace. Oversee best practices from success cases.
Building Your Sales Channels. Discover tactics to build a strong indirect sales channel from the beginning. We’ll explain go-to-market strategies that you can start leveraging today.
Two available sessions➡ June 4th, 11:00AM BST: https://lnkd.in/eVUJBy98➡ June 4th, 5:00PM BST: https://lnkd.in/e9FUtJft Read More
Any Defender API available to get the mitigations status of exploit protection of the endpoints
I need an API to get the all the migitation status of exploit protection of the endpoints.
Below are few of the migitation types of exploit protection
Control flow guard (CFG)Data Execution Prevention (DEP)Force randomization for images (Mandatory ASLR)Randomize memory allocations (Bottom-Up ASLR)
Thanks for your time:)
I need an API to get the all the migitation status of exploit protection of the endpoints.Below are few of the migitation types of exploit protectionControl flow guard (CFG)Data Execution Prevention (DEP)Force randomization for images (Mandatory ASLR)Randomize memory allocations (Bottom-Up ASLR) Thanks for your time:) Read More
The Microsoft Cloud Marketplace is a great opportunity for B2B software companies to reach new customers and grow their business, and having a good understanding of it can really impact your business, building revenue through different channels.
Join this upcoming session to You learn how to increase your sales through different channels, find new ways to sell using the Microsoft Commercial Marketplace and tap into its Microsoft Reseller network.
Agenda:
Microsoft Marketplace, a Partner-to-Partner platform . Understand how to use the Marketplace to increase your sales and work with the right resellers for your software. Discover advantages and the benefits of joint-selling.
Global Expansion Through More Than 90K+ Resellers. Learn effective actions to expand your reach within the Marketplace. Oversee best practices from success cases.
Building Your Sales Channels. Discover tactics to build a strong indirect sales channel from the beginning. We’ll explain go-to-market strategies that you can start leveraging today.