draggeta / sysadmin-scripts

Some of my often used scripts/modules for work.

#Sysadmin Scripts

This repository contains various public scripts and modules I use. These are free to use and modify. If you have any comments or issues, don't hesitate to tell me or create an issue ticket. While there most likely are better scripts out there, I develop these to further my skills.

##Requirements

Most of these items should run in PowerShell 3.0 and higher. As I don't have systems with lower versions of PowerShell installed, I've not tested these on version 2.0. Most if not all of these will not run on PowerShell v1.0.

##Resources

###Modules Modules currently available or in development.

####O365-RestV1 Module to use the O365 REST API. It is currently lagging behind the v2.0 API version.

####O365-RestV2 Module to use the O365 REST version 2.0 API.

####O365-Tools Module to connect with less difficulty to Microsoft cloud services.

####OAuth2Helper Module to authenticate to the Microsoft API. Supports v1.0 and v2.0.

###Scripts

####Send-PasswordExpirationMail Currently functions. Trying to rewrite it to make it better.

####Set-O365LIcense Module to set up Office 365 Licenses. Works with a JSON configuration file and a simple HTML e-mail template.

sysadmin-scripts's Issues

Allow for an option to use Credential Manager

Currently the only way to supply credentials is in the script. This isn't secure. Might be better to find a way to pull saved credentials from the Credential Manager.

Create an array of all mails and send all in one go

Right now the Foreach-Object loop sends out an email in each loop. It might be better to aggregate all the mails and send them out in one go.

O365-Tools Add extra login options

Add options to connect to SharePoint via the OfficeDev SharePoint PNP, Azure AD RMS, Azure and Azure Resource Manager.

O365-Tools Allow for a cmdlet function to install all or specific prerequisites

Quite often a computer/server doesn't have the prerequisites installed. Installing these with a cmdlet would make things easier.

To do:

• Find URLs to applications
• Find silent install commands
• Write cmdlet around that

O365-RestV1 Add reminder option

Reminder for new appointments defaults to 15 minutes. Add an option to change it if wanted.

Configure logging

Right now the logging is lackluster. It would be better to write this to the eventlogs or a logfile.

O365-Tools Test if credentials are valid before executing

To avoid locking out an account if the user inputs an incorrect password and logs in to each Office 365 service, a way needs to be used to test the credentials once.

O365-RestV1 Get DST for the specified dates in the specified time zone

Right now I can only check if a time and timezone has DST. If it doesn't use daylight saving time, everything is good as the offset is always the base offset.

However, when a (non local) timezone does have DST, I cannot determine the correct offset as only the local (current computer) DST period is used.

Add parameters to make the script easier to use/adapt to different environments

Changing values in the script can be bothersome and some might be missed. It is probably better to use parameters.