Category: Microsoft
Category Archives: Microsoft
Unlock PC after locking it from “find my device “
Hi,
I have a win11 laptop with all updates installed.
There is a microsoft account user and another local user – both admins
For testing the lock behavior form MS online account, I locked the laptop through “find my device -> lock”.
On the laptop i attempted to sign in with both the MS account and local user account, but then I get an error stating: An administrator has restricted sign in. To sign in, make sure your device is connected to the internet, and have your administrator sign in first.
Which admin account does the message refer to? Both users on the laptop are administrators. I do not have the built in “Administrator” set up.
For the local account I get the above message immediately, for the MS account I get an option “forgot PIN” it seems to be doing something then immediately goes back to the local account login.
I expected that there is an UN-Lock setting in the online account “find my device” settings but there isn’t any.
It doesn’t make sense that you can lock a PC without having an unlock option in the same place, also
Google searches only led me to inaccurate or non-working solutions.
How can I resolve this situation?
Hi, I have a win11 laptop with all updates installed. There is a microsoft account user and another local user – both admins For testing the lock behavior form MS online account, I locked the laptop through “find my device -> lock”. On the laptop i attempted to sign in with both the MS account and local user account, but then I get an error stating: An administrator has restricted sign in. To sign in, make sure your device is connected to the internet, and have your administrator sign in first. Which admin account does the message refer to? Both users on the laptop are administrators. I do not have the built in “Administrator” set up. For the local account I get the above message immediately, for the MS account I get an option “forgot PIN” it seems to be doing something then immediately goes back to the local account login. I expected that there is an UN-Lock setting in the online account “find my device” settings but there isn’t any.It doesn’t make sense that you can lock a PC without having an unlock option in the same place, also Google searches only led me to inaccurate or non-working solutions. How can I resolve this situation? Read More
Default timezone for new user is PST not GMT
We are a charity based in the UK and when I set up a new user their timezone seems to get set as PST rather than GMT. I selected the licence location as the UK and I don’t see anywhere else I can see a location/timezone, so I have the following questions:
1. How can I ensure future new users are in the GMT timezone
2. How can I change current users in the wrong timezone?
For example, when I try and register a meeting and invite someone who is physically in the same timezone as me, the following message appears in Outlook “*user name* is in a different time zone. Use the Scheduling Assistant to find time across time zones.“
Thanks
We are a charity based in the UK and when I set up a new user their timezone seems to get set as PST rather than GMT. I selected the licence location as the UK and I don’t see anywhere else I can see a location/timezone, so I have the following questions: 1. How can I ensure future new users are in the GMT timezone2. How can I change current users in the wrong timezone? For example, when I try and register a meeting and invite someone who is physically in the same timezone as me, the following message appears in Outlook “*user name* is in a different time zone. Use the Scheduling Assistant to find time across time zones.” Thanks Read More
Getting powershell to scroll horizontally instead of word wrap
Is it possible to get powershell to horizontally scroll for long lines of text instead of having them wrap automatically to the next line?
I’m running python, and if you’re familiar with python dataframes you can think of it like a speadsheet. I’m having python output many columns, and right now it’s wrapping the output to separate lines. Think of having a sheet in excel where for more columns instead of having a horizontal scroll excel wraps it – it’s very unreadable.
Right now, I have to redirect my output to a .txt file and then open in notepad, where I can horizontally scroll without word wrap, to see the output in a readable fashion. However, if I could make powershell horizontally scroll instead of wrapping, this would save me a step.
Alternately, if not possible in powershell but possible in plain old command prompt I can run python in the command prompt. However, I’d prefer not to as I can’t SSH into remote servers from plain command prompt, and sometimes I need to run python remotely so it would be useful to do it in powershell, thanks.
Is it possible to get powershell to horizontally scroll for long lines of text instead of having them wrap automatically to the next line?I’m running python, and if you’re familiar with python dataframes you can think of it like a speadsheet. I’m having python output many columns, and right now it’s wrapping the output to separate lines. Think of having a sheet in excel where for more columns instead of having a horizontal scroll excel wraps it – it’s very unreadable.Right now, I have to redirect my output to a .txt file and then open in notepad, where I can horizontally scroll without word wrap, to see the output in a readable fashion. However, if I could make powershell horizontally scroll instead of wrapping, this would save me a step.Alternately, if not possible in powershell but possible in plain old command prompt I can run python in the command prompt. However, I’d prefer not to as I can’t SSH into remote servers from plain command prompt, and sometimes I need to run python remotely so it would be useful to do it in powershell, thanks. Read More
Sites won’t add to Collections
Hi, I don’t know when this issue arose, but currently, when I open Collections and click on “Add current page”, nothing at all happens. Anyone else got this and found a solution?
Version 126.0.2580.0 (Official build) canary (64-bit)
Hi, I don’t know when this issue arose, but currently, when I open Collections and click on “Add current page”, nothing at all happens. Anyone else got this and found a solution? Version 126.0.2580.0 (Official build) canary (64-bit) Read More
Set up Teams premium license and verify from end user teams application the license status
Hello ,
i will enable for many users the teams premium license .how to check from end user that its license is synchronized from end user teams application ?may be just check one new capability is showing from the teams application .if yes ,is there a very simple verification?
how to enforce manually the premium license in case the end used desktop teams application doesn’t get synchronized with the team premium license ?
regards
Hello , i will enable for many users the teams premium license .how to check from end user that its license is synchronized from end user teams application ?may be just check one new capability is showing from the teams application .if yes ,is there a very simple verification?how to enforce manually the premium license in case the end used desktop teams application doesn’t get synchronized with the team premium license ?regards Read More
Help with creating an Excel formula starting with a cell with text and number
Hello.
I am seeking help to create a simple formula to show ticket sales.
My starting cell has a description of the ticket category with the price of the ticket. The next cell, in the adjacent column the number of those tickets sold will be entered. I simply want to grab the number from the first cell and multiply with the number sold in a third cell. I have tried but I cant get around the text in the first cell and not an advanced user in Excel. Thank you in advance for your help.
Hello.I am seeking help to create a simple formula to show ticket sales.My starting cell has a description of the ticket category with the price of the ticket. The next cell, in the adjacent column the number of those tickets sold will be entered. I simply want to grab the number from the first cell and multiply with the number sold in a third cell. I have tried but I cant get around the text in the first cell and not an advanced user in Excel. Thank you in advance for your help. Read More
How to set up a registration page for a Teams weinbar with a choice of multiple dates and times
I want to set one webinar registration page where users have a choice of selecting different dates. I did see a post from January that is locked that said under Registration to Select Limit Registration start and end time.
But I don’t have that option under Registration. Under Registration I have Configuration and Attendee Status…and there is nothing under Configuration to Limit Registration Start and End Time.
Help!
I want to set one webinar registration page where users have a choice of selecting different dates. I did see a post from January that is locked that said under Registration to Select Limit Registration start and end time. But I don’t have that option under Registration. Under Registration I have Configuration and Attendee Status…and there is nothing under Configuration to Limit Registration Start and End Time. Help! Read More
Azure Data Factory and Trace Telemetry
All,
We have several pipelines that populate the RAW Zone from source systems and populate the Harmonized and Curated Zones using Azure Data Factory.
I can see Metrics and Logs but I’m not seeing link to the Trace telemetry. Do I have to use another tool?
Thanks,
grajee
All,We have several pipelines that populate the RAW Zone from source systems and populate the Harmonized and Curated Zones using Azure Data Factory. I can see Metrics and Logs but I’m not seeing link to the Trace telemetry. Do I have to use another tool? Thanks,grajee Read More
auto add colum date modified in foder
Please help me. I have several thousand CSV files and need to add a modified date column:
Browse the folder-> get the list of files-> open each file to check if the date modified column exists. If not, add it.
Thank you very much!!!
Please help me. I have several thousand CSV files and need to add a modified date column: Browse the folder-> get the list of files-> open each file to check if the date modified column exists. If not, add it. Thank you very much!!! Read More
How is Azure cloud service better than other cloud service platforms?
The cloud computing landscape is vast, but for businesses entrenched in the Microsoft ecosystem, Azure isn’t just a cloud platform – it’s a strategic extension of their digital foundation. Here’s why forward-thinking Microsoft leaders are choosing Azure to propel their cloud journey.
Beyond Infrastructure: A Symphony of Microsoft Services
Azure transcends mere cloud infrastructure. It seamlessly integrates with the Microsoft tools you already rely on, like Office 365 and Active Directory. This fosters a unified experience – a single sign-on for a smoother workflow and effortless data flow between your on-premises environment and the cloud.
Hybrid Harmony: A Bridge Between Two Worlds
Migrating to the cloud doesn’t have to be an all-or-nothing proposition. Azure’s strength lies in its exceptional hybrid cloud capabilities. You can leverage your existing on-premises infrastructure while seamlessly integrating with Azure’s scalable cloud resources. This creates a hybrid haven, offering flexibility and control as you migrate to the cloud at your own pace.
Global Reach, Local Impact: Powering Users Everywhere
Microsoft’s global network of data centers forms the backbone of Azure. This translates to unmatched global reach with high availability, minimizing downtime, and low latency for exceptional responsiveness – ensuring an optimal user experience regardless of location.
Empowering Developers: Speak the Language of Innovation
For Microsoft developers, Azure is a native tongue. The platform’s comprehensive suite of developer tools and services feels inherently familiar. This fosters a streamlined development process, allowing you to build and deploy cutting-edge web apps, mobile apps, and other cloud-based solutions using your existing Microsoft skillset.
Specialized Solutions: Azure Goes Beyond the Basics
While Azure excels in core cloud services, it caters to the specific needs of Microsoft users. It offers industry-leading solutions for data analytics, empowering you to unlock deeper insights from your data. For game developers, Azure PlayFab provides a robust toolkit to bring your creations to life. The Internet of Things (IoT) realm is also well-supported by Azure, allowing you to seamlessly integrate and manage your connected devices.
The Choice is Yours: A Thoughtful Approach to Cloud
Every business has a unique digital landscape. While Azure offers undeniable advantages within the Microsoft ecosystem, a thoughtful evaluation comparing cloud platforms is paramount. However, for those seeking a cloud solution that integrates seamlessly, empowers developers, and offers a future-proof path within the Microsoft world, Azure stands as a compelling thought leader’s choice.
The cloud computing landscape is vast, but for businesses entrenched in the Microsoft ecosystem, Azure isn’t just a cloud platform – it’s a strategic extension of their digital foundation. Here’s why forward-thinking Microsoft leaders are choosing Azure to propel their cloud journey. Beyond Infrastructure: A Symphony of Microsoft ServicesAzure transcends mere cloud infrastructure. It seamlessly integrates with the Microsoft tools you already rely on, like Office 365 and Active Directory. This fosters a unified experience – a single sign-on for a smoother workflow and effortless data flow between your on-premises environment and the cloud. Hybrid Harmony: A Bridge Between Two WorldsMigrating to the cloud doesn’t have to be an all-or-nothing proposition. Azure’s strength lies in its exceptional hybrid cloud capabilities. You can leverage your existing on-premises infrastructure while seamlessly integrating with Azure’s scalable cloud resources. This creates a hybrid haven, offering flexibility and control as you migrate to the cloud at your own pace. Global Reach, Local Impact: Powering Users EverywhereMicrosoft’s global network of data centers forms the backbone of Azure. This translates to unmatched global reach with high availability, minimizing downtime, and low latency for exceptional responsiveness – ensuring an optimal user experience regardless of location. Empowering Developers: Speak the Language of InnovationFor Microsoft developers, Azure is a native tongue. The platform’s comprehensive suite of developer tools and services feels inherently familiar. This fosters a streamlined development process, allowing you to build and deploy cutting-edge web apps, mobile apps, and other cloud-based solutions using your existing Microsoft skillset. Specialized Solutions: Azure Goes Beyond the BasicsWhile Azure excels in core cloud services, it caters to the specific needs of Microsoft users. It offers industry-leading solutions for data analytics, empowering you to unlock deeper insights from your data. For game developers, Azure PlayFab provides a robust toolkit to bring your creations to life. The Internet of Things (IoT) realm is also well-supported by Azure, allowing you to seamlessly integrate and manage your connected devices. The Choice is Yours: A Thoughtful Approach to CloudEvery business has a unique digital landscape. While Azure offers undeniable advantages within the Microsoft ecosystem, a thoughtful evaluation comparing cloud platforms is paramount. However, for those seeking a cloud solution that integrates seamlessly, empowers developers, and offers a future-proof path within the Microsoft world, Azure stands as a compelling thought leader’s choice. Read More
training data model from SQL server text columns
I want to create a Q & A based on the data we have already collected while serving our clients (people with disabilities). There is a text field where they present their issue. There is another text field where we record the service we provided and some of the possible solutions. There are other selection type/lookup fields that can help us categorize/tag the problem/solution text.
How can I train Azure AI service so that it can provide the most likely solution based on any new service requests received from our clients? As you can tell, I am fairly new to the AI world. Therefore I’m open to any new ideas/technologies that can help achieve this objective. Any help is appreciated.
Thank you.
I want to create a Q & A based on the data we have already collected while serving our clients (people with disabilities). There is a text field where they present their issue. There is another text field where we record the service we provided and some of the possible solutions. There are other selection type/lookup fields that can help us categorize/tag the problem/solution text. How can I train Azure AI service so that it can provide the most likely solution based on any new service requests received from our clients? As you can tell, I am fairly new to the AI world. Therefore I’m open to any new ideas/technologies that can help achieve this objective. Any help is appreciated. Thank you. Read More
Request: Manage Apple Vision Pro with Intune MDM
Hi,
At our company, some teams are working with Apple Vision Pro because they are hoping to find new technical solutions for the business. We would also like to include Apple Vision Pro in the management of our other mobile devices via Intune MDM.
Since Apple has also offered an MDM interface for Apple Vision Pro with the visionOS 1.1 update, the glasses could in principle also be managed by an MDM, but the MDM must also support the glasses.
Hence my question: When will this be possible via Intune MDM? As a company, we recently switched to Intune MDM with over 110,000 devices (both mobile devices and fat clients) and we are confident that Microsoft will also support new technical products (such as the Apple Vision Pro).
Hi, At our company, some teams are working with Apple Vision Pro because they are hoping to find new technical solutions for the business. We would also like to include Apple Vision Pro in the management of our other mobile devices via Intune MDM.Since Apple has also offered an MDM interface for Apple Vision Pro with the visionOS 1.1 update, the glasses could in principle also be managed by an MDM, but the MDM must also support the glasses.Hence my question: When will this be possible via Intune MDM? As a company, we recently switched to Intune MDM with over 110,000 devices (both mobile devices and fat clients) and we are confident that Microsoft will also support new technical products (such as the Apple Vision Pro). Read More
Transposing Absolute References
I would like to drag a sum down a column, essentially creating field sums for a large number of records. Once dragged down, I want to paste-special transpose. The final result should be a row of sums, but the sums should row sums from above. I could turn all the sums into absolute references first, but that is tedious. Somehow, I would like to highlight multiple cells and ask Excel to turn them all into absolutely references at the same time. Can this be done?
I would like to drag a sum down a column, essentially creating field sums for a large number of records. Once dragged down, I want to paste-special transpose. The final result should be a row of sums, but the sums should row sums from above. I could turn all the sums into absolute references first, but that is tedious. Somehow, I would like to highlight multiple cells and ask Excel to turn them all into absolutely references at the same time. Can this be done? Read More
Google Premier Club
Hello from resercher Professional.
Present you business plan for Google Premier Partner Club.
Join us and bring your professional experience with Microsoft Azure Organisation and Google Legal Department.
Integration for Special Event on Ignite
Hello from resercher Professional.Present you business plan for Google Premier Partner Club.Join us and bring your professional experience with Microsoft Azure Organisation and Google Legal Department. Integration for Special Event on Ignite Read More
New learning
https://learn.microsoft.com/training/challenges?id=3eec2027-867a-4787-8e87-bc6ec22953e9&WT.mc_id=cloudskillschallenge_3eec2027-867a-4787-8e87-bc6ec22953e9&wt.mc_id=studentamb_287632 Read More
Join this challenge
https://learn.microsoft.com/training/challenges?id=61f56e0c-17e2-48ca-8e81-e6e79180a0de&WT.mc_id=cloudskillschallenge_61f56e0c-17e2-48ca-8e81-e6e79180a0de&wt.mc_id=studentamb_280411 Read More
Error being returned summing field
Hi folks,
In the following formula:
=SUMIFS((Sheet1!$R$5:$R$1000, D24)=SUMIF(Sheet1!$O$5:$O$1000,”>0″))
colR is the week number
D24 refers to week number 19
colO is the amount sold
The formula I am trying looks first to find the matching field number and then sum the the total of colO where the amount of each week number found is greater than 0
For example D24 has found three week 19’s in colO two of the records are greater than 0 and one record less than 0
The formula should only sum those records that are greater than 0
Thank you for your interest!
Hi folks, In the following formula:=SUMIFS((Sheet1!$R$5:$R$1000, D24)=SUMIF(Sheet1!$O$5:$O$1000,”>0″)) colR is the week numberD24 refers to week number 19colO is the amount sold The formula I am trying looks first to find the matching field number and then sum the the total of colO where the amount of each week number found is greater than 0 For example D24 has found three week 19’s in colO two of the records are greater than 0 and one record less than 0 The formula should only sum those records that are greater than 0 Thank you for your interest! Read More
License for External Users in D365F&O
Hi,
Do we need a license to use the vendor collaboration in D365F&O. previously we didnt need any license.
looking for confirmations.
Hi, Do we need a license to use the vendor collaboration in D365F&O. previously we didnt need any license. looking for confirmations. Read More
OneDrive – Mac OS Ventura – iMac 3.8 GHz Quad-Core Intel Core i5
Yesterday, at around 10AM EDT, OneDrive crashed on my Mac. For the past 20 hours I have tried to restore the OneDrive app on the Mac. I have installed and reinstalled the app. I have rebooted the gateway. I have more than enough capacity (only using .4 of 1TB). Even though I have uninstalled the app it is still showing in the Systems-General-Log In Items, which I have turned off. I can access my OneDrive on my iPhone and my iPad, but the app will no longer run on my iMac. After I install it the OneDrive icon appears in the Menu Bar at the top, it just flashes on and off and prevents the iMac from functioning properly; it appears it trying to update and keeps taking control of the processor. Any ideas are greatly appreciated.
Yesterday, at around 10AM EDT, OneDrive crashed on my Mac. For the past 20 hours I have tried to restore the OneDrive app on the Mac. I have installed and reinstalled the app. I have rebooted the gateway. I have more than enough capacity (only using .4 of 1TB). Even though I have uninstalled the app it is still showing in the Systems-General-Log In Items, which I have turned off. I can access my OneDrive on my iPhone and my iPad, but the app will no longer run on my iMac. After I install it the OneDrive icon appears in the Menu Bar at the top, it just flashes on and off and prevents the iMac from functioning properly; it appears it trying to update and keeps taking control of the processor. Any ideas are greatly appreciated. Read More