discoposse

# 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: ","")

discoposse

# 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 

discoposse

# 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 }

discoposse

################################################################################
# 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

discoposse

#############################################
# 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

discoposse

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...

discoposse

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...

discoposse

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

discoposse

# 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

discoposse

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