User Profile
coxygt
Brass Contributor
Joined Mar 10, 2021
User Widgets
Recent Discussions
Running Un-attended Scripts via Task Scheduler
I am trying to get some of my PS Scripts that are required regularly to run un-attended on a server using Task Scheduler. I am aware that App Registrations seem to be the recommended way, but I am struggling to find the best way to plan and deploy a solution. For example, one of the jobs I want to automate is a search using Exchange get-messagetracev2, I have created a service account, given the account Delegate Full Access permissions to 31 shared mailboxes I need to report on. Basically, I need to know how many emails have been received during the previous week to each mailbox. Generate a csv, list the mailbox, start date - end date, number of emails received, then ideally either email 3 users the report, or send a Teams notification (using Workflow Bot) to send a notification that the report is ready and the file is attached. I must be using the least permissive method of doing this, looking for ways to achieve this with the lowest level of access and to understand the best config for the App Registration, can I use Delegate or must it be App permissions? Thanks in advance59Views0likes1CommentPreventing creation of sub-folders
I have been creating some new group connected SPO sites. I have been asked to restrict users from creating sub-folders for some of the base folders. Structure is as follows: Shared Documents General Folder 1 Folder 2 Folder 3 I want to allow users to create folders in Folder 1 and 2, but for Folder 3, not be able to create sub-folders, BUT they must still be able to create and modify files. Is this even possible, ideally looking for a PowerShell solution, anyone have any pointers?Adding an Entra Group as Site Collection Admins to all sites in SharePoint online
I am trying to get an Entra Group added as SCA to every SPO site in my tenant, I have found the claim ID for the Group but when the script is run using an account with SharePoint Admin, some sites work, some fail with various errors, below is a few: Failed: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Failed: User cannot be found. Failed: Attempted to perform an unauthorized operation. Failed: The underlying connection was closed: An unexpected error occurred on a receive. Failed: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. I am struggling to see why this fails, I am SharePoint Admin, have connected to sposervice ok, sure this was run a few years ago without issue, there are just over 9,500 sites showing in SP Admin.260Views0likes1CommentHow to report SharePoint URL for all Entra Groups
I am looking to report all Entra Groups, the Group Site URL, Count of Owners, Members and Guests to the groups, then to also check each SharePoint online site, to see if any additional permissions have been added in SharePoint directly. Anyone know how you can pick up the actual Group SPO URL at all, Co-Pilot just want to use: https://your-tenant.sharepoint.com/sites/GroupName, but this doesn't always work depending on the name of the group etc?149Views0likes0CommentsTrying to report mail usage, internal vs externally sent messages
Hi, I am trying to find a way that I can report per user per day the number of messages sent, split between internal or external. My company has a few different domains that we class as Internal, checked the 365 Admin > Reports section but nothing there appears to provide the breakdown. Has anyone done this, if so, how exactly, don't mind if PowerShell or GUI272Views0likes0CommentsMoving files from SharePoint online to a mapped network drive
So I have been asked to move over 1,000 files from SPO to a mapped Network Drive hosted in Azure. I was looking to try and configure this using PowerShell if it's possible. I have a csv that holds the server relative URL to each file, a destination (m:\folder\folder) format, what's the best way to achieve this, PNP, Graph SDK? If anyone has done this or has a **bleep** good idea, please let me know as banging my head so far trying to get this moving.1.4KViews0likes3CommentsHow to see where Connectors are used in SharePoint online
Morning, So have just read MC793656 in the Message Centre of my companies tenant advising the retirement of 365 connects from SharePoint Online (SPO) webparts, but I cannot find any method on how to check if any of the sites on my companies tenant are using this, anyone know how this can be checked as I have over 9,000 sites on the tenant?1.6KViews0likes3CommentsRe: Unable to reconcile storage used according to tenant wide allotted space to what we actually use
Hi, Thanks for the reply, but I did state above that the site had been removed from retention before the content was deleted, from Doc Libraries, 1st and 2nd stage bins and then retention re-applied. I also checked the PHL and the content was not in there. Very confusing and frustrating in equal measures.873Views0likes0CommentsSharePoint online tenant storage figures not updating
Has anyone had a problem recently (within last 2-3 months) where the Tenant Storage figure top right corner of SharePoint Admin active sites page is not updating? I recently deleted 1.7TB of data from a site that had been removed from retention policies, 1st and 2nd stage bins but the 1.7TB never appeared as available, and I cannot see that it has been used up?609Views0likes0CommentsHow do you move files from SPO to Azure Storage
I have a question, I have a tenant with over 60TB, the site is pretty full, so I need to find a way to safely, and easily move un-used data from SPO to an Azure Files account. MS Archive has just gone to production but currently only allows to archive complete sites, the ability to move at file / folder level is not expected until back end of the year, has anyone undertaken such an operation and if so, how? Ideally, I would want to maintain folder structure where absolutely possible, the files may /may not be all files in folders (finding files not modified in last 2 years).221Views0likes0CommentsRe: Unable to reconcile storage used according to tenant wide allotted space to what we actually use
I am facing a similar issue. I recently deleted 1.7TB data from a SPO site, the site was taken out of retention, files deleted from the Doc Libraries, 1st stage bin, 2nd stage bin and then the site put back into retention, the 1.7TB has never appeared as available storage, in an ongoing battle with MS regarding this but is costing as we have to purchase more storage until they look at this properly.929Views0likes2CommentsCannot delete empty folders in OneDrive for Business
I have an end user who is trying to remove 2 empty folders from his ODB. The folders, live within Pictures\Camera Roll, and is used by his company phone to sync photos taken to his ODB. This has been turned off on the phone, but when trying to delete, a box appears reading " 1 item wasn't deleted. If attempting to delete a non-empty folder, it is possible that it is on hold". All SPO / ODB libraries are on retention, but he should still be able to delete items to the preservation hold library. Have checked eDiscovery Premium in case my end user is part of a Case in EDP (not), reset the oneDrive Sync client, it's performed a complete sync ok, but still cannot remove these folders, anyone have any ideas?3.1KViews0likes1CommentReporting all sites on tenant with file versioning sizes
I am wondering if there is a report or even a powershell script that can crawl every site on my companies tenant, report for each site, each document that has multiple versions so I can find out how much storage is being taken by versioning? I have 8000+ sites on the tenant, some of these I hope soon will fall to MS 365 SPO Archive, but for the active remaining sites, I know the limit for major versions is 500, but I am not 100% clear how that works. If a Spreadsheet as an example is 2MB, if there are 50 versions, does each version take up the full 2MB (or the size of the file for the specific version, will likely be smaller as less data in it), or does it only contain the actual changes that were made for each version?869Views0likes1CommentMonitoring all SPO Sites Storage Used Month by Month
Wondering if this is possible, but I have a requirement to be able to monitor every SPO site on my companies tenant, and to be able to pick up storage usage changes month by month. I am aware of the Site Usage Reports within 365 Admin, but currently they are broken (not showing URL), so wondering if anyone else does this, if so, be great to see how you do it. Need to see, site URL, Name, and current site storage used figures, storage allocated and last activity date.Solved729Views0likes1CommentShared Mailbox Audit in 365
I have been tasked with a review of all our Shared Mailboxes in my companies Tenant. We have around 550 to be looked at. What I need to know is the last date an email was received into the Shared Mailbox and the last time a mail was sent from it. Anyone do anything similar? Cannot use get-messagetrace as it only goes back 10 days max, ideally, I would need to be able to see at least 6 months back, longer if possible.901Views0likes1CommentFinding all preservation hold libraries and reporting size
Hi, My companies Tenant has over 7000 sites, I need to be able to identify all sites that have a Preservation Hold Library and then for each, report the size in either MB / GB of each. Don't mind if it's PowerShell / PNP or if there's a way within SharePoint Admin, anyone done this able to offer any advice? Thanks Steve1.4KViews0likes0CommentsCreating a Site Map
So I am researching if there is any built in way to generate a full Site Map in SharePoint online. We have a site setup as our Intranet, then I have a few thousand other sites, ideally, I would want only the Intranet site to be mapped, anyone know of any way to generate a site map?1.2KViews0likes1Comment
Recent Blog Articles
No content to show