It is becoming more common that the switch has port security turned on. This means only one MAC can plug into any single port. It is not a big deal to reset it, but for some reason I could not find a direct answer. Here is mine; Reset sticky bit Examples; show port-security clear port-security […]
Add TEAMS Toll-Free Number
The simple You have to add minutes from the add-on section called “Communication Credits” and then a new check box will appear under licenses for the user, check it. Then you have to go into the TEAMS management console add the new Toll-Free number This Number can’t be default Now assign it to the conference […]
Add comment to GPO
Not much to say here. In Group Policy Management > select root level > Properties > Comment
Remove Password protection from Microsoft Excel sheet
How to Remove an Excel Spreadsheet Password in 6 Easy Steps rename to .zip open xl\worksheets find and delete the sheetprotection hash, everything in <> It will look something like: <sheetProtection algorithmName=”SHA-512″ hashValue=”x9RyFM+j9H4J3IFFhsHo3q1kQkuLydpJlLh2mdvfvk15He/Yps8xizWt/XkAJ//g+TyqgcU+8o1QBjQvKDqIzg==” saltValue=”57YXDPnVjawU5s1nGyT8fQ==” spinCount=”100000″ sheet=”1″ objects=”1″ scenarios=”1″/>
Restart a Service Remotely with Powershell
I have found lots of fancy ways, but here is my one(two) liner (get-service -ComputerName server01 -Name wuauserv).stop (get-service -ComputerName server01 -Name wuauserv).start
Force Delete a File
WARNING!!! THIS WILL FORCE DELETE FILES, USE AT YOUR OWN RISK!!! This one has hounded me many times, and I thought I already did a KB for this, but apparently not, so here goes; First make sure everyone is off, I use the MS file sharing MSC, “Share and Storage Management”. On the […]
SharePoint Online Time Out
Just a quick on this. a great link is here; https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Idle-Session-Timeout-Policy-in-SharePoint-Online-amp-OneDrive-is/ba-p/211274 PS C:\Windows\system32> Connect-SPOService -Url https://<tenent>-admin.sharepoint.com PS C:\Windows\system32> get-SPOBrowserIdleSignOut Enabled WarnAfter SignOutAfter ——- ——— ———— True 00:05:00 00:30:00 PS C:\Windows\system32> Set-SPOBrowserIdleSignOut -Enabled $true -WarnAfter (New-TimeSpan -Seconds 2700) -SignOutAfter ( New-TimeSpan -Seconds 3600)
Password Complexity Doesn’t Matter
This is the third time I have heard this, and it seems to be gaining tracktion. https://techcommunity.microsoft.com/t5/Azure-Active-Directory-Identity/Your-Pa-word-doesn-t-matter/ba-p/731984
Add Images to Word from Command (Powershell)
Really all the credit has to go to u/Pandapokeman on reddit. All I did was add a single line that added the file name to the bottom of the picture. https://www.reddit.com/user/Pandapokeman/ Here is his script (be sure to use the full file path in the command) Function Add-OSCPicture { <# .SYNOPSIS Add-OSCPicture is an advanced […]
SA Password Reset
There are a bunch of blogs out there that show how to do it, but I always seem to have problems. Anyway, here is my last attempt, and what I did to fix it (It is also case sensative)(DO NOT copy paste, type these out manually); SQLCMD -L “List instances it can see” Reset the […]