Intuit and Windows 7 – End of Life As of January 14, 2020, Microsoft will no longer provide security updates or support for PCs running Windows 7. This means that computers running on Windows 7 will be more vulnerable to security risks and viruses. To avoid these risks, Microsoft recommends upgrading to Windows 10. –Read […]
Basic Cisco Switch Configuration
Basic steps needed to configure and setup a Cisco switch from scratch. I. Connect to the device via consoleUsing software such as PuTTY, connect to the console of the switch. You’ll get the initial command prompt Switch> Type enable and hit enter. You’ll get into priviled EXEC mode Switch# Now, get into Global Configuration Mode: […]
Set Default Calendar Sharing Permissions for all users
Open Notepad Copy the following cmdlets and edit as required: 3. Save the file as a PowerShell Script file. 4. Open Windows PowerShell 5. Run your script file 6. Enter your Office 365 admin credentials and click ok Access Rights Roles Author CreateItems, DeleteOwnedItems, EditOwnedItems, FolderVisible, ReadItems Contributor CreateItems, FolderVisible Editor CreateItems, DeleteAllItems, DeleteOwnedItems, EditAllItems, EditOwnedItems, […]
Excel Formula SUM Functions
SUM functions Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers—but it doesn’t just sum. It also subtracts, multiplies, divides, and uses any of the comparison operators to return a result of 1 (true) or 0 (false). You […]
Superfetch 100% disk usage
Superfetch is a Windows service that is intended to make your applications launch faster and improve your system respond speed. It does so by pre-loading programs you frequently use into RAM so that they don’t have to be called from the hard drive every time you run them. If this service is affecting your computer performance, […]
How to list Windows 10 Upgrades
Do you need to know when a particular upgrade for windows 10 was done? Open Powershell Open Windows PowerShell and run the following two cmdlets PS > $AllBuilds = $(gci “HKLM:\System\Setup” | ? {$_.Name -match “\Source\s”}) | % { $_ | Select @{n=”UpdateTime”;e={if ($_.Name -match “Updated\son\s(\d{1,2}\/\d{1,2}\/\d{4}\s\d{2}:\d{2}:\d{2}))$”) {[dateTime]::Parse($Matches[1],([Globalization.CultureInfo]::CreateSpecificCulture(‘en-US’)))}}}, @{n=”ReleaseID”;e={$_.GetValue(“ReleaseID”)}},@{n=”Branch”;e={$_.GetValue(“BuildBranch”)}},@{n=”Build”;e={$_.GetValue(“CurrentBuild”)}},@{n=”ProductName”;e={$_.GetValue(“ProductName”)}},@{n=”InstallTime”;e={[datetime]::FromFileTime($_.GetValue(“InstallTime”))}} }; PS > $AllBuilds | Sort UpdateTime […]
How to Export a List of Email Addresses from Office 365
To export the list of users and emails addresses from Office 365 along with the first and last name of the users: Start PowerShell Run the following commands $LiveCred = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange – ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred – Authentication Basic -AllowRedirection Import-PSSession $Session 3. To export Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,PrimarySmtpAddress, @{Name=”EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString […]
How to Start a Manual Active Directory Sync to Office 365
By Default, Active directory synchronization happens every 30 minutes and it runs on the Server you Installed Azure AD on. Log In to the Server you’ve Installed Azure AD Sync and open PowerShell. In the PowerShell windows type the cmdlet below: Start-ADSyncSyncCycle -PolicyType Delta
Excel Formula REPT
When Lotus 1-2-3 was the only game in town, you could enter a backslash followed by any character and Lotus would repeat that character throughout a cell. If the cell width grew larger or smaller, so did the character. In Excel, this feature is handled by the function REPT. It’s not quite as efficient because […]
Excel Formula RAND
The RAND function is really simple and traditionally used for statistical analysis, cryptography, gaming, gambling, and probability theory, among dozens of other things. In Excel, the RAND function generates a random number between 0 and 1. Note; however, that every time you enter new data and press the Enter key, the list of random numbers […]