This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Requires ActiveRoles CmdLets from Quest Software (They're free and awesome) - http://www.quest.com/powershell/activeroles-server.aspx | |
Get-QADUser -SizeLimit 0 | Select-Object samAccountName,mail,PasswordStatus | | |
Where-Object {$_.PasswordStatus -ne "Password never expires" -and $_.PasswordStatus -ne "Expired" -and $_.PasswordStatus -ne "User must change password at next logon." -and $_.mail -ne $null} | | |
ForEach-Object { | |
$today = Get-Date | |
$logdate = Get-Date -format yyyyMMdd | |
$samaccountname = $_.samAccountName | |
$mail = $_.mail | |
$passwordstatus = $_.PasswordStatus | |
$passwordexpiry = $passwordstatus.Replace("Expires at: ","") |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Requires ActiveRoles CmdLets from Quest Software (They're free and awesome) - http://www.quest.com/powershell/activeroles-server.aspx | |
Get-QADComputer -searchroot "OU=yourcomputerOUname,dc=yourdomain,dc=com" -SizeLimit 0 | | |
ForEach-Object { | |
$hostname = $_.name | |
$serialnumber = (Get-WMIObject Win32_BIOS -computer $hostname -ErrorAction SilentlyContinue).SerialNumber | |
if (-not $serialnumber) { | |
Add-Content d:\logfiles\offlinehosts.txt "$hostname is in offline" | |
} | |
else { | |
Write-Host "$hostname,$serialnumber" # output to screen |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Requires ActiveRoles CmdLets from Quest Software (They're free and awesome) - http://www.quest.com/powershell/activeroles-server | |
$old = (Get-Date).AddDays(-60) # Modify the -60 to match your threshold | |
Get-QADComputer -IncludedProperties pwdLastSet -SizeLimit 0 | where { $_.pwdLastSet -le $old } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
################################################################################ | |
# PowerShell routine to move Windows 7 Computers into OU structure based on IP # | |
################################################################################ | |
##################### | |
# Environment Setup # | |
##################### | |
#Add the Quest PowerShell snapin | |
Add-PsSnapIn Quest.ActiveRoles.ADManagement -ErrorAction SilentlyContinue |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
############################################# | |
# Split a log/text file into smaller chunks # | |
############################################# | |
# | |
# WARNING: This will take a long while with extremely large files and uses lots of memory to stage the file | |
# | |
# Set the baseline counters | |
# | |
# Set the line counter to 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PS C:\users\ewright\Documents\VirtualBoxProjects\Couch_to_OpenStack> vagrant up | |
Bringing machine 'controller' up with 'virtualbox' provider... | |
[controller] Importing base box 'precise64'... | |
←[0K[controller] Matching MAC address for NAT networking... | |
[controller] Setting the name of the VM... | |
[controller] Clearing any previously set forwarded ports... | |
[controller] Fixed port collision for 22 => 2222. Now on port 2200. | |
[controller] Creating shared folders metadata... | |
[controller] Clearing any previously set network interfaces... | |
[controller] Preparing network interfaces based on configuration... |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PS C:\users\ewright\Documents\GitHub\Couch_to_OpenStack> vagrant up | |
Bringing machine 'controller' up with 'virtualbox' provider... | |
Bringing machine 'compute' up with 'virtualbox' provider... | |
Bringing machine 'cinder' up with 'virtualbox' provider... | |
Bringing machine 'quantum' up with 'virtualbox' provider... | |
Bringing machine 'client' up with 'virtualbox' provider... | |
[controller] Importing base box 'precise64'... | |
←[0K[controller] Matching MAC address for NAT networking... | |
[controller] Setting the name of the VM... | |
[controller] Clearing any previously set forwarded ports... |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
people table fields: | |
id,first_name,last_name,login,manager_id | |
I need to get all the info, plus the login of the manager where manager_id references the record in the people table. | |
This is why I'm not a DBA |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Log in to MySQL command line as root | |
drop database keystone; | |
create database keystone; | |
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY 'KEYSTONE_DBPASS'; | |
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY 'KEYSTONE_DBPASS'; | |
exit | |
# now from the shell | |
sudo su -c "keystone-manage db_sync" keystone |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Out of the box build - command is "ceilometer meter-list" | |
results: | |
root@controller:/var/log/ceilometer# cat ceilometer-agent-central.log | |
2015-05-11 14:58:18.283 24053 ERROR ceilometer.agent [-] Unable to discover resources: 'AuthorizationFailure' object has no attribute 'tenants' | |
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent Traceback (most recent call last): | |
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent File "/usr/lib/python2.7/dist-packages/ceilometer/agent.py", line 233, in discover | |
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent discovered = discoverer.discover(self, param) | |
2015-05-11 14:58:18.283 24053 TRACE ceilometer.agent File "/usr/lib/python2.7/dist-packages/ceilometer/central/discovery.py", line 61, in discover |
OlderNewer