Category: Microsoft
Category Archives: Microsoft
word on my mac
hi all,can anyone help ,when i open word on my mac it very slow to respond,it sluggish for 10 minutes then starts to freeze and stops working i cannot even close word,i have to force shut it.and restart my computer this only been happening a few days but very frustrating,
im a bit of an IT dinosaurs could you be so kind to explain in simple terms
kind regards
hi all,can anyone help ,when i open word on my mac it very slow to respond,it sluggish for 10 minutes then starts to freeze and stops working i cannot even close word,i have to force shut it.and restart my computer this only been happening a few days but very frustrating,im a bit of an IT dinosaurs could you be so kind to explain in simple termskind regards Read More
Evaluation Flows for Large Language Models (LLM) in Azure AI Studio
Large Language Models (LLMs) are incredibly useful for generating natural language texts for tasks like summarization, translation, question answering, and text generation. However, they aren’t always perfect and can sometimes produce outputs that are inaccurate, irrelevant, biased, or even harmful. That’s why it’s super important to evaluate the outcomes from LLMs to ensure they meet the quality and ethical standards required for their intended use.
Imagine you’re using an LLM to help create content for a website. Without proper evaluation, the model might generate text that doesn’t quite fit the tone you’re looking for, or worse, it might include biased or incorrect information. This is where evaluation flows come in handy. These systematic procedures help you assess and improve the LLM’s outputs, making it easier to spot and fix errors, biases, and potential risks. Plus, evaluation flows can provide valuable feedback and guidance, helping developers and users align the LLM’s performance with business goals and user expectations. By incorporating evaluation steps, you can ensure a more user-friendly and reliable experience for everyone involved.
In this article, we will explain what evaluation flows are, and how we can implement them in Azure AI Studio. We will start by pointing out the motivations for evaluating outcomes from LLMs and provide some examples of business situations where the absence of evaluation can incur in problems for the business. Then, we will describe the main components and steps of evaluation flows and show how to use Azure AI Studio to create and execute evaluation flows for LLMs. Finally, we will discuss some best practices and challenges of evaluation flows and provide some resources for further learning.
Motivations for Evaluating Outcomes from LLMs
Evaluating the outcomes from Large Language Models (LLMs) is crucial for several reasons. First and foremost, it ensures the quality and accuracy of the texts they generate. Imagine using an LLM to create product descriptions. Without proper evaluation, the model might produce descriptions that are misleading, inaccurate, or irrelevant to the product’s features. By evaluating the LLM’s outputs, you can catch and correct these errors, improving the overall quality and accuracy of the text.
Another important aspect is ensuring the ethical and social responsibility of the generated texts. LLMs can sometimes produce biased, offensive, harmful, or even illegal content. For instance, if an LLM is used to write news articles, it might inadvertently generate text that is racist, sexist, or defamatory. Evaluating the outputs helps identify and mitigate these biases and risks, ensuring the texts are ethical and socially responsible.
It’s essential to ensure that the LLM’s outputs align with business goals and user expectations. Picture an LLM generating marketing emails. Without evaluation, these emails might come across as too formal, too casual, or just too generic, missing the mark entirely. By assessing the outputs, you can optimize their impact and relevance, making sure they effectively meet the business’s objectives and resonate with the target audience.
Failing to evaluate LLM outputs can lead to serious problems for a business. For instance, if the generated texts are low-quality, unethical, or irrelevant, customers and users may lose trust and interest. Consider an LLM that produces fake or biased product reviews. Customers would likely stop trusting these reviews and might even turn to competitors.
Moreover, if the LLM generates harmful, offensive, or illegal content, the business could face legal, regulatory, or social repercussions. Imagine an LLM generating defamatory or false news articles; the business could end up facing lawsuits, fines, or boycotts, severely damaging its reputation and credibility.
Finally, the effectiveness of LLM outputs directly impacts a business’s competitive advantage and profitability. If the texts aren’t persuasive, personalized, or engaging—like in marketing emails—the business might fail to boost sales, conversions, or retention rates, ultimately losing its edge in the market.
Best Practices and Challenges of Evaluation Flows
Evaluation flows for LLMs are not trivial or straightforward, and they involve various best practices and challenges that users should be aware of and address, such as:
Defining clear and realistic evaluation goals and objectives. Users should specify what they want to evaluate, why they want to evaluate, and how they want to evaluate, and align their evaluation goals and objectives with the business goals and user expectations.
Choosing appropriate and reliable evaluation data and metrics. Users should select data and metrics that are representative, diverse, and sufficient for the evaluation task, and ensure that they are relevant, reliable, and valid for the evaluation task.
Choosing appropriate and robust evaluation methods and actions. Users should select methods and actions that are appropriate, robust, and scalable for the evaluation task, and ensure that they are transparent, explainable, and accountable for the evaluation results and impact.
Conducting iterative and continuous evaluation. Users should conduct evaluation in an iterative and continuous manner, and update and refine their evaluation data, metrics, methods, and actions based on the feedback and findings from the evaluation.
Collaborating and communicating with stakeholders. Users should collaborate and communicate with various stakeholders, such as developers, users, customers, and regulators, and involve them in the evaluation process and outcomes, and address their needs, concerns, and expectations.
Evaluation flows for LLMs are an essential and valuable part of the LLM lifecycle, and they can help users to ensure the quality, ethics, and effectiveness of the LLM outputs, and to achieve the desired outcomes and objectives of the LLM use cases. In general, there are several different ways to implement evaluation flows, but the best strategy will always rely on using proper tools for managing, deploying and monitoring both the LLMs behavior and its evaluation flows. And we have the proper tool to do that.
How to evaluate LLM models using Azure AI Studio?
Azure AI Studio is a cloud-based platform that enables users to build, deploy, and manage LLM models and applications. It provides various features and tools that support the evaluation flows for LLMs, such as:
You just have to provide a name and select the scenario for the evaluation project:
You can also select a Prompt Flow for the evaluation project. Although optional, it’s suggested the usage of prompt flow as an orchestrator due to its capacity to manage the connections and the requirements on each evaluation step, as well as for logging and properly decoupling each step of the flow. In this example, we use a prompt flow solution to provide the model’s answers to the questions and be evaluated against the ground truth. Feel free to use your own assistant here. Basically, the idea is to generate the answer for a given input (you can also pre-process this data and provide to the dataset):
Next, it’s time to select the dataset for the evaluation project. In the Azure-Samples/llm-evaluation (github.com) repository we provide some methods to synthetically generate the data based on a retrieval index. It’s important to notice that, since the task at hand is an evaluation based on reference texts and / or well-defined text outcomes, the data used on the task should be a set of questions and answers that allow the flow to tag what is improper, proper, and how well does a given response will fit under the provided reference.
Since those metrics are based on referenced values for a well-defined set of texts and, in particular for QnA tasks, based on a question-answer pair, it’s suitable for a limited amount of texts that is applicable for a wider range of situations, thus needing a single file that contains this referential question an answer pairs. Here is an example of a QnA dataset. In this case, we only have a pair of question/ground_truth data given the answer will be provide by the prompt flow assistant. Use Add your dataset to upload the file:
In our example, we use a Prompt Flow solution to provide the model’s answers to the questions and be evaluated against the ground truth. For this, we select the dataset column $(data.question). As in any evaluation job, you’ll need to define what is the proper metrics that you want to apply. Not only you can rely on Azure AI Studio’s built-in metrics, but you could also include extra metrics and strategies, including those that depend on evaluating the embeddings. For that, proceed as follows:
We use GPT-4 as the model for the evaluation project due to its higher inference and cognitive capacities, but the proper choice would depend on the task you have at hand. You can select the model from the list of available models. We also added Risk and safety metrics to mitigate any potential risks regarding model’s misuse.
As mentioned earlier, we use the Prompt Flow solution to provide the model’s answers to the questions. It’s an opt-in, where you could just use the default engine for the evaluation, but in this case we can map the output with the GPT similarity metric to evaluate the ground truth against the model’s answers:
Finally, you can submit the evaluation project and view the results .
In our example dataset we provided two samples with wrong ground truth answers to evaluate the model’s GPT-similarity metric. Notice that the results demonstrate a low performance for these two samples. It is expected as the ground truth answers are incorrect.
We can see that the Similarity score for the two incorrect samples are very low given the incorrect ground truth labels. In the real-world is expected that the models can produce wrong answers, contrasting with the perfect ground truths values. Finally, the main dashboard on your Azure AI Studio project gives the average score for each metric.
Resources
Evaluation of generative AI applications
How to evaluate generative AI apps with Azure AI Studio
Microsoft Tech Community – Latest Blogs –Read More
What to do with document “content” from docx file
Hello,
I can successfully connect to and call a Graph API to retrieve a document from a sharepoint document library using
https://graph.microsoft.com/v1.0/sites/{siteId}/drives/{driveId}/items/{itemId}/content
there is a screenshot below of the returned value using postman for a sample
What exactly is this?
What am I supposed to do with this?
A lot of googling seems to imply I need to write this to a local docx file on my system, but is there no way to convert/parse this to json or something so I am query it directly
Ultimately the end goal will be do something like
“external system places a document in a sp folder”
“use graph to get the document”
“do some magic with the document gotten from graph”
write a test to say “does the document contain the text ‘my string value'”
I am using typescript with playwright to write automated tests
Hello,I can successfully connect to and call a Graph API to retrieve a document from a sharepoint document library using https://graph.microsoft.com/v1.0/sites/{siteId}/drives/{driveId}/items/{itemId}/content there is a screenshot below of the returned value using postman for a sample What exactly is this?What am I supposed to do with this?A lot of googling seems to imply I need to write this to a local docx file on my system, but is there no way to convert/parse this to json or something so I am query it directlyUltimately the end goal will be do something like”external system places a document in a sp folder””use graph to get the document””do some magic with the document gotten from graph”write a test to say “does the document contain the text ‘my string value'”I am using typescript with playwright to write automated tests Read More
Expand a single row
Hello everyone !
I need to validate something with you.
In a pivot table, I have the same row in multiple sections (e.g : a product 1 in 5 different stores). I would like to expand the row for product 1 in store 1 without expanding the rows for product 1 in the other 4 stores.
In my case, when I expand product 1 in store 1, it also expands product 1 in the other stores.
Is it possible ?
Thank you
Hello everyone ! I need to validate something with you. In a pivot table, I have the same row in multiple sections (e.g : a product 1 in 5 different stores). I would like to expand the row for product 1 in store 1 without expanding the rows for product 1 in the other 4 stores. In my case, when I expand product 1 in store 1, it also expands product 1 in the other stores. Is it possible ? Thank you Read More
I have an Issue with event DropDown in combobox in Access’s form
n a form, I have a combo box that changes dynamically, i.e., during execution each time I select it. Everything works fine except for the DropDown, which does not “auto-expand.” I am sending the code I am using.
Thanks
Const MarcaSQL1 As String = “SELECT pres_marca.Marca FROM pres_marca;”
Const MarcaSQL2 As String = “SELECT pres_modelo.Descripcion FROM pres_modelo WHERE (((pres_modelo.marca)=[textomarca]));”
Const MarcaSQL3 As String = “SELECT pres_cisterna.descripcion, pres_cisterna.Marca FROM pres_cisterna WHERE (((pres_cisterna.Marca) = [Textomarca])) ORDER BY pres_cisterna.Cisterna;”
Private Sub Form_Current()
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
End Sub
Private Sub Caracteristicas_AfterUpdate()
If Seleccion = 1 Then
Textomarca = Caracteristicas
Seleccion = 2
Caracteristicas.RowSource = MarcaSQL2
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 2 Then
Textomodelo = Caracteristicas
Seleccion = 3
Caracteristicas.RowSource = MarcaSQL3
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 3 Then
TextoCisterna = Caracteristicas
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
End If
End Sub
n a form, I have a combo box that changes dynamically, i.e., during execution each time I select it. Everything works fine except for the DropDown, which does not “auto-expand.” I am sending the code I am using.Thanks Const MarcaSQL1 As String = “SELECT pres_marca.Marca FROM pres_marca;”
Const MarcaSQL2 As String = “SELECT pres_modelo.Descripcion FROM pres_modelo WHERE (((pres_modelo.marca)=[textomarca]));”
Const MarcaSQL3 As String = “SELECT pres_cisterna.descripcion, pres_cisterna.Marca FROM pres_cisterna WHERE (((pres_cisterna.Marca) = [Textomarca])) ORDER BY pres_cisterna.Cisterna;”
Private Sub Form_Current()
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
End Sub
Private Sub Caracteristicas_AfterUpdate()
If Seleccion = 1 Then
Textomarca = Caracteristicas
Seleccion = 2
Caracteristicas.RowSource = MarcaSQL2
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 2 Then
Textomodelo = Caracteristicas
Seleccion = 3
Caracteristicas.RowSource = MarcaSQL3
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 3 Then
TextoCisterna = Caracteristicas
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
End If
End Sub Read More
Action ‘terminate’- “Enter custom value” not working
ello,
the action ‘terminate’ provides the possibility to enter a custom value.
But every trial ended up with an error.
Can anyone give me a hint, how to use this?
Br.
ello,the action ‘terminate’ provides the possibility to enter a custom value.But every trial ended up with an error. Can anyone give me a hint, how to use this? Br. Read More
Microsoft Graph API: can’t filter by companyName
I am trying to filter users by the ‘companyName’ field and always receive a ‘400 Bad Request’ error. As suggested in many similar issues, I added ‘$count=true’ and the ‘ConsistencyLevel=eventual’ header, but still no luck. Is it possible at all to filter users in my tenant by this field?
I am trying to filter users by the ‘companyName’ field and always receive a ‘400 Bad Request’ error. As suggested in many similar issues, I added ‘$count=true’ and the ‘ConsistencyLevel=eventual’ header, but still no luck. Is it possible at all to filter users in my tenant by this field? betav1 Read More
Unable to get user details after Notification Bot is app installed
I’ve a Notification Bot, which is currently deployed to my organization, and all the users are able to see it and add to their teams app individually. I want to send welcome message to all users who’ve installed the app. I’ve an endpoint added in the bot framework which gives me an update whenever someone adds or remove the app in their teams app. But whenever someone is installing the app, I’m getting this error “Failed to acquire token”. I’ve tried to install the app from Admin teams to all users as well from particular user by going to “Teams store > Built for your organization > App > click on “Add””. But both of the options are giving me same error.
Here is the Bot permission given by admin in Portal Azure
I’ve added the Application Id as my BotId according to the documentation and BotSecret as well
Please help me in solving this problem.
P.S. I don’t know what this “d6d49420-xxxx-xxxx-xxxx-xxxxxx” resembles while the former one is my BotId i.e., “28c8b3b1-xxxx-xxxx-xxxx-xxxxxxxx”.
Thanks in advance.
I’ve a Notification Bot, which is currently deployed to my organization, and all the users are able to see it and add to their teams app individually. I want to send welcome message to all users who’ve installed the app. I’ve an endpoint added in the bot framework which gives me an update whenever someone adds or remove the app in their teams app. But whenever someone is installing the app, I’m getting this error “Failed to acquire token”. I’ve tried to install the app from Admin teams to all users as well from particular user by going to “Teams store > Built for your organization > App > click on “Add””. But both of the options are giving me same error.Here is the Bot permission given by admin in Portal AzureI’ve added the Application Id as my BotId according to the documentation and BotSecret as wellPlease help me in solving this problem.P.S. I don’t know what this “d6d49420-xxxx-xxxx-xxxx-xxxxxx” resembles while the former one is my BotId i.e., “28c8b3b1-xxxx-xxxx-xxxx-xxxxxxxx”.Thanks in advance. Read More
Outlook.live.com inbox not working and sending messages is working fine
what to do if no messages arrive on outlook.live.com? I don’t have any Microsoft 365 package, is it necessary to receive messages in the web version? I can send messages and it works fine, but receiving messages does not. the email address is from an external server. In outlook.live.com it is not possible to set POP and IMAP for an external mailbox. what should I do? These are the only POP and IMAP settings visible in the screenshot
what to do if no messages arrive on outlook.live.com? I don’t have any Microsoft 365 package, is it necessary to receive messages in the web version? I can send messages and it works fine, but receiving messages does not. the email address is from an external server. In outlook.live.com it is not possible to set POP and IMAP for an external mailbox. what should I do? These are the only POP and IMAP settings visible in the screenshot Read More
Global Policy for Channel Edit and Delete Settings
I can’t believe there is not a global policy for this setting. We create many New Teams a Month with members of multiple competency levels. Going into each Team individually and disabling the create, edit, delete options is not effective on multiple levels. As it stands, by default in Teams, any member can delete an entire channels worth of information in a single click. The only option around this is to go into every single team and change a setting which effects all users, including Owners. How is there a messaging policy for preventing users from editing and deleting messages, but not one for channels!
Does anyone know if there are plans to add this option. I have read there is a powershell to disable all users. But this defeats the point of policies and add issues when other admins need to make changes in the future.
I can’t believe there is not a global policy for this setting. We create many New Teams a Month with members of multiple competency levels. Going into each Team individually and disabling the create, edit, delete options is not effective on multiple levels. As it stands, by default in Teams, any member can delete an entire channels worth of information in a single click. The only option around this is to go into every single team and change a setting which effects all users, including Owners. How is there a messaging policy for preventing users from editing and deleting messages, but not one for channels! Does anyone know if there are plans to add this option. I have read there is a powershell to disable all users. But this defeats the point of policies and add issues when other admins need to make changes in the future. Read More
Basic Auth for Client Submission (SMTP Auth) alternatives in terms of security
As you may have heard, Microsoft will permanently remove support for Basic authentication with Client Submission (SMTP AUTH) in September 2025. For more details, see the article https://techcommunity.microsoft.com/t5/exchange-team-blog/exchange-online-to-retire-basic-auth-for-client-submission-smtp/ba-p/4114750. Microsoft also describes possible alternatives in the article.
I would like to discuss which method for sending email in Microsoft 365/Azure should be preferred in terms of security, including Direct Send and SMTP Relay with Microsoft 365. I have not included third-party SMTP Server service/server.
My rankings in terms of security is:
OAuth2.0 – Relies on token-based authentication, only allow email sending (no other permissions)
Azure Communication Services Email – Uses Modern Authentication if I understand correctly
High Volume Email for Microsoft 365 – Internal only, no mailbox associated to HVE-account
SMTP Relay with Office 365 – An associated mailbox to the email address is not required. Include IP-address in SPF.
Direct Send – Internal only, no authentication. Include IP-address in SPF.
Exchange Server On-Premises with Basic Auth – Not secure by default but may be less insecure if you restrict it to specific devices/servers within the local network.
Exchange Server On-Premises with Anonymous Relay – Not secure by default but may be less insecure if you restrict it to specific devices/servers within the local network.
What do you think? Please feel free to share your opinions!
As you may have heard, Microsoft will permanently remove support for Basic authentication with Client Submission (SMTP AUTH) in September 2025. For more details, see the article https://techcommunity.microsoft.com/t5/exchange-team-blog/exchange-online-to-retire-basic-auth-for-client-submission-smtp/ba-p/4114750. Microsoft also describes possible alternatives in the article. I would like to discuss which method for sending email in Microsoft 365/Azure should be preferred in terms of security, including Direct Send and SMTP Relay with Microsoft 365. I have not included third-party SMTP Server service/server. My rankings in terms of security is:OAuth2.0 – Relies on token-based authentication, only allow email sending (no other permissions)Azure Communication Services Email – Uses Modern Authentication if I understand correctlyHigh Volume Email for Microsoft 365 – Internal only, no mailbox associated to HVE-accountSMTP Relay with Office 365 – An associated mailbox to the email address is not required. Include IP-address in SPF.Direct Send – Internal only, no authentication. Include IP-address in SPF.Exchange Server On-Premises with Basic Auth – Not secure by default but may be less insecure if you restrict it to specific devices/servers within the local network.Exchange Server On-Premises with Anonymous Relay – Not secure by default but may be less insecure if you restrict it to specific devices/servers within the local network. What do you think? Please feel free to share your opinions! Read More
Microsoft bookings page sending notifications to wrong email address
Microsoft bookings pages sending email notifications to the wrong email address.
I have checked the reply to email address in the business information section and this seems to be correct, along with other settings in the back of this bookings page.
This is happening across numerous pages, and I can’t seem to get to the bottom of what is happening. The staff member receiving these emails doesn’t have any connection to the bookings page they are receiving notifications for.
Is there another area I can check who receives those notifications?
Microsoft bookings pages sending email notifications to the wrong email address.I have checked the reply to email address in the business information section and this seems to be correct, along with other settings in the back of this bookings page.This is happening across numerous pages, and I can’t seem to get to the bottom of what is happening. The staff member receiving these emails doesn’t have any connection to the bookings page they are receiving notifications for.Is there another area I can check who receives those notifications? Read More
KQL for an application within an application group
Hi,
Is it possible to query how many “hits” there are against an application within an application group in AVD?
I’m able to see the resource alias via WVDConnections but this doesn’t show the specific applications that a user is connecting to.
Thanks
Hi, Is it possible to query how many “hits” there are against an application within an application group in AVD? I’m able to see the resource alias via WVDConnections but this doesn’t show the specific applications that a user is connecting to. Thanks Read More
Automation Testing with SPFx React in SharePoint Online
Hello Everyone,
I have created an SPFx solution for SharePoint Online. I have use React under the SPFx project.
I need to implement Automation Testing for my SPFx React project. I have checked the automation frameworks that work with SPfx with React and SharePoint Online. I found 3 frameworks Selenium, Cypress, and Playwright.
Can anyone suggest to me which one is the better tool for Automation with SPFx React in SharePoint Online?
Thanks in Advance.
Hello Everyone,I have created an SPFx solution for SharePoint Online. I have use React under the SPFx project.I need to implement Automation Testing for my SPFx React project. I have checked the automation frameworks that work with SPfx with React and SharePoint Online. I found 3 frameworks Selenium, Cypress, and Playwright.Can anyone suggest to me which one is the better tool for Automation with SPFx React in SharePoint Online?Thanks in Advance. Read More
Lesson Learned #495: Monitoring DNS Resolution with PowerShell of Azure SQL Server
Today, I worked on a service request where the DNS was providing an incorrect IP address randomly. In this article, I would like to share a PowerShell script that checks the DNS resolution every 5 seconds to help identify the issue.
This script resolves a DNS name using two methods (Resolve-DnsName and nslookup), logs the details, and saves the results in a CSV file for further analysis. This approach helps in identifying the DNS server responses and understanding the resolution process over time.
Resolve-DnsName – A PowerShell cmdlet that provides detailed information about DNS queries.
nslookup – A command-line utility that queries DNS servers and provides details about the resolution process, including the responding DNS server.
# Function to resolve the DNS name using Resolve-DnsName and nslookup, then save the details to a CSV file
$OutPutFolder=”c:DnsResolution” ##Folder where the data will be saved.
$outputFile = “dns_resolution_log.csv” ##file where the data will be saved.
$hostname = “servername.database.windows.net” ##name of the resource that we are going to check.
function Resolve-DNS {
# Initialize an empty array to hold the data
$results = @()
# Resolve using Resolve-DnsName
try {
$dnsResult = Resolve-DnsName -Name $hostname -ErrorAction Stop
if ($dnsResult) {
foreach ($result in $dnsResult) {
$results += [PSCustomObject]@{
Timestamp = (Get-Date -Format “yyyy-MM-dd HH:mm:ss”)
Method = “Resolve-DnsName”
Hostname = $result.Name
QueryType = $result.QueryType
TimeToLive = $result.TimeToLive
IPAddress = $result.IPAddress
DnsServer = $null # Not provided by Resolve-DnsName
}
}
} else {
logMsg “No results from Resolve-DnsName”
}
} catch {
logMsg “Error resolving ${hostname} using Resolve-DnsName: $_”
}
# Resolve using nslookup
try {
$nslookupResult = nslookup $hostname
$dnsServer = $null
$ipAddresses = @()
foreach ($line in $nslookupResult) {
if ($line -match “^Server:”) {
$dnsServer = $line -replace “Server:”, “”
$dnsServer = $dnsServer.Trim()
}
if ($line -match “^Address:”) {
$ip = $line -replace “Address:”, “”
if ($ip -notmatch “[:#]”) { # Exclude IPv6 and port information
$ipAddresses += $ip.Trim()
}
}
}
if ($ipAddresses.Count -gt 0) {
foreach ($ip in $ipAddresses) {
$results += [PSCustomObject]@{
Timestamp = (Get-Date -Format “yyyy-MM-dd HH:mm:ss”)
Method = “nslookup”
Hostname = $hostname
QueryType = $null # Not provided by nslookup
TimeToLive = $null # Not provided by nslookup
IPAddress = $ip
DnsServer = $dnsServer
}
}
} else {
logMsg “No IP addresses found in nslookup response”
}
} catch {
logMsg “Error resolving ${hostname} using nslookup: $_”
}
# Save results to CSV
if ($results.Count -gt 0) {
try
{
if (-not (Test-Path $outputFile)) {
$results | Export-Csv -Path $outputFile -NoTypeInformation
} else {
$results | Export-Csv -Path $outputFile -NoTypeInformation -Append -Force
}
logMsg “DNS resolution details saved to $outputFile”
}
catch {
logMsg “not possible to save the output file $_”
}
}
}
#——————————–
# Log the operations
#——————————–
function logMsg {
Param (
[Parameter(Mandatory=$true, Position=0)]
[string] $msg,
[Parameter(Mandatory=$false, Position=1)]
[int] $Color = 0,
[Parameter(Mandatory=$false, Position=2)]
[boolean] $Show = $true,
[Parameter(Mandatory=$false, Position=3)]
[boolean] $bShowDate = $true
)
try {
if ($bShowDate -eq $true) {
$Fecha = Get-Date -format “yyyy-MM-dd HH:mm:ss”
$msg = “$Fecha $msg”
}
if ($Show -eq $true) {
switch ($Color) {
1 { Write-Host -ForegroundColor Cyan $msg }
2 { Write-Host -ForegroundColor White -BackgroundColor Red $msg }
3 { Write-Host -ForegroundColor Yellow $msg }
Default { Write-Host -ForegroundColor White $msg }
}
}
} catch {
Write-Host $msg
}
}
#————————————————————–
#Create a folder
#————————————————————–
Function CreateFolder
{
Param( [Parameter(Mandatory)]$Folder )
try
{
$FileExists = Test-Path $Folder
if($FileExists -eq $False)
{
$result = New-Item $Folder -type directory
if($result -eq $null)
{
return $false
}
}
return $true
}
catch
{
return $false
}
}
function GiveMeFolderName([Parameter(Mandatory)]$FolderSalida)
{
try
{
$Pos = $FolderSalida.Substring($FolderSalida.Length-1,1)
If( $Pos -ne “” )
{return $FolderSalida + “”}
else
{return $FolderSalida}
}
catch
{
return $FolderSalida
}
}
#——————————–
#Validate Param
#——————————–
function TestEmpty($s)
{
if ([string]::IsNullOrWhitespace($s))
{
return $true;
}
else
{
return $false;
}
}
clear
If( TestEmpty($OutPutFolder) )
{
write-host “Output folder is empty”
exit;
}
If( TestEmpty($outputFile) )
{
write-host “Output file is empty”
exit;
}
If( TestEmpty($hostname) )
{
write-host “HostName is empty”
exit;
}
$result = CreateFolder($OutPutFolder) #Creating the folder that we are going to have the results, log and zip.
If( $result -eq $false)
{
write-host “Was not possible to create the folder”
exit;
}
$DateFormat = Get-Date -format “yyyy-MM-dd_HHmmss”
$OutPutFolder = GiveMeFolderName($OutPutFolder) #Creating a correct folder adding at the end .
$outputFile = $OutPutFolder + $outputFile + “_” + $DateFormat
# Run the function every 5 seconds
while ($true) {
Resolve-DNS
Start-Sleep -Seconds 5
}
Example using Private Endpoint
Example using Public Endpoint
Disclaimer
The use of this application and the provided scripts is intended for educational and informational purposes only. The scripts and methods demonstrated in this guide are provided “as is” without any warranties or guarantees. It is the user’s responsibility to ensure the accuracy, reliability, and suitability of these tools for their specific needs.
Microsoft Tech Community – Latest Blogs –Read More
Offboard devices – Windows, MacOS, Linux
Hello,
the Defender offboarding process is a bit confusing.
It would be nice if we have clear procedure how to perform offboarding.
Does device must be offboarded first and then uninstall Microsoft Defender app?
In our environment we always wipe machine and install it again for another employee.
Is that process of wiping enough to cover offboarding, removing license,…? Just want to avoid overuse of licenses.
And in a case that device must be offboarded first, do we need to offboard devices using MDM system? We use Intune for Windows, Mosyle for macOS, SureMDM for Linux.
I know that device will become inactive after some time. Does that mean that license is not in use?
Thank you in advance.
Hello,the Defender offboarding process is a bit confusing. It would be nice if we have clear procedure how to perform offboarding. Does device must be offboarded first and then uninstall Microsoft Defender app? In our environment we always wipe machine and install it again for another employee.Is that process of wiping enough to cover offboarding, removing license,…? Just want to avoid overuse of licenses. And in a case that device must be offboarded first, do we need to offboard devices using MDM system? We use Intune for Windows, Mosyle for macOS, SureMDM for Linux.I know that device will become inactive after some time. Does that mean that license is not in use? Thank you in advance. Read More
How to get the lowest range of numbers in a formula
Hi All – I have the below ranges in different cells in Excel:
4-24, 25-72, 73-96, 96+
What I need to write a formula for, is to show in another column when searching all the above, which one is the smallest range.
Hope that makes sense.
Thanks
Hi All – I have the below ranges in different cells in Excel: 4-24, 25-72, 73-96, 96+ What I need to write a formula for, is to show in another column when searching all the above, which one is the smallest range. Hope that makes sense. Thanks Read More
Missing Asterisk in Microsoft Bookings
Hello Community Champs,
Hope all is well.
I have created a bookings page and added a custom question and marked it as it required and saved. However, when testing the booking link I do not see my question marked as required (Asterisk). Please someone advise.
Thank you,
Mahee
Hello Community Champs, Hope all is well. I have created a bookings page and added a custom question and marked it as it required and saved. However, when testing the booking link I do not see my question marked as required (Asterisk). Please someone advise. Thank you,Mahee Read More
I need some suggestion to extract audio from mp4 file on Windows 11 PC
Hey everyone! I’m trying to extract the audio from an MP4 video file and save it as an MP3 so I can play it on my car. Unfortunately, I’m not super tech-savvy, so I’m looking for a simple method or software that can get the job done without too much hassle.
Also, if there’s a free way to extract audio from mp4 file, that would be awesome! I’ve heard about some programs like Audacity or VLC Media Player, but I’m not sure how to use them for this purpose.
Thanks in advance for your help!
Hey everyone! I’m trying to extract the audio from an MP4 video file and save it as an MP3 so I can play it on my car. Unfortunately, I’m not super tech-savvy, so I’m looking for a simple method or software that can get the job done without too much hassle. Also, if there’s a free way to extract audio from mp4 file, that would be awesome! I’ve heard about some programs like Audacity or VLC Media Player, but I’m not sure how to use them for this purpose. Thanks in advance for your help! Read More
Issue with Deep Link to Meeting Side Panel in Microsoft Teams
Dear Team,
I hope this message finds you well.
We are currently experiencing an issue with the deep link to the meeting side panel in Microsoft Teams. Despite following the documentation provided at the link below, the functionality is not working as expected:
Deep Link to Meeting Side Panel Documentation
When attempting to use the deep link, we encounter the following issue:
Instead of opening our custom application in the side panel, the meeting window opens with the chat displayed on the right-hand side.And in the background, I am getting the below error.
We would appreciate your assistance in resolving this matter, as the deep link is a critical component for our application integration within Microsoft Teams.
Thank you for your prompt attention to this issue.
Best regards,
Sukesh PK
Dear Team, I hope this message finds you well.We are currently experiencing an issue with the deep link to the meeting side panel in Microsoft Teams. Despite following the documentation provided at the link below, the functionality is not working as expected:Deep Link to Meeting Side Panel DocumentationWhen attempting to use the deep link, we encounter the following issue:Instead of opening our custom application in the side panel, the meeting window opens with the chat displayed on the right-hand side.And in the background, I am getting the below error. We would appreciate your assistance in resolving this matter, as the deep link is a critical component for our application integration within Microsoft Teams. Thank you for your prompt attention to this issue. Best regards,Sukesh PK Read More