Hello all,

I am looking at the SharePoint Admin Center > Sites > Deleted Sites page

And there are multiple columns available, including Site name, URL, Storage used (GB) just to name a few.

But I am confused by the Date Created and Time Deleted columns, they do not appear to coordinate with what I know as the dates and times these sites were created and/or deleted. I know these columns are likely deemed self-explanatory, but again, I know that the dates and times shown are not accurate.

I’ve been searching the web for a couple days and all I’m finding are instructions on how to restore a deleted site, perhaps my Google-Fu is failing terribly, but is there any documentation concerning this page that includes the column definitions and how their data is derived?

Thanks in advance,

-David Covert

​Hello all, I am looking at the SharePoint Admin Center > Sites > Deleted Sites pageAnd there are multiple columns available, including Site name, URL, Storage used (GB) just to name a few.But I am confused by the Date Created and Time Deleted columns, they do not appear to coordinate with what I know as the dates and times these sites were created and/or deleted. I know these columns are likely deemed self-explanatory, but again, I know that the dates and times shown are not accurate. I’ve been searching the web for a couple days and all I’m finding are instructions on how to restore a deleted site, perhaps my Google-Fu is failing terribly, but is there any documentation concerning this page that includes the column definitions and how their data is derived? Thanks in advance, -David Covert  Read More

​

First off, I have no idea why what I’m about to type is not published in the existing Copilot in Word training materials produced by Microsoft. Nevertheless, if you are trying to use the pre-fetched files or trying to type in file names and they aren’t showing up….here is how to get around all of that. Also, it does require some pre-work in step number 1 – but this is a one time deal.

Search for clipboard settings in your Windows settingsTap the windows button on your keyboard and type clipboard…select “clipboard settings”Turn on “Clipboard History” to “On” if it isn’t on alreadyNavigate to the location of the file you want to reference (OneDrive/SharePoint)Open the details pane for the file and scroll down to the bottom to the “Path” section and click the icon. This copies the absolute URL (just the straight up path – no garbage included) to the fileRepeat as necessary until you have up to 3 file paths copiedGo to your Copilot prompt and type what you want to happen with the files you are about to reference from your clipboard (summarize, rewrite, create new file based on…..)Within that same prompt, hold down the windows button and press “V”This will bring up your clipboard history (if you followed the 1st step above correctly)Now you can paste in the URLs of the files you want to referenceYou will know the files were found/accepted after you hit the space bar as the URL will resolve into a hyperlink with the title of the file3 files is currently the max you can reference in one prompt

Yes this is a bit manual – however I see no other way to reference a file if it doesn’t show up in the prefetch window or when you start typing the name of the file.

Good luck and please let us know if this works for you!

​First off, I have no idea why what I’m about to type is not published in the existing Copilot in Word training materials produced by Microsoft. Nevertheless, if you are trying to use the pre-fetched files or trying to type in file names and they aren’t showing up….here is how to get around all of that. Also, it does require some pre-work in step number 1 – but this is a one time deal. Search for clipboard settings in your Windows settingsTap the windows button on your keyboard and type clipboard…select “clipboard settings”Turn on “Clipboard History” to “On” if it isn’t on alreadyNavigate to the location of the file you want to reference (OneDrive/SharePoint)Open the details pane for the file and scroll down to the bottom to the “Path” section and click the icon. This copies the absolute URL (just the straight up path – no garbage included) to the fileRepeat as necessary until you have up to 3 file paths copiedGo to your Copilot prompt and type what you want to happen with the files you are about to reference from your clipboard (summarize, rewrite, create new file based on…..)Within that same prompt, hold down the windows button and press “V”This will bring up your clipboard history (if you followed the 1st step above correctly)Now you can paste in the URLs of the files you want to referenceYou will know the files were found/accepted after you hit the space bar as the URL will resolve into a hyperlink with the title of the file3 files is currently the max you can reference in one promptYes this is a bit manual – however I see no other way to reference a file if it doesn’t show up in the prefetch window or when you start typing the name of the file. Good luck and please let us know if this works for you!  Read More

​

1. Introduction

We recently introduced a OneDrive Sync Health dataset in Microsoft Graph Data Connect. This provides a list of all devices running Sync, including details about whether they have enabled Folder Backup and are running into any errors. This ensures that any files being created or updated are properly synchronized with the OneDrive cloud. This makes sure that even if your computer is lost or broken, your files are safely stored.

However, there is another potential issue you should track as a OneDrive administrator. There could be users that are not running OneDrive Sync at all. These users could be saving files locally to their desktops or laptops without enabling OneDrive Sync. If their computer runs into any issues, they might find that their OneDrive in the cloud was not being updated at all.

This article explains how you can use the MGDC to get data about OneDrive sites and Sync Health to identify users that are not properly running Sync.

2. Grab the datasets

To get started, you need to get the two required MGDC datasets: Sites and Sync Health.  To pull them, follow the instructions below:

Step-by-step: SharePoint Sites
Step-by-step: OneDrive Sync Health

The Sites dataset includes one object for each SharePoint site in the tenant. That includes every OneDrive, which is essentially just a type of SharePoint site. You can identify a OneDrive site by the template id (OneDrive uses template id 21).

The Sync Health dataset includes one object for each device running OneDrive Sync. This includes any attempt to synchronize in the last 30 days. It is important to note that if the user never enabled OneDrive Sync or has not attempted to synchronize in the last 30 days, there will be no data for that user in the Sync Health dataset.

Note: Some of the instructions are the same for both datasets. You can re-use things like the application registration, Azure storage account, MGDC consent and some of the Synapse resources.

3. Load into Power BI

The last step in the step-by-step instructions above is to load the datasets into Power BI. For this step, make sure to use Power BI desktop and load the two datasets into the same PBIX file.

After you’re done, the “Data” section on the right should show the two datasets. I would suggest renaming the datasets to “Sites” and “SyncHealth” instead of keeping the default names you get after you load the JSON files.

To rename them, just collapse the two datasets on the “data” section on the right (to make it easier to see them), then right-click the dataset name and use the “Edit query” option.

4. Filter the Sites for OneDrive

While editing the query for the Sites dataset, you can add a filter to include only the sites that are of type OneDrive. This is basically a filter on the RootWeb.TemplateId column where it equals 21. Simply find the arrow next to that column to enable a filter.

5. Manage relationships

With both datasets loaded into Power BI, you can now add a relationship between them. In the relationship view, click the “Manage relationships” in the bar. Or you can right click the dataset set on the Data section and select “Manage Relationships”.

You want to create a one-to-many relationship between Sites and Sync Health, matching the Site’s Owner.Email with Sync Health’s UserEmail.

6. Visualize using a table

Finally, create the visualization to see which OneDrive sites have no matching device in the Sync Health relationship. I used a simple “Table” visualization, pulling columns from either Sites or SyncHealth. Now that we have a relationship between the two, Power BI knows how to match data coming from both sides.

Note that I have renamed some columns in the table. There is an option to “rename for this visual” if you right click a column under “Visualizations”.

Also make sure to select the option to “Show items with no data” when adding Sync Health columns. This will make sure you show the sites with no matching device in Sync Health.

Here’s what your table can look like:

7. Conclusion

I hope this post helped you understand how to find OneDrive users that are not running OneDrive Sync. For more information about these and other scenarios in Microsoft Graph Data Connect for SharePoint, see the overview post at https://aka.ms/SharePointData.

​Microsoft Tech Community – Latest Blogs –Read More 

You’ve asked how to manage mobile and bring-your-own-device (BYOD) scenarios. With mobile device management (MDM), of course! Device management is an important part of a larger security strategy, so we’ve collected resources to help you get started or improve with MDM. Learn about deployment and management of Windows and various mobile platforms, endpoint and app management, update management, and how to handle management and deployment as securely as possible.

Time to learn: 136 minutes

READ

Mobile device management for Windows overview

Start managing company security policies and business applications while maintaining user privacy on personal devices. Check the MDM security baseline for your Windows versions as well as Windows editions and licensing requirements for Windows built-in management.

(4 mins)

Windows + Server + Policies + Security + Enrollment + Management + Protocol + Entra + FAQ

READ

What does device management mean?

Microsoft Intune is designed for management of mobile devices and applications. Learn about its features, benefits, and capabilities to manage various platforms including Windows. Choose the management solution that’s right for you, in the cloud or on premises.

(4 mins)

Intune + MDM + MAM + Apps + Windows + Android + iOS + iPadOS + Linux + macOS + ConfigMgr + Co-management

READ

Deployment guide: Manage devices running Windows

Here’s how to use Microsoft Intune to protect and manage Windows apps and endpoints. First, check your prerequisites and plan for deployment. Then, create compliance policies, configure endpoint security and device settings, and set up authentication methods. Finally, deploy apps, enroll devices, and run remote actions. Don’t forget to check out the next steps and help for employees and students.

(15 mins)

Intune + Admin Roles + Compliance + Policies + Access + Security + Apps + Authentication + Entra ID + Defender

WATCH

Provide access to on-premises resources for mobile devices using Microsoft Tunnel

Do users at your organization need access to resources that are located on premises? Learn about Microsoft Tunnel, which provides a secure, simple, and zero-trust-based solution for your mobile devices. Watch the explanation of its architecture, installation, configuration, and deployment for iOS and Android.

(26 mins)

Access + Tunnel + Cloud + On-premises + iOS + Android + Security

Enroll mobile devices in Microsoft Intune

Enrollment guide: Enroll Android devices in Microsoft Intune (17 mins)

Learn about the multiple options for enrolling Android devices in Microsoft Intune. These include BYOD devices with a work profile, Android Enterprise corporate owned dedicated devices and corporate owned fully managed devices, Android Enterprise corporate owned work profile, Android Open Source Project, and Android device administrator. Read an overview of the administrator and user tasks for each option and download visual guides.

Enrollment guide: Enroll iOS/iPadOS devices in Microsoft Intune (30 mins)

Choose the best way to enroll iOS and iPadOS devices in Microsoft Intune. Learn the difference among automated device enrollment (ADE) (supervised), Apple Configurator enrollment, and user and device enrollment. Find a list of administrator and user tasks for each option in this official documentation.

Intune + Android + iOS + iPadOS + BYOD + Enterprise + AOSP + ADE + Company Portal

Manage apps with Microsoft Intune

Microsoft Intune app management (1 min)

Easily manage apps on company-managed devices, whether they are organization-owned or personal. This functionality is called mobile application management (MAM). Watch this brief introduction to the topic before diving deeper!

What is Microsoft Intune app management? (9 min)

Start with the basics of MAM here. With Microsoft Intune, you can publish, push, configure, secure, monitor, and update mobile apps across your organization. Whether or not you choose to couple it with device management, you’ll find a range of capabilities by platform, a get-started guide, and additional functionalities to consider.

Data protection for Windows MAM (6 min)

Protect corporate data on personal devices used for work. Learn about Conditional Access compliance and threat defense health. Then create important Intune app protection policies (APP) with this guidance. Note: Windows MAM is supported in government cloud environments.

MAM + MDM + LOB + Apps + M365 + iOS + Android + Policies + Compliance + Admin Center + ACP + APP + GCC High + DoD + Security + Conditional Access + MTD + Data Protection + Health Checks

BOOKMARK

Microsoft Intune prescriptive guidance library

Save this library of interactive tutorials to learn how to use Intune as your MDM solution. Learn how to configure Conditional Access, deploy and manage line-of-business (LOB) applications, set up Windows Autopilot for new device delivery, update Windows from the cloud, and enable Universal Print.

Intune + MDM + Security + Apps + Autopilot + Updates + Universal Print

WATCH

Balancing security and flexibility when implementing Windows Defender Application Control (WDAC)

Consider WDAC as part of your MDM strategy. It’s a more comprehensive solution than AppLocker. Check out the video and chat comments for tips on how you can convert AppLocker policies to WDAC policies and get started with WDAC today.

(19 mins)

WDAC + Intune + Defender + MDE + App + Security + Allowlisting + Policies + Managed Installer

READ

Deploy WDAC policies using mobile device management (MDM)

If you use Microsoft Intune, configure WDAC with built-in policies. To customize the available configuration, you can configure a profile using custom Open Mobile Alliance-Uniform Resource Identifier (OMA-URI) settings. Follow our step-by-step guide to deploy or remove WDAC policies.

(5 mins)

WDAC + Intune + OMA-URI + CSP + Policies + AppLocker

Go deeper on the following MDM-related topics:

Skilling snack: Go cloud first with Windows device management
Skilling snack: Windows Autopilot 101
Skilling snack: Windows Autopatch
Skilling snack: Best practices for shared and frontline Windows devices
Skilling snack: Windows application security

Thanks for putting in your order for this skilling snack on mobile device management! Leave us a comment below or in our skilling snack library with additional topics you’d like to savor. Remember that we add fresh items to the menu every other week. Tell a friend.

Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.

​Microsoft Tech Community – Latest Blogs –Read More 

Greetings, we continue our series of posts this week that show how you can get help from copilot with the chat helper. Copilot in Excel can help you to find the right function for a task and can also help you if you know what function you want to use but need help with an example. We’ll show this by asking Copilot in Excel the following question:

Can you give me an example of how to use =textafter in Excel?

Copilot in Excel analyzes the question and returns the response below, explaining how to use the TEXTAFTER function:

Picture of Copilot in Excel pane showing the above prompt with a description of the TEXTAFTER function and how to use it.

“Certainly! The =TEXTAFTER function in Excel is used to extract text that comes after a specific delimiter in a given string. Here’s an example of how to use it:

Suppose you have a list of email addresses in column A, and you want to extract the domain part of the email (the part after the “@”). You can use the =TEXTAFTER function to do this.

Here’s the formula you would use in cell B1 and then drag down to apply to other cells in the column:

=TEXTAFTER(A1, “@”, , 1)

A1 is the cell containing the email address.
“@” is the delimiter after which you want to extract the text.
The third argument is left blank to use the default behavior, which is to return the text after the first occurrence of the delimiter.
1 specifies that you want to extract the text after the first occurrence of the “@” symbol.

If the “@” symbol is not found in the text, the function will return an error by default. You can modify the behavior by adding an additional argument to specify a different outcome when the delimiter is not found.”

Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Greetings, we continue our series of posts this week that show how you can get help from copilot with the chat helper. Copilot in Excel can help you to find the right function for a task and can also help you if you know what function you want to use but need help with an example. We’ll show this by asking Copilot in Excel the following question:
Can you give me an example of how to use =textafter in Excel?
Copilot in Excel analyzes the question and returns the response below, explaining how to use the TEXTAFTER function:
Picture of Copilot in Excel pane showing the above prompt with a description of the TEXTAFTER function and how to use it.
 
“Certainly! The =TEXTAFTER function in Excel is used to extract text that comes after a specific delimiter in a given string. Here’s an example of how to use it:
Suppose you have a list of email addresses in column A, and you want to extract the domain part of the email (the part after the “@”). You can use the =TEXTAFTER function to do this.
Here’s the formula you would use in cell B1 and then drag down to apply to other cells in the column:
=TEXTAFTER(A1, “@”, , 1)

A1 is the cell containing the email address.
“@” is the delimiter after which you want to extract the text.
The third argument is left blank to use the default behavior, which is to return the text after the first occurrence of the delimiter.
1 specifies that you want to extract the text after the first occurrence of the “@” symbol.

If the “@” symbol is not found in the text, the function will return an error by default. You can modify the behavior by adding an additional argument to specify a different outcome when the delimiter is not found.”
 
Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​

Sub santo()
Set ws = Worksheets(“Filter”)
LastRow = Cells.Find(“*”, , xlValues, , xlRows, xlPrevious).Row
For i = 1 To 15
a = Array(ws.Range(a(i) & “1”).Value, ws.Range(a(i) & “2”).Value, ws.Range(a(i) & “3”).Value, ws.Range(a(i) & “4”).Value)
Sheets.Add.Name = a(0)
With Worksheets(“Sales Data”).Range(“A1” & LastRow)
.AutoFilter Field:=4, Criteria1:=Array(a(1), a(2), a(3)), Operator:=xlFilterValues
.SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets(a(0)).Range(“A1”)
End With
Next
End Sub​ 

​Sub santo()
Set ws = Worksheets(“Filter”)
LastRow = Cells.Find(“*”, , xlValues, , xlRows, xlPrevious).Row
For i = 1 To 15
a = Array(ws.Range(a(i) & “1”).Value, ws.Range(a(i) & “2”).Value, ws.Range(a(i) & “3”).Value, ws.Range(a(i) & “4”).Value)
Sheets.Add.Name = a(0)
With Worksheets(“Sales Data”).Range(“A1” & LastRow)
.AutoFilter Field:=4, Criteria1:=Array(a(1), a(2), a(3)), Operator:=xlFilterValues
.SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets(a(0)).Range(“A1”)
End With
Next
End Sub​   Read More

​

When I add a IPP Printer, it works fine until I restart OS, after system reboot the requesting-user-name contains WORKGROUPVM132786998$ so it’s domaincomputerName$. And the user cannot be correctly recognized.

Steps to reproduce it:
1. Add IPP printer
2. Print Test page
3. Restart system
4. Print Test page

Current result if inspecting by Wireshark:
at point 2. requesting-user-name contains correct “Administrator” value
at point 4. requesting-user-name contains incorrect “workgroupVM132786998$

Expected result: in both cases correct value Administrator must be present.

Currently only restart print spooler or recreating printer solves the issue. (See attached wireshark captures before and after print spooler restart)

Note: The issue is not reproducible in build 22H2 22621.3447. I’m able to reproduce it in 23H2 22635.4076.

Same error is observed here (comment from Douglas Kosovic): https://learn.microsoft.com/en-us/answers/questions/1428508/ipp-everywhere-ipp-2-0-server-basic-authentication

Attached screenshots from wireshark captures when it’s happening and after restarting Print Spooler.

​When I add a IPP Printer, it works fine until I restart OS, after system reboot the requesting-user-name contains WORKGROUPVM132786998$ so it’s domaincomputerName$. And the user cannot be correctly recognized. Steps to reproduce it:1. Add IPP printer2. Print Test page3. Restart system4. Print Test page Current result if inspecting by Wireshark:at point 2. requesting-user-name contains correct “Administrator” valueat point 4. requesting-user-name contains incorrect “workgroupVM132786998$ Expected result: in both cases correct value Administrator must be present.Currently only restart print spooler or recreating printer solves the issue. (See attached wireshark captures before and after print spooler restart) Note: The issue is not reproducible in build 22H2 22621.3447. I’m able to reproduce it in 23H2 22635.4076. Same error is observed here (comment from Douglas Kosovic): https://learn.microsoft.com/en-us/answers/questions/1428508/ipp-everywhere-ipp-2-0-server-basic-authenticationAttached screenshots from wireshark captures when it’s happening and after restarting Print Spooler.   Read More

​

I cannot upload images. It kept giving me this message “The file couldn’t be uploaded. Please try again” How can I solve this?

​I cannot upload images. It kept giving me this message “The file couldn’t be uploaded. Please try again” How can I solve this?  Read More

​

Check out the latest expert briefings, Teams Insider Podcast, Microsoft Teams Operator Connect updates and upcoming community events.

Expert Briefings

Searching for Teams Messages

https://app.empowering.cloud/briefings/372/searching-for-teams-messages

In our latest community briefing, MVP Nikki Chapple explains the three methods to search Microsoft Teams messages.

The three methods to search for Teams Messages are:

User search, content search and eDiscovery Standard

User Search: For end-users, quick and shows threaded conversation, security trimmed
Content Search and eDiscovery Standard: For admins, searches entire tenant but is limited to individual messages
eDiscovery Premium: Comprehensive search for admins, shows threaded conversations, detailed export

Microsoft Teams Monthly Update August 2024

https://app.empowering.cloud/briefings/373/Microsoft-Teams-Monthly-Update-August-2024

MVP Tom Arbuthnot runs through the latest Microsoft news and updates you need to know this month.

Microsoft Earnings FY24 Q4 Modern Work Insights
Multiple Teams Client Improvements
Custom Emojis and Reactions
Copilot Dashboard for all M365 Copilot users
Speaker recognition for all Teams Rooms on Windows
Microsoft Teams Rooms on Windows 5.1.24.0
Microsoft Teams Devices updates
Android Teams Room and Teams Phone support date changes
Teams Displays end of support September 2025
Roadmap Watch

Microsoft Teams Insider Podcast

Microsoft Mesh, Real-world Use cases and AI Futures

Audio Podcast | YouTube

Jeremy Dalton, Head of Immersive Technologies at PWC and Cathy Moya, Senior Customer Success Program Manager – Mesh Team at Microsoft, dive into Microsoft Mesh adoption and use cases and how virtual reality and virtual worlds can enhance collaboration and communication.

AV and UC Converging with John Bailey, Senior Vice President AVI-SPL

Audio Podcast | YouTube

John Bailey, Senior Vice President of Technology and Innovation at AVI-SPL, discusses industry changes and the convergence of AV and IT.

Microsoft Devices Ecosystem Platform (MDEP) Explained

Audio Podcast | YouTube

Yoav Barzilay, Microsoft Senior Product Manager, explains the Microsoft Devices Ecosystem Platform (MDEP) and how it fits in the Microsoft Teams devices ecosystem.

Lessons from BT’s Large Scale Microsoft Teams Rooms Deployment

Audio Podcast | YouTube

James Robinson, Director & Principal AV Consultant at AVenture Audio Visual, shares his extensive previous experiences with deploying Microsoft Teams Rooms at scale at BT.

Microsoft Teams Operator Connect Updates

The race to 100 countries or 100 operators continues with both countries and operators at the 97 mark. There’s not too much to report here this month, although providers continue to be extending their Microsoft Teams Operator Connect coverage to more countries.

Providers Change:

Momentum – Canada and USA

Country Changes:

HALO – USA
LoopUp – Republic of Korea
Orange Business Services – Mexico
Tata Communicaitons – Uganda, South Africa and Dominican Republic

Check out our full Power BI report of all the Operators here:

https://members.empowering.cloud/microsoft-teams-operator-connect-providers

Upcoming Community Events

Teams Fireside Chat with Ron Pessner – 12th September | 16:00 BST | Virtual

Join other community members for the September Teams Fireside Chat where Ron Pessner, Microsoft Corporate Vice President – Product Management, will be joining us to share his insights.

Teams Fireside Chat occurs on the 2nd Thursday of every month at 16:00 UK. For each session, we are joined by a guest speaker from Microsoft who shares their insights. In the second half, we open the floor to discussion and Q&A, giving you the chance to get your questions answered by the experts.

Microsoft Teams Devices Ask Me Anything

September Sessions

EMEA/NA – 16th September | 16:00 BST | Virtual

Hosts: MVP Graham Walsh, Michael Tressler, Jimmy Vaughan

APAC – 17th September| 15:30 AEST | Virtual

Hosts: MVP Graham Walsh, Phil Clapham, Andrew Higgs, Justin O’Meara

Microsoft Teams Devices Ask Me Anything is a monthly community which gives you all an update on the important and Microsoft Teams devices news, as well as the chance to ask questions and get them answered by the experts. We have 2 sessions to cover different time zones, so there’s really no excuse not to come along to at least one!

​Microsoft Tech Community – Latest Blogs –Read More