Tag Archives: microsoft
Graph Powershell SignInActivity.LastSignInDateTime very slow
Hello,
I have a list of guest users Im trying to audit and one of tasks would be getting a last sign in date so we can remove the oldest as usual.
There is one script that proved to be working the best for me, but execution is very slow for the users that probably do not have a last sign in date due to they are a very old abandoned guest account or did not accept the invitation. It gets “stuck” on those for a while which slows down the process and going over significant amount of users proves unreasonably long. It gets over those eventually and continues, but I cant run the script for so long for every user that does not have last sign in date saved.
Is there a way to make this faster or maybe skip the ones that take the longest? I think there may be a way to improve this method, but Im not that proficient with Graph and Powershell, so seeking advice.
Here is the script:
Hello,I have a list of guest users Im trying to audit and one of tasks would be getting a last sign in date so we can remove the oldest as usual. There is one script that proved to be working the best for me, but execution is very slow for the users that probably do not have a last sign in date due to they are a very old abandoned guest account or did not accept the invitation. It gets “stuck” on those for a while which slows down the process and going over significant amount of users proves unreasonably long. It gets over those eventually and continues, but I cant run the script for so long for every user that does not have last sign in date saved. Is there a way to make this faster or maybe skip the ones that take the longest? I think there may be a way to improve this method, but Im not that proficient with Graph and Powershell, so seeking advice. Here is the script:# Connect to Microsoft GraphConnect-MgGraph -Scopes “Directory.Read.All”, “AuditLog.Read.All”$users = Import-Csv -Path “C:TempGuestUsers.csv”$signininfo = @()#Counter$i=1#Loop for all usersForeach ($u in $users) { $signininfo += Get-MgUser -UserId $u.Id -Property displayName,userPrincipalName,usertype,accountenabled,signInActivity,createdDateTime | select displayName,userPrincipalName,usertype,accountenabled,createdDateTime,@{Name = ‘LastSignInDateTime’; Expression = {$_.SignInActivity.LastSignInDateTime}} #Counter $i $i++}$signininfo |Export-Csv -Path C:TempSignininfo.csv -NoTypeInformation -Encoding UTF8 Read More
How much time it takes to install Windows 11?
Waited for one hour and the installation is still in progress.
Waited for one hour and the installation is still in progress. Read More
Recommend a safe YouTube videos downloader for PC Windows 11?
I’m currently working on a project and need an opening video to grab the audience’s attention. I found a very suitable video on YouTube, but I need to download it for use in the presentation. The problem is that I don’t have a safe YouTube videos downloader at hand, and I’m using Windows 11. Here I would like to ask if you have any recommended YouTube video download software, preferably one that you have actually used and can download videos stably and quickly. I hope to get your help, thank you!
I’m currently working on a project and need an opening video to grab the audience’s attention. I found a very suitable video on YouTube, but I need to download it for use in the presentation. The problem is that I don’t have a safe YouTube videos downloader at hand, and I’m using Windows 11. Here I would like to ask if you have any recommended YouTube video download software, preferably one that you have actually used and can download videos stably and quickly. I hope to get your help, thank you! Read More
Help in Power Automate
Dear Experts,
I have a flow where my SharePoint is converted to HTML and into pdf using encodian. Now after converting to PDF I want to attach this file into the item in the list. Is it possible and how. I tried add attachment and all and its not wokring.
Thnaks
Dear Experts, I have a flow where my SharePoint is converted to HTML and into pdf using encodian. Now after converting to PDF I want to attach this file into the item in the list. Is it possible and how. I tried add attachment and all and its not wokring. Thnaks Read More
FIDO2 as MFA Authenticator
Hello all,
I am trying to generate a report that will tell me the type of FIDO2 passkeys that users are using. Anyone have similar experience or an idea of which field from the sign-in logs I can use to generate the report?
Thanks in advance.
Hello all, I am trying to generate a report that will tell me the type of FIDO2 passkeys that users are using. Anyone have similar experience or an idea of which field from the sign-in logs I can use to generate the report?Thanks in advance. Read More
What Are the Steps to Fix QuickBookѕ Error PS034 During Pay-roll Updates?
I’m encountering QuickBookѕ Error PS034 while trying to update my pay-roll. The error prevents the update from completing, and I’m unsure how to resolve it. I’ve attempted basic troubleshooting like restarting the software and checking my internet connection, but the issue persists. Can someone guide me through the steps to fix this error and successfully complete my pay-roll updates?
I’m encountering QuickBookѕ Error PS034 while trying to update my pay-roll. The error prevents the update from completing, and I’m unsure how to resolve it. I’ve attempted basic troubleshooting like restarting the software and checking my internet connection, but the issue persists. Can someone guide me through the steps to fix this error and successfully complete my pay-roll updates? Read More
Trusted launch enabled not showing not enabled
Hi all,
I have enabled Trusted launch however the machine is still getting the message:
Shows enabled here:
Have I done something wrong? How do I fix this?
Hi all, I have enabled Trusted launch however the machine is still getting the message: Shows enabled here: Have I done something wrong? How do I fix this? Read More
pc mden ses gelmiyor
güncellemeden sonra pc den ses gelmiyor ve düzeltemedim
güncellemeden sonra pc den ses gelmiyor ve düzeltemedim Read More
Exchange On Premise – MTA-STS protocol
Hi,
I read Enhancing mail flow with MTA-STS | Microsoft Learn and only Exchange Online is discussed.
Exchange On Premise doesn’t seem to be mentioned.
So I have two questions:
– Can I consider that MTA-STS protocol is also supported by Exchange On Premise since it is supported by Exchange Online?
– If necessary, what Powershell command should I do to confirm this?
Thank you in advance for your answers.
François.
Hi, I read Enhancing mail flow with MTA-STS | Microsoft Learn and only Exchange Online is discussed. Exchange On Premise doesn’t seem to be mentioned. So I have two questions: – Can I consider that MTA-STS protocol is also supported by Exchange On Premise since it is supported by Exchange Online?- If necessary, what Powershell command should I do to confirm this? Thank you in advance for your answers. François. Read More
Deprecation of Virtual Network Injection for Azure Data Explorer
We are announcing the deprecation of the feature of Virtual Network Injection for Azure Data Explorer. This feature allows customers to inject their Azure Data Explorer cluster into their own virtual network and control the inbound and outbound network traffic. However, this feature has limitations and challenges, such as:
Customers face a lot of maintenance work, because of things like updating firewall lists of FQDNs or using public IP addresses in a restricted and secured environment.
Customers are responsible for ensuring that the intra-cluster communication is working.
It requires a dedicated subnet for each cluster, which can lead to subnet exhaustion and increased management overhead.
It does not support cross-region or cross-subscription scenarios, which can limit the scalability and flexibility of the data platform.
Required actions
As a result, we are deprecating this feature and recommending customers to move as soon as possible to a private endpoint based network security architecture. A private endpoint is a network interface that connects you privately and securely to a service powered by Azure Private Link. Private endpoint uses a private IP address from your virtual network, effectively bringing the service into your virtual network. With private endpoints, you can:
Connect securely to Azure Data Explorer from your virtual network or from on-premises networks via VPN or ExpressRoute.
Access Azure Data Explorer from different regions or subscriptions without any public internet exposure.
Use all the Azure Data Explorer features without any limitations or trade-offs.
Reduce the network complexity and management overhead by using a single subnet for multiple clusters and services.
To help you with the migration, we have created a migration process (close to zero downtime).
We understand that this migration may require effort and coordination from your side, and we are here to support you along the way. We have scheduled office hours to answer your questions and provide guidance on the migration process. You can register for the office hours using this form. You can also reach out to us via email at ADXVnetDeprecation@microsoft.com.
Timelines
Please note the following important dates and actions regarding the migration:
Effective immediately, no new customers will be able to create virtual network injected clusters. Existing customers can continue to use their clusters until the migration deadline.
Starting from February 1, 2025, all running virtual network injected clusters will be stopped. Customers who have not migrated by then will not be able to start them until they complete the migration process.
To avoid any disruption, we strongly recommend that you migrate your clusters as soon as possible. You can follow the migration steps outlined in this document. If you encounter any issues or need assistance, please contact us at ADXVnetMigration@microsoft.com or join our office hours.
We appreciate your understanding and cooperation as we deprecate the Virtual Network Injection feature and move to a more secure, scalable, and feature-rich network security architecture for Azure Data Explorer.
Microsoft Tech Community – Latest Blogs –Read More
With Microsoft, good security is good business
Working in technology today means working securely. This is especially true with B2B apps, where cyberthreats can mean costly fixes or loss of reputation.
To help your commitment to security, Microsoft has redoubled efforts on integrating security features at every step. This will help your team design securely, sell with confidence, and delight your customers.
Recently, at Microsoft Build in May, several sessions focused on the newest features for integrating security and increasing customer trust.
Additional resources to learn more about security
Watch some of the security sessions from Microsoft Build 2024. This targeted group of sessions will catch you up on the latest innovations from Microsoft across all teams:
Build identity into your apps within minutes! Explore how to quickly create applications either directly from the Microsoft Entra portal or within developer tools such as Visual Studio Code.
Secure your AI application transformation with Microsoft Security: Learn how Microsoft’s new cloud security innovations extend security posture management and threat protection to enterprise-built AI applications.
Securing your Intelligent Applications with Microsoft Entra: Learn to automatically set up authentication for your intelligent apps and how to add access control to your app & data.
If you want to browse all of the sessions, here are all the organized security sessions given at Microsoft Build 2024.
Visit Microsoft Security 101, select a filter, and start learning about the vast Microsoft security portfolio. Learn from the ground up in bite-size modules that walk you from definition to implementation.
Use app advisor on ISV Hub, a curated, self-serve, guided experience for any ISV that helps you understand business opportunities with Microsoft and the marketplace, including the ability to integrate security at any phase of your development. Stop looking for the right materials and start building your app, streamlining your publishing, and scaling your sales growth.
Enjoy these resources to help you build securely and help protect your data and earn your customers’ trust.
Microsoft Tech Community – Latest Blogs –Read More
Bluetooth issue
I am having issues with my Bluetooth wherein it automatically turns off and on. I have tried downloading drivers from OEM however issue still persists.
Build version: 22635.3930
I am having issues with my Bluetooth wherein it automatically turns off and on. I have tried downloading drivers from OEM however issue still persists. Build version: 22635.3930 Read More
Unable to disable SSPR for Administrators
According to this link I can disable SSPR for Administrators.
However, upon attempting to do so I am met with the following error.
S C:WindowsSystem32> Update-MgPolicyAuthorizationPolicy -AllowedToUseSspr:$false
Update-MgPolicyAuthorizationPolicy_UpdateExpanded: Insufficient privileges to complete the operation.
Status: 403 (Forbidden)
ErrorCode: Authorization_RequestDenied
Date: 2024-07-22T16:28:11
According to this link I can disable SSPR for Administrators.https://learn.microsoft.com/en-us/entra/identity/authentication/concept-sspr-policy?WT.mc_id=Portal-Microsoft_AAD_IAM#administrator-reset-policy-differencesHowever, upon attempting to do so I am met with the following error. S C:WindowsSystem32> Update-MgPolicyAuthorizationPolicy -AllowedToUseSspr:$falseUpdate-MgPolicyAuthorizationPolicy_UpdateExpanded: Insufficient privileges to complete the operation.Status: 403 (Forbidden)ErrorCode: Authorization_RequestDeniedDate: 2024-07-22T16:28:11 Read More
Update Stack Package – (Version 922.415.111.0)
I have been trying to update this update for the last 3 days, but it is not updating. I am getting the same error again and again. How can I fix it? It is not downloading more than 1% every time, due to which I am not able to get any more updates. This update came on my system on the day when the ‘Blue Screen of Death’ problem occurred on the Microsoft server, but since that day, it has not been updating on my system.
@microsoft I have been trying to update this update for the last 3 days, but it is not updating. I am getting the same error again and again. How can I fix it? It is not downloading more than 1% every time, due to which I am not able to get any more updates. This update came on my system on the day when the ‘Blue Screen of Death’ problem occurred on the Microsoft server, but since that day, it has not been updating on my system. Read More
Micfrosoft Outlook Calendar Problem
I hope someone can help a tech dinosaur!
For many years I have used Outlook to bring together my main Aol.com email account plus a small number of auxilliary Aol.Co.UK and Gmail email accounts for ease of display of all of them in one place.
Recently I set up my first ever Outlook.com email account and added it to Outlook.
The calendar feature was previously tied to my main email account and I found it ideal for an electronic diary. For some reason the calendar has switched to the Outlook.com email account and all of my diary entries have disappeared.
How can I get back to old position of a tie to my main email account – I would hate to lose my diary entries!
I hope someone can help a tech dinosaur! For many years I have used Outlook to bring together my main Aol.com email account plus a small number of auxilliary Aol.Co.UK and Gmail email accounts for ease of display of all of them in one place.Recently I set up my first ever Outlook.com email account and added it to Outlook.The calendar feature was previously tied to my main email account and I found it ideal for an electronic diary. For some reason the calendar has switched to the Outlook.com email account and all of my diary entries have disappeared.How can I get back to old position of a tie to my main email account – I would hate to lose my diary entries! Read More
Using/saving/re-opening CSV files in Excel – truncated digits
Hello,
When editing a CSV file in Excel (note that the original data I receive from others is in Excel format, but has to be published in CSV format), I use the “format cells” in Excel and select number of decimal places, save file, then re-open the file – the original digits are actually truncated instead of just hidden. I want to keep all the digits, but just have the viewer/user see 2 (or 4, or whatever) decimal places (however, they should see all the digits when they click on the cell).
Does anyone know how to preserve all the original digits, but only have the viewer/user see 2 (or 4, etc…) digits for neatness/uniformity sake?
Example attached.
Thanks!
Hello,When editing a CSV file in Excel (note that the original data I receive from others is in Excel format, but has to be published in CSV format), I use the “format cells” in Excel and select number of decimal places, save file, then re-open the file – the original digits are actually truncated instead of just hidden. I want to keep all the digits, but just have the viewer/user see 2 (or 4, or whatever) decimal places (however, they should see all the digits when they click on the cell).Does anyone know how to preserve all the original digits, but only have the viewer/user see 2 (or 4, etc…) digits for neatness/uniformity sake?Example attached.Thanks! Read More
Outlook mail Receiving and Sending stopped 22nd July 2024
Hi Team,
As I’m for an organization, and I’ve noticed that my outlook mails got stopped sending or receiving either.
The mail is successfully sent from my end but hasn’t been received from other end.
Hi Team, As I’m for an organization, and I’ve noticed that my outlook mails got stopped sending or receiving either. The mail is successfully sent from my end but hasn’t been received from other end. Read More
Trying to Build Truly Non-Persistent Machines
I’m trying to test a setup that will be used for public machines in a library setting through AVD and thin clients. To do this, I’ve built an AVD pool, which (according to documentation) is supposed to be completely non-persistent. However, I’ve noticed that if a user logs in and makes changes (creates files, changes settings, etc.) and then logs out, if they connect to the same virtual machine the next time they log in, their changes remain.
This isn’t non-persistent as advertised, and is definitely a problem. Since the machines this is meant to be testing for will have potentially hundreds of users logging in, changes cannot remain when they log off. Does anyone know of a way to actually make these machines non-persistent?
An important note: We won’t be able to utilize 3rd-party software like Nerdio (which I see a lot of people recommend, and which I wish I could use) because we’re a public/government organization, and there’s just no budget for a tool like that.
I’m trying to test a setup that will be used for public machines in a library setting through AVD and thin clients. To do this, I’ve built an AVD pool, which (according to documentation) is supposed to be completely non-persistent. However, I’ve noticed that if a user logs in and makes changes (creates files, changes settings, etc.) and then logs out, if they connect to the same virtual machine the next time they log in, their changes remain.This isn’t non-persistent as advertised, and is definitely a problem. Since the machines this is meant to be testing for will have potentially hundreds of users logging in, changes cannot remain when they log off. Does anyone know of a way to actually make these machines non-persistent?An important note: We won’t be able to utilize 3rd-party software like Nerdio (which I see a lot of people recommend, and which I wish I could use) because we’re a public/government organization, and there’s just no budget for a tool like that. Read More
Change a custom color palette
Afternoon all,
An ex-employee set up our SharePoint site with our corporate colours, however, he’s managed to get the rollover background colour to be the same as the text and our buttons have a red background with navy text, both are unreadable.
I can not for the life of me find out how to edit just these two little bits; the rest of the site looks great.
Any help would be fantastic, thanks.
Ed
Afternoon all, An ex-employee set up our SharePoint site with our corporate colours, however, he’s managed to get the rollover background colour to be the same as the text and our buttons have a red background with navy text, both are unreadable. I can not for the life of me find out how to edit just these two little bits; the rest of the site looks great. Any help would be fantastic, thanks.Ed Read More