micmaher

#Requires -Version 4.0
<#
    .SYNOPSIS
        Gets the Firewall State for for a local, remote or a piped list of machines

    .DESCRIPTION
        Will require PowerShell 4.0 or later
        Gets Public, Private and Domain Profiles

    .EXAMPLE

micmaher

 Function Get-TaskDuration {
<#
    .SYNOPSIS

        Returns the duration (execution time) of the most recent run of the specified scheduled task.
        Michael Klement did a great deal of this

    .DESCRIPTION

        Returns the execution time of the most recent completed run of the specified scheduled tasks as [timespan] instances.

micmaher

$DDI='YOUR ID HERE'
$Region = 'YOUR SITE HERE'
$AuthToken = "YOUR TOKEN HERE"
$URI="https://$region.images.api.rackspacecloud.com/v2/$DDI/tasks/"

# ImageID
$imageid = 'YOUR IMAGE ID HERE'
$container = "YOUR CONTAINER HERE"

# Request Headers

micmaher

USE [build]
GO

/****** Object:  StoredProcedure [dbo].[inserthotfixPresent]    Script Date: 26/04/2016 17:21:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

micmaher

# PowerShell 2.0 Compatible Web Call deployed as an SCCM Package

$h = get-hotfix | where {$_.HotFixID -eq 'KB3050265'}

If ($h){
    # Already Installed  
    $uri = "http://webserver/winupdate/wuaccept.asp?installed='$env:COMPUTERNAME','Yes'"
    (New-Object System.Net.WebClient).DownloadString($uri)
    Exit
}

micmaher

Function Set-PSEnv{
<#
.SYNOPSIS
   Customise PowerShell Environment
.DESCRIPTION
   Can set up PowerShell profile
   Can Set up Package Management (PowerShell Gallery), Chocolatey, Implicit Remoting, Themes, 
   Can map a PSDrive to OneDrive, Update Help
.NOTES
   Author: Michael Maher

micmaher

$csvFile = "C:\temp\CtxGroups2.csv"
import-module activeDirectory

############################### 	1. Get the Citrix Groups 					################################
# Run in MWTRADERS Domain

Get-ADGroup -Filter * -SearchBase "ou=Retail,ou=Dublin,dc=contoso,dc=com" | Select Name, distinguishedName | Export-Csv $csvFile

break
################################ 	2. Create a Domain Local equivalent on IE 	################################

micmaher

# Michael Maher
# 22/5/13
# Get ACLs from CSV and write to AD

$arrRecord = @()
$spreadsheet = Import-Csv C:\scripts\ACLs2.csv

# Get just the mailbox name which will be used to create group names later
# Store this in an array so we can sort it and get unique values later
# Also need a second array with the full email address and ACL for applying permissions later

micmaher

Function Get-FreshADUser
<#
.Synopsis
   Check for users created in AD since (x) days

.DESCRIPTION
   Lists users created in AD since specified date
   The number of days to check back is a mandatory prarmeter
   Useful in a domain migration scenario

micmaher

USE [build]
GO
/****** Object:  StoredProcedure [dbo].[EPOLastLogon2]  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ================================================================
-- Author:		Michael Maher
-- Create date: 12th June 2014