Category: Microsoft
Category Archives: Microsoft
Company portal says rooted device but it’s not – Android
Hi everyone,
We came across a situation where one of our Android user is not able to access Outlook and Teams due to rooted device. We configured only App protection (MAM) policy in Intune and blocked access from Jailbroken/rooted devices. Only the MAM policy as been applied on the device and the device is not enrolled with Intune. So far, we have followed below troubleshooting,
Rejoined the device again, however after sometime, the error will be appeared again.Check whether the device is rooted or not (Go to Settings > About phone > Status Information > Phone Status). Phone status says official. I believe this means not a rooted device.
Below is the error message from the company portal
Device Status in Azure AD (Not enroll with Intune)
I would appreciate if anyone can help me whether I have anything else try out before I create a support case with Microsoft.
Thanks,
Dilan
Hi everyone, We came across a situation where one of our Android user is not able to access Outlook and Teams due to rooted device. We configured only App protection (MAM) policy in Intune and blocked access from Jailbroken/rooted devices. Only the MAM policy as been applied on the device and the device is not enrolled with Intune. So far, we have followed below troubleshooting, Rejoined the device again, however after sometime, the error will be appeared again.Check whether the device is rooted or not (Go to Settings > About phone > Status Information > Phone Status). Phone status says official. I believe this means not a rooted device.Below is the error message from the company portal Device Status in Azure AD (Not enroll with Intune) I would appreciate if anyone can help me whether I have anything else try out before I create a support case with Microsoft. Thanks,Dilan Read More
GPT-4o mini: now available on Azure AI
GPT-4o mini by OpenAI is now available on Azure AI. This new model is touted to be smarter and more cost-effective than its predecessor, GPT-3.5 Turbo, boasting an 82% score on the MMLU compared to 70%, and offering a 60% cost reduction. It features a 128K context window and improved multilingual capabilities, enhancing quality across various languages.
GPT-4o mini supports text processing on Azure AI with image, audio, and video capabilities to be added later. It is particularly beneficial for streaming scenarios like assistants, code interpreters, and retrieval services due to its speed and efficiency. The model’s integration with GitHub Copilot has demonstrated remarkable speed, providing code completion suggestions almost instantaneously.
Azure AI has also introduced updates to the Azure OpenAI Service, focusing on safety, data residency, and pay-as-you-go availability. Safety features such as prompt shields and protected material detection are now enabled by default. The service now offers data residency in all 27 regions, including the newly launched region in Spain, ensuring compliance with customers’ unique requirements.
The global pay-as-you-go deployment option for GPT-4o mini is now generally available, offering competitive pricing and high throughput limits. Customers can upgrade to newer models without changing regions, and the service promises 99.99% availability with industry-leading speed.
Finally, Azure AI is investing in efficiencies for AI workloads, introducing fine-tuning for GPT-4o mini and reduced hosting charges.
Check out this blog to learn more: OpenAI’s fastest model, GPT-4o mini is now available on Azure AI | Microsoft Azure Blog
Are you already Azure AI in your app development? Comment below to let us know what additional resources would be helpful on your AI journey!
GPT-4o mini by OpenAI is now available on Azure AI. This new model is touted to be smarter and more cost-effective than its predecessor, GPT-3.5 Turbo, boasting an 82% score on the MMLU compared to 70%, and offering a 60% cost reduction. It features a 128K context window and improved multilingual capabilities, enhancing quality across various languages.
GPT-4o mini supports text processing on Azure AI with image, audio, and video capabilities to be added later. It is particularly beneficial for streaming scenarios like assistants, code interpreters, and retrieval services due to its speed and efficiency. The model’s integration with GitHub Copilot has demonstrated remarkable speed, providing code completion suggestions almost instantaneously.
Azure AI has also introduced updates to the Azure OpenAI Service, focusing on safety, data residency, and pay-as-you-go availability. Safety features such as prompt shields and protected material detection are now enabled by default. The service now offers data residency in all 27 regions, including the newly launched region in Spain, ensuring compliance with customers’ unique requirements.
The global pay-as-you-go deployment option for GPT-4o mini is now generally available, offering competitive pricing and high throughput limits. Customers can upgrade to newer models without changing regions, and the service promises 99.99% availability with industry-leading speed.
Finally, Azure AI is investing in efficiencies for AI workloads, introducing fine-tuning for GPT-4o mini and reduced hosting charges.
Check out this blog to learn more: OpenAI’s fastest model, GPT-4o mini is now available on Azure AI | Microsoft Azure Blog
Are you already Azure AI in your app development? Comment below to let us know what additional resources would be helpful on your AI journey! Read More
FSLogix is now part of the Microsoft Management Customer Connection Program (MM CCP)!
FSLogix is a complex tool that is used in a wide range of environments. Testing and validating these environments is extremely challenging as an engineering team and we rely on customers like you to help us test, validate and ensure our product is meeting the needs of all our customers.
FSLogix is partnering with the Microsoft Management Customer Connection Program (MM CCP) to provide customers and professionals with a forum to join exclusive conversations, feedback and access to future versions of the product. FSLogix is part of the Windows Cloud Experience (WCX) organization where you can find AVD, Windows 365, and the new ‘FSLogix and user profile discussion‘ channels.
Join the MM CCP today!
MM CCP is a mutually beneficial program where members have engagement opportunities and access to member exclusive information and other benefits with participating MM CCP Communities like:
Data Security and Privacy Customer Connection Program
Microsoft Purview products: Information Protection, Data Loss Prevention, Insider Risk Management, Microsoft Purview Data Governance, eDiscovery, Audit, Data Lifecycle Management, Records Management and Microsoft Priva
Security Connection Program
SIEM & XDR, CNAPP (Defender for Cloud), & Network Security
Management Customer Connection Program
Microsoft Intune product family, Windows and Windows Cloud Experiences (WCX)
Microsoft Entra Advisors
Microsoft Entra Permissions Management, Microsoft Verified ID, Identity Advisors, Identity Developer Advisors, Identity in Education, Azure B2C Advisors
Copilot for Security Customer Connection Program
Participation in MCCP is voluntary. To opt-out of MCCP at any time, visit: https://aka.ms/CCPOptOut
Microsoft Tech Community – Latest Blogs –Read More
Use cases of Advanced Network Observability for your Azure Kubernetes Service clusters
Introduction
Advanced Network Observability is the inaugural feature of the Advanced Container Networking Services (ACNS) suite bringing the power of Hubble’s control plane to both Cilium and Non-Cilium Linux data planes. It unlocks Hubble metrics, Hubble’s command line interface (CLI) and the Hubble user interface (UI) on your AKS clusters providing deep insights into your containerized workloads. Advanced Network Observability empowers customers to precisely detect and root-cause network related issues in a Kubernetes cluster.
Prerequisites
This blog will focus on ACNS enabled on Azure Kubernetes Service cluster with Azure Managed Prometheus and Grafana enabled.
Before setting up AKS, ensure that you have an Azure account and subscription, with permissions that allow you to create resource groups and deploy AKS clusters. Follow instructions in this guide to setup an AKS cluster and run the scenarios below.
High level steps:
Create AKS Cluster
Enable Advanced Container Networking Services on this cluster
Create and attach Azure managed Prometheus and Grafana
Install Hubble CLI on your local machine following these instructions.
Deploy Hubble UI Component on this cluster following these instructions.
Concepts
Cilium: Cilium is an open source, cloud native solution for providing, securing, and observing network connectivity between workloads, fueled by the revolutionary Kernel technology eBPF.
Hubble: Hubble is a fully distributed networking and security observability platform. It is built on top of Cilium and eBPF to enable deep visibility into the communication and behavior of services as well as the networking infrastructure in a completely transparent manner.
Retina: Retina is a cloud-agnostic, open-source eBPF based Kubernetes Network Observability platform, it is the technology behind advanced network observability in non-Cilium Linux nodes.
Customer Scenario 1: Domain Name Server (DNS) intermittent failures
Ruling out Domain Name Server (DNS) issues is the first step for any major network issue. Having powerful visibility into Domain Name Server (DNS) requests/responses at a detailed pod level enables faster incident resolution and cloud cost optimization. With Advanced Observability, customers can not only view requests and responses by type and fully qualified domain name (FQDN), but they can also see error codes returned to requests, IP addresses returned in response for a given request and much more.
Retina uses eBPF programs to examine every DNS request and response packet in the Linux kernel and pass the packet and its metadata to the user space program. Here, the metadata is further processed to extract returned IPs in DNS response packets. All this metadata is used to produce relevant metrics that show status both at node level and pod level.
This is an example of how Advanced metrics can help you. DNS latency, errors and timeouts are hard to troubleshoot and can cause severe application issues. But our dashboards make it easier for DevOps engineers to detect and fix DNS problems. The dashboard panel below shows a sudden rise in missing DNS responses within the cluster, the most common DNS errors, and which nodes have the most errors.
The dashboard shows a summary of all DNS activities in the cluster – what kinds of queries lack responses, what’s the most common query and most common response. All this information can help administrators prevent possible problems with usage and security, and act to reduce them.
Customer Scenario 2: Network Policy Drops at Pod level
Debugging network policies in large, intricate clusters with multiple namespaces can be a daunting task, especially when there are numerous network policies per namespace. To address this challenge, the network policy addon leverages eBPF in Linux to collect crucial information about dropped packets. By attaching kprobes at various critical locations in the Linux kernel, such as the netfilter drop function and the netfilter nat function, the network policy addon effectively determines if a packet is being dropped.
When a dropped packet is detected, the associated eBPF programs generate an event that includes packet metadata, along with the drop reason and location. This event is then processed by a userspace program, which parses the data and converts it into Prometheus metrics. These metrics offer valuable insights into the dropped packets, aiding in the identification and resolution of network policy configuration issues.
Let’s walk through an example and see how pod-level metrics and flows can help debug packet drops in a cluster. Below is a snapshot of a workload running in AKS cluster. The panel shows a heatmap of the pods running as part of a deployment, and the number of packets originating from those pods being dropped. This panel is very useful, because this lets administrations know there is a problem in real-time, and the pod being impacted. The panel also immediately shows the reason for the drop – “policy_denied”, indicating the drops are happening because of a networking policy applied in the cluster.
To dig deeper, we can leverage the Hubble CLI tool to inspect flows in real time. The below snapshot shows how we can filter traffic using namespace and type. Hubble cli will show the source and destination pods of the packets being dropped, helping us narrow down the policy even further.
Another tool user can use is the Hubble UI, which shows traffic flows occurring for a namespace. Below, we see the pods in agnhost namespace interacting with other pods in the same namespace as well as pods in different namespaces. Also, it’s receiving packets from outside the cluster. The UI also shows which packets are getting dropped, and the details include source and destination pod names, as well as pod and namespace labels. Using this information, we can dig through network policies applied in the cluster and identify the offending policy quickly.
Customer Scenario 3: Imbalance of traffic for pods within a workload
Pods fronted by a service expects an even distribution of traffic when a request reaches the service. However, that may not always be the case. Faulty settings can introduce subtle distribution bugs, and this may only manifest when the application performance degrades even when scaling up the workload.
Retina deploys eBPF programs that attaches itself at various interfaces in the Linux kernel and observes all TCP/UDP packets flowing through the node. This allows Retina to generate rich pod level L4 metrics which can show, among other things, traffic distribution amongst all the pods under a workload (deployment for example).
The panel below shows the heatmap of incoming and outgoing traffic of pods under a workload. As evident, one of the three pods is receiving a higher volume of traffic that the other two. Administrators can be proactive and help mitigate this issue before application performance degrades and impacts end users.
Conclusion:
ACNS with advanced network observability enables deep insights into container networks and enhances the operability of AKS. This blog has explored its capabilities through real-world customer scenarios, demonstrating its capabilities in tackling common network challenges. We’d also love to hear how enhanced observability can help make your deployment scenarios easier in a comment below.
Resources:
For more info about ACNS please visit (https://learn.microsoft.com/en-us/azure/aks/advanced-container-networking-services-overview).
To set up Advanced Network Observability visit (https://learn.microsoft.com/en-us/azure/aks/advanced-network-observability-cli?tabs=non-cilium).
Pricing for ACNS is here (https://azure.microsoft.com/en-us/pricing/details/azure-container-networking-services/ ).
Microsoft Tech Community – Latest Blogs –Read More
Changing No of days for sending email to end users caused re-generating notification again.
Hi All,
We have couple of compliance polices setup in Intune and we required to increase “Send email to end user” under actions for noncompliance from 1 day to 3 days temporarily. However, it caused to resend notification to all non-complaint devices at the moment and as a result it has opened duplicate IT service tickets as we setup open a new case whenever end user get a notification.
Now, I am wondering how we could bypass regenerating this notification when we change the notification setting back to 1 day again.
I would appreciate the help if anyone come across this or know this behavior in Intune.
Below is the image for notification setting we changed:
Thanks in advance,
Dilan
Hi All, We have couple of compliance polices setup in Intune and we required to increase “Send email to end user” under actions for noncompliance from 1 day to 3 days temporarily. However, it caused to resend notification to all non-complaint devices at the moment and as a result it has opened duplicate IT service tickets as we setup open a new case whenever end user get a notification. Now, I am wondering how we could bypass regenerating this notification when we change the notification setting back to 1 day again. I would appreciate the help if anyone come across this or know this behavior in Intune. Below is the image for notification setting we changed: Thanks in advance,Dilan Read More
Limiting Team invitations to specific members
Dear Microsoft,
Within our organization, the ability to limit teams invites is a must for meetings. When we create a meeting, without doing so, optional members are added to the teams meeting. You can imagine that when a team meeting is created and 200 people are a member of a team but only 5 are invited, that a meeting can quickly become unproductive.
We’ve also noted that using private channels does not allow you to create meetings. And, in fact, using a private channel would be ideal when you don’t want 200+ personnel invited to a meeting that don’t belong.
Can we suggest two feature updates?
1. Prevent Teams from broadcasting to the whole team. Only invite the required personnel. Optional members should be just that, only receive the invite if you were included on the Optional field. Users would be able to see if they’re optional or not.
2. Allow Teams to utilize private channels for more meeting control or to allow for meetings which require extreme privacy (i.e., investigations, meetings about personal health discussions, etc.).
Thank you,
TC
Dear Microsoft,Within our organization, the ability to limit teams invites is a must for meetings. When we create a meeting, without doing so, optional members are added to the teams meeting. You can imagine that when a team meeting is created and 200 people are a member of a team but only 5 are invited, that a meeting can quickly become unproductive. We’ve also noted that using private channels does not allow you to create meetings. And, in fact, using a private channel would be ideal when you don’t want 200+ personnel invited to a meeting that don’t belong. Can we suggest two feature updates?1. Prevent Teams from broadcasting to the whole team. Only invite the required personnel. Optional members should be just that, only receive the invite if you were included on the Optional field. Users would be able to see if they’re optional or not.2. Allow Teams to utilize private channels for more meeting control or to allow for meetings which require extreme privacy (i.e., investigations, meetings about personal health discussions, etc.). Thank you, TC Read More
MS Teams Connector end of support clarification
We have Teams integration setup for our app and have a couple questions about the recent announcement of the end of support for Teams connectors:
– Are teams tab apps affected by this? Or only connector use that posts into teams channels and conversations?
– Is the use of the https://teams.microsoft.com/share URL to post into channels affected by this?
We have Teams integration setup for our app and have a couple questions about the recent announcement of the end of support for Teams connectors: – Are teams tab apps affected by this? Or only connector use that posts into teams channels and conversations?– Is the use of the https://teams.microsoft.com/share URL to post into channels affected by this? Read More
PRONOSTICO.ETS
He revisado diferentes portales sobre la función y todas se apoyan en la ayuda que brinda Microsoft sobre la estacionalidad.
He descubierto que es posible colocar otros valores en esa opción. Sin embargo, no encuentro información sobre qué significa esa posibilidad dentro de la opción de estacionalidad o de qué depende (criterio) para colocar un valor diferente a 0 y 1.
¿En caso de colocar “24”, por poner un ejemplo, significa que realiza la diferencia con el valor 24 datos antes?
He revisado diferentes portales sobre la función y todas se apoyan en la ayuda que brinda Microsoft sobre la estacionalidad.He descubierto que es posible colocar otros valores en esa opción. Sin embargo, no encuentro información sobre qué significa esa posibilidad dentro de la opción de estacionalidad o de qué depende (criterio) para colocar un valor diferente a 0 y 1.¿En caso de colocar “24”, por poner un ejemplo, significa que realiza la diferencia con el valor 24 datos antes? Read More
why is Excel returning False
see attached i don’t see a reason why excel returned false when i did on cell d1 =a1=c1
see attached i don’t see a reason why excel returned false when i did on cell d1 =a1=c1@HansVogelaar Read More
Excel Formulas Not Working On Programme
Hi everyone,
I’m new to Excel and I’m having difficulty with some of the functions/formulas. For example, I want to join cell A2 with B2 and place an underscore between them. Whenever I try using this formula: =CONCATENATE(A2, “_”, B2), I get an error.
However, when I use the same formula on the web version of Excel, it works without any problems, just like other formulas I have tested. Is there anything I can do about it, or is using the web version of Excel my only option?
Thank you in advance.
Hi everyone,I’m new to Excel and I’m having difficulty with some of the functions/formulas. For example, I want to join cell A2 with B2 and place an underscore between them. Whenever I try using this formula: =CONCATENATE(A2, “_”, B2), I get an error.However, when I use the same formula on the web version of Excel, it works without any problems, just like other formulas I have tested. Is there anything I can do about it, or is using the web version of Excel my only option?Thank you in advance. Read More
Struggling with LAMBDA in my LET statement
I have a table that has repeating product numbers (P_NUM) and for each row, there is an attribute value. I want to turn that into a single row with the P_NUM and the list of attributes.
The LET statement was provided by ChatGPT and should work, but I am having trouble with the LAMBDA functions. If I modify the data line to have getValues, instead of rowBuilder, I get the headings printed out and rows of data, with P_NUM having a #CALC error and the values have #N/A.
If I keep the formula as it is, I get a single #CALC error in the cell where the LET statement resides and nothing else.
I have added CLEAN and TRIM on P_NUM as I know I have had problems with type mismatch when extracting data from the original source – made no difference.
=LET(
PNums, UNIQUE(A2:A100),
attributeNames, UNIQUE(F2:F100),
attributeValues, G2:G100,
PNumRange, (A2:A100),
attributeNameRange, F2:F100,
headers, HSTACK(“P_NUM”, TRANSPOSE(attributeNames)),
getValues, LAMBDA(pn, LAMBDA(an, IFERROR(INDEX(attributeValues, MATCH(1, (PNumRange = pn) * (attributeNameRange = an), 0)), “”))),
rowBuilder, LAMBDA(pn, HSTACK(pn, MAP(attributeNames, getValues(pn)))),
data, BYROW(PNums, rowBuilder),
result, VSTACK(headers, data),
result
)
first result
second result when I change rowBuilder in the data line with getValues (to see what I get)
I have a table that has repeating product numbers (P_NUM) and for each row, there is an attribute value. I want to turn that into a single row with the P_NUM and the list of attributes. The LET statement was provided by ChatGPT and should work, but I am having trouble with the LAMBDA functions. If I modify the data line to have getValues, instead of rowBuilder, I get the headings printed out and rows of data, with P_NUM having a #CALC error and the values have #N/A. If I keep the formula as it is, I get a single #CALC error in the cell where the LET statement resides and nothing else. I have added CLEAN and TRIM on P_NUM as I know I have had problems with type mismatch when extracting data from the original source – made no difference. =LET(PNums, UNIQUE(A2:A100),attributeNames, UNIQUE(F2:F100),attributeValues, G2:G100,PNumRange, (A2:A100),attributeNameRange, F2:F100,headers, HSTACK(“P_NUM”, TRANSPOSE(attributeNames)),getValues, LAMBDA(pn, LAMBDA(an, IFERROR(INDEX(attributeValues, MATCH(1, (PNumRange = pn) * (attributeNameRange = an), 0)), “”))),rowBuilder, LAMBDA(pn, HSTACK(pn, MAP(attributeNames, getValues(pn)))),data, BYROW(PNums, rowBuilder),result, VSTACK(headers, data),result) first result second result when I change rowBuilder in the data line with getValues (to see what I get) Read More
I need help with this IF function
I want to C1 to include if B1>A1 give me zero, otherwise give me the difference between the two. I’ve attached a screenshot.
I want to C1 to include if B1>A1 give me zero, otherwise give me the difference between the two. I’ve attached a screenshot. Read More
e mail problem
e mail problem
hello community
when sending or forwarding an e-mail, it goes to pending and does not recover without terminating the task.
e mail problemhello communitywhen sending or forwarding an e-mail, it goes to pending and does not recover without terminating the task. Read More
Help with Creating 365 Users and Altering UPN
I have been working on the below script for a little while and I am still having some trouble getting it to fully function. Please be kind, as this is the first script I’ve ever written.
The goal of the code is to create 365 user accounts using a .csv file. The loop should check if the upn exists, if it does not it will create the user using email address removed for privacy reasons and if it does then it will change the upn to firstname.lastname[int]@domain.com and create the user. The integer should increment up depending on how many users have a similar upn.
Right now, I can get it to create a user but it will not increment automatically. Any help would be greatly appreciated. See code below. I have switched out sensitive information that was included in the code with confidential. I set all the variables to null at the bottom in an effort to troubleshoot where the problem may be, so it is not intended to be part of the code.
Also, I would like to generate a random password. I read that I should just leave the password profile blank to complete that but it didn’t seem to work. Any suggestions with that are also welcomed.
#Connect to Microsoft Graph Powershell Module
Connect-MgGraph -Scopes “User.ReadWrite.All”,”Group.ReadWrite.All”,”Directory.ReadWrite.All”
#Connect to Exchange Online Powershell Module
Connect-ExchangeOnline
# Import the CSV file
$csvrecords = Import-Csv -Path “C:UsersConfidentialOneDrive – ConfidentialDocumentsPowerShellScriptsO365PowershellTest1.csv” #Add our file here
# Create a password profile
$PasswordProfile = @{
Password = “Password1234!”
}
# Loop through each user in the CSV file
foreach ($csvrecord in $csvrecords)
{
#Variable to increment UserPrincipalName
$i = 1
$created = $false #set the variable to end the loop
$user = Get-MgUser -Filter “UserPrincipalName eq ‘$upn'” #Set User variable to User’s GUID
do {
If(!$User.ID)
{
$upn = $csvrecord.UserPrincipalName #Set the UPN variable to the user’s email address
# Create a new user if the username does not exist
$newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled
$created = $true
}
else {
$i = $i + 1
#Add an interger to the end of first and last name in username
$upn = $csvrecord.FirstName + “.” + $csvrecord.LastName + $i + “@Confidential.org”
#create the user
$newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled
$created = $true
}
} until ($created = $true)
# Assign a license to the new user
$e3Sku = Get-MgSubscribedSku | Where SkuPartNumber -eq ‘SPE_E3’
Set-MgUserLicense -UserID $newUser.UserPrincipalName -AddLicenses @{SkuId = $e3Sku.SkuId} -RemoveLicenses @()
# Export the results to a CSV file
$csvrecords | Export-Csv -Path “C:UsersConfidentialOneDrive -ConfidentialDocumentsPowerShellScriptsO365NewAccountResultsTest1.csv” -NoTypeInformation #Add our file here
$i = $null
$created = $null
$upn = $null
$user = $null
}
#Disconnect from Microsoft Exchange
Disconnect-ExchangeOnline
#Disconnect from MgGraph
Disconnect-MgGraph
I have been working on the below script for a little while and I am still having some trouble getting it to fully function. Please be kind, as this is the first script I’ve ever written. The goal of the code is to create 365 user accounts using a .csv file. The loop should check if the upn exists, if it does not it will create the user using email address removed for privacy reasons and if it does then it will change the upn to firstname.lastname[int]@domain.com and create the user. The integer should increment up depending on how many users have a similar upn. Right now, I can get it to create a user but it will not increment automatically. Any help would be greatly appreciated. See code below. I have switched out sensitive information that was included in the code with confidential. I set all the variables to null at the bottom in an effort to troubleshoot where the problem may be, so it is not intended to be part of the code.Also, I would like to generate a random password. I read that I should just leave the password profile blank to complete that but it didn’t seem to work. Any suggestions with that are also welcomed. #Connect to Microsoft Graph Powershell ModuleConnect-MgGraph -Scopes “User.ReadWrite.All”,”Group.ReadWrite.All”,”Directory.ReadWrite.All” #Connect to Exchange Online Powershell ModuleConnect-ExchangeOnline # Import the CSV file$csvrecords = Import-Csv -Path “C:UsersConfidentialOneDrive – ConfidentialDocumentsPowerShellScriptsO365PowershellTest1.csv” #Add our file here # Create a password profile $PasswordProfile = @{ Password = “Password1234!” } # Loop through each user in the CSV fileforeach ($csvrecord in $csvrecords) { #Variable to increment UserPrincipalName $i = 1 $created = $false #set the variable to end the loop $user = Get-MgUser -Filter “UserPrincipalName eq ‘$upn'” #Set User variable to User’s GUID do { If(!$User.ID) { $upn = $csvrecord.UserPrincipalName #Set the UPN variable to the user’s email address # Create a new user if the username does not exist $newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled $created = $true} else { $i = $i + 1 #Add an interger to the end of first and last name in username $upn = $csvrecord.FirstName + “.” + $csvrecord.LastName + $i + “@Confidential.org” #create the user $newUser = New-MgUser -GivenName $csvrecord.FirstName -Surname $csvrecord.LastName -DisplayName $csvrecord.DisplayName -UserPrincipalName $upn -UsageLocation ‘US’ -JobTitle $csvrecord.JobTitle -Department $csvrecord.Department -PasswordProfile $PasswordProfile -MailNickname $csvrecord.MailNickname -AccountEnabled $created = $true } } until ($created = $true) # Assign a license to the new user $e3Sku = Get-MgSubscribedSku | Where SkuPartNumber -eq ‘SPE_E3’ Set-MgUserLicense -UserID $newUser.UserPrincipalName -AddLicenses @{SkuId = $e3Sku.SkuId} -RemoveLicenses @() # Export the results to a CSV file$csvrecords | Export-Csv -Path “C:UsersConfidentialOneDrive -ConfidentialDocumentsPowerShellScriptsO365NewAccountResultsTest1.csv” -NoTypeInformation #Add our file here $i = $null$created = $null$upn = $null$user = $null } #Disconnect from Microsoft ExchangeDisconnect-ExchangeOnline #Disconnect from MgGraphDisconnect-MgGraph Read More
No Caller ID information on voicemails
Teams Windows desktop client – Incoming calls DO display Caller ID information, but voicemails only display the number. My users swear that voicemails used to have the caller’s name, but now only show the number so it is difficult for them to discern who the call is from.
The Teams mobile app DOES show Caller ID information on each voicemail. It seems like a huge omission for this to be missing on the desktop client.
Teams Windows desktop client – Incoming calls DO display Caller ID information, but voicemails only display the number. My users swear that voicemails used to have the caller’s name, but now only show the number so it is difficult for them to discern who the call is from.The Teams mobile app DOES show Caller ID information on each voicemail. It seems like a huge omission for this to be missing on the desktop client. Read More
Excel Formula Help! Automate data from tabs to master tab
Hello! I am having trouble figuring out how to automate data between tabs. I have a Master list and then separate sheets with each category. I would like to be able to input data into the category sheet and it automatically populate into my master sheet. Is this possible? Any help would be greatly appreciated!! 🙂
Hello! I am having trouble figuring out how to automate data between tabs. I have a Master list and then separate sheets with each category. I would like to be able to input data into the category sheet and it automatically populate into my master sheet. Is this possible? Any help would be greatly appreciated!! 🙂 Read More
Auto-populate a column in one list from a source in a lookup list
I have a list built with the new SharePoint list template called “Approvals Content Scheduler With Approvals” (the target list) and the list is called Timesheet. The purpose is for an employee to log time for a given week and the time is entered into a column as a number. By default, this list has a column named “Author” (Employee) and “Approver” (Person selected to approve).
In a separate lookup list (the source), I have two columns; Employee (which would be the Author in this case) and their manager in the second column named “Manager”.
When an employee creates a new item in the Timesheet list (the target list), the employee becomes the Author, and whomever they selected as the approver becomes the “Approver”. In addition to these two columns, I have created a new column in the Timesheet list (the target list) called “Manager”.
The scenario: When an employee enters a new item in the Timesheet (the target list), I want to use the lookup list (the source list) to grab the Manager’s name and auto-populate this name into the Manager column in the target list.
The lookup list (source) has one column for the employee’s name and one column with the name of their manager. How do I get the name of the employee’s manager to auto-populate the Manager column in the Timesheet list (target list)? Basically, I want to use the lookup list to determine who the manager is for the employee and insert the Manager’s name in the Manager column in the target list. I don’t want the user (Employee) to make the selection.
I have a list built with the new SharePoint list template called “Approvals Content Scheduler With Approvals” (the target list) and the list is called Timesheet. The purpose is for an employee to log time for a given week and the time is entered into a column as a number. By default, this list has a column named “Author” (Employee) and “Approver” (Person selected to approve). In a separate lookup list (the source), I have two columns; Employee (which would be the Author in this case) and their manager in the second column named “Manager”. When an employee creates a new item in the Timesheet list (the target list), the employee becomes the Author, and whomever they selected as the approver becomes the “Approver”. In addition to these two columns, I have created a new column in the Timesheet list (the target list) called “Manager”. The scenario: When an employee enters a new item in the Timesheet (the target list), I want to use the lookup list (the source list) to grab the Manager’s name and auto-populate this name into the Manager column in the target list. The lookup list (source) has one column for the employee’s name and one column with the name of their manager. How do I get the name of the employee’s manager to auto-populate the Manager column in the Timesheet list (target list)? Basically, I want to use the lookup list to determine who the manager is for the employee and insert the Manager’s name in the Manager column in the target list. I don’t want the user (Employee) to make the selection. Read More
Excel Filter() Function Skipping Data
Hello all!
I am completing an analysis based on a very large master data set (around 50.,000 rows). I have encountered an issue in one specific calculation I am trying to program. Basically, a part of my algorithm for this calculation is using the Filter() function to find specific values based on an ID and two other criteria. However, I noticed that many expected values for a test cell with the formula were missing (e.g., I expected a dozen rows to return for this test cell but only 5 or so results would appear. I managed to find a very specific test example with a small subset of the data I have that gives the same error:
Formula is: =FILTER(DB!W$18844:W$18850;DB!H$18844:H$18850=A2;0), A2 is 102158
Data pulled directly from my report (apologies, I use the French Canadian version of Excel which uses commas and not periods for decimals):
HW188441021582232,1188451021580188461021580188471021580188481021580188491021580188501021580
This results in only row 18844 and 18848 being pulled by the Filter function, giving 2232,1 and 0
I have checked the “Evaluate Formula” tool and it successfully matches the ID number (column H) to all 7 rows as it gives the array {TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE} at the step where it compares A2 to the range provided and it does not provide any further calculation steps after this. I have no idea what to check next to find the source of the error. Any ideas?
Thanks!
Hello all! I am completing an analysis based on a very large master data set (around 50.,000 rows). I have encountered an issue in one specific calculation I am trying to program. Basically, a part of my algorithm for this calculation is using the Filter() function to find specific values based on an ID and two other criteria. However, I noticed that many expected values for a test cell with the formula were missing (e.g., I expected a dozen rows to return for this test cell but only 5 or so results would appear. I managed to find a very specific test example with a small subset of the data I have that gives the same error: Formula is: =FILTER(DB!W$18844:W$18850;DB!H$18844:H$18850=A2;0), A2 is 102158 Data pulled directly from my report (apologies, I use the French Canadian version of Excel which uses commas and not periods for decimals): HW188441021582232,1188451021580188461021580188471021580188481021580188491021580188501021580 This results in only row 18844 and 18848 being pulled by the Filter function, giving 2232,1 and 0I have checked the “Evaluate Formula” tool and it successfully matches the ID number (column H) to all 7 rows as it gives the array {TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE} at the step where it compares A2 to the range provided and it does not provide any further calculation steps after this. I have no idea what to check next to find the source of the error. Any ideas? Thanks! Read More
Variable Performance when Creating or Removing Shortcut Folders for SharePoint libraries
When using the “Add shortcut to OneDrive” feature for a SharePoint online library or folder, we experience inconsistent performance with the local OneDrive sync application creating/initializing the local “shortcut folder”. Sometimes the sync application processes “changes” very quickly–100s of changes per second. And sometimes it does so very slowly–10s (or less) changes per second.
We experience the same inconsistent behavior when removing a “shortcut folder”–sometimes it’s fast and sometimes it’s slow.
In my testing, the difference cannot be attributed to either the specific SharePoint library/folder or the the specific client machine. On my own machine, I have seen both the fast and slow behavior when creating a “shortcut folder” for the same SharePoint library.
Can anyone provide any insight on what might be causing this inconsistent performance?
Could any service limits be coming into play?
https://learn.microsoft.com/en-us/graph/throttling-limits#files-and-lists-service-limits
Environment: Large SharePoint online libraries; Windows 11 client machines; current PROD ring OneDrive sync applications; Files On-Demand enforced via group policy; no rate limiting used for the local sync application.
When using the “Add shortcut to OneDrive” feature for a SharePoint online library or folder, we experience inconsistent performance with the local OneDrive sync application creating/initializing the local “shortcut folder”. Sometimes the sync application processes “changes” very quickly–100s of changes per second. And sometimes it does so very slowly–10s (or less) changes per second.We experience the same inconsistent behavior when removing a “shortcut folder”–sometimes it’s fast and sometimes it’s slow. In my testing, the difference cannot be attributed to either the specific SharePoint library/folder or the the specific client machine. On my own machine, I have seen both the fast and slow behavior when creating a “shortcut folder” for the same SharePoint library. Can anyone provide any insight on what might be causing this inconsistent performance?Could any service limits be coming into play?https://learn.microsoft.com/en-us/graph/throttling-limits#files-and-lists-service-limits Environment: Large SharePoint online libraries; Windows 11 client machines; current PROD ring OneDrive sync applications; Files On-Demand enforced via group policy; no rate limiting used for the local sync application. Read More