Showing posts with label powershell. Show all posts
Showing posts with label powershell. Show all posts

Thursday, June 27, 2019

Find SCCM Distribution Points in Maintenance Mode in Powershell or SQL + Set Maintenance Mode


Since 1902 SCCM it is possible to set Distribution Point in Maintenance Mode https://docs.microsoft.com/en-us/sccm/core/servers/deploy/configure/install-and-configure-distribution-points#bkmk_maint


In "\Administration\Overview\Distribution Points" you can set  "Enable maintenance mode" / "Disable maintenance mode"



In log MICROSOFT CONFIGURATION MANAGER\LOGS\DISTMGR.LOG when you try to distribute a package to this DP you will find this message when a Distribution Point is in Maintenance mode:
 Skipping distribution point ["Display=\\SRVDP01.mydomain.net\"]MSWNET:["SMS_SITE=XXX"]\\SRVDP01.mydomain.net\ since its in maintenance mode



In Powershell to find Distribution Point in Maintenance mode us Get-CMDistributionPointInfo cmdlet

If you need to know all your Distribution Points in Maintenance Mode in Powershell as in console "\Administration\Overview\Distribution Points" you just need to use Get-CMDistributionPointInfo cmdlet


$allDPinMaintenanceMode = Get-CMDistributionPointInfo | Where-Object { $_.MaintenanceMode -eq 1 }
$allDPinMaintenanceMode | Select-Object Name,Main* | Format-List
Name                         :
SRVDP01.mydomain.net
MaintenanceMode              : 1
MaintenanceModeLastStartTime : 6/19/2019 6:48:00 AM


As you can see:
MaintenanceMode = 1 when Distribution Point Maintenance Mode is Enabled and MaintenanceMode = 0 when Distribution Point Maintenance Mode is Disabled (active Distribution Point)



















In SQL to find Distribution Point in Maintenance mode using View table


In log "MICROSOFT CONFIGURATION MANAGER\LOGS\SMSProv.log" you can find table used in console clicking in "\Administration\Overview\Distribution Points"
CExtProviderClassObject::DoCreateInstanceEnumAsync (SMS_Query)
Execute WQL  =SELECT * FROM SMS_DistributionPointInfo~ 
Execute SQL =select  all SMS_DistributionPointInfo.AddressScheduleEnabled
,SMS_DistributionPointInfo.BindExcept
,SMS_DistributionPointInfo.BindPolicy
,SMS_DistributionPointInfo.BitsEnabled
,SMS_DistributionPointInfo.CertificateType
,SMS_DistributionPointInfo.Communication
,SMS_DistributionPointInfo.Description
,SMS_DistributionPointInfo.DPFlags
,SMS_DistributionPointInfo.Drive
,SMS_DistributionPointInfo.EnableLEDBAT
,SMS_DistributionPointInfo.GroupCount
,SMS_DistributionPointInfo.HasRelationship
,SMS_DistributionPointInfo.HealthCheckEnabled
,SMS_DistributionPointInfo.HealthCheckPriority
,SMS_DistributionPointInfo.HealthCheckSchedule
,SMS_DistributionPointInfo.ID
,SMS_DistributionPointInfo.IdentityGUID
,SMS_DistributionPointInfo.InternetFacing
,SMS_DistributionPointInfo.IsActive
,SMS_DistributionPointInfo.IsMulticast
,SMS_DistributionPointInfo.IsPeerDP
,SMS_DistributionPointInfo.IsProtected
,SMS_DistributionPointInfo.IsPullDP
,SMS_DistributionPointInfo.IsPXE
,SMS_DistributionPointInfo.MaintenanceMode
,SMS_DistributionPointInfo.MaintenanceModeLastStartTime
,SMS_DistributionPointInfo.NALPath
,SMS_DistributionPointInfo.Name
,SMS_DistributionPointInfo.OperatingSystem
,SMS_DistributionPointInfo.PreStagingAllowed
,SMS_DistributionPointInfo.Priority
,SMS_DistributionPointInfo.PXEPassword
,SMS_DistributionPointInfo.RateLimitsEnabled
,SMS_DistributionPointInfo.Region
,SMS_DistributionPointInfo.ResourceType
,SMS_DistributionPointInfo.ResponseDelay
,SMS_DistributionPointInfo.SccmPXE
,SMS_DistributionPointInfo.ServerName
,SMS_DistributionPointInfo.ServiceType
,SMS_DistributionPointInfo.ShareName
,SMS_DistributionPointInfo.SiteCode
,SMS_DistributionPointInfo.SiteName
,SMS_DistributionPointInfo.SupportUnknownMachines
,SMS_DistributionPointInfo.TransferRate
,SMS_DistributionPointInfo.UdaSetting
,SMS_DistributionPointInfo.Version 
from v_DistributionPointInfo AS SMS_DistributionPointInfo  OPTION(USE HINT('FORCE_LEGACY_CARDINALITY_ESTIMATION'))~ 
CExtUserContext::LeaveThread : Releasing IWbemContextPtr=216121456

So to find DP in maintenance mode you just to use this SQL query:

SELECT * FROM v_DistributionPointInfo WHERE MaintenanceMode = '1'











In SQL to find Distribution Point in Maintenance mode using Table (just form information - do not use table directly - use View Table)

To find DP in maintenance mode you can also use this (not recommended) SQL query:

SELECT * FROM DistributionPoints WHERE MaintenanceMode = '1'












In Console, information about Maintenance Mode is in file
 C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\XmlStorage\ConsoleRoot\SiteConfigurationNode.xml


In Powershell how to set  Maintenance Mode ?
To find that we can check SMS_DistributionPointInfo method

$smsdpinfo = [WmiClass]"\\SCCMSERVER.mydomain.net\root\SMS\Site_XXX:SMS_DistributionPointInfo"
($smsdpinfo | Get-Member -MemberType method).Definition
System.Management.ManagementBaseObject GetChainedPullDPs(System.String SourceDPNALPath)
System.Management.ManagementBaseObject ReassignDP(System.String NALPath, System.String SiteCode)
System.Management.ManagementBaseObject SetDPMaintenanceMode(System.String NALPath, System.UInt32 Mode)


with XXX = your Primary site Code
with SCCMSERVER.mydomain.net = your Primary SCCM Primary computername


And with some research we can find in Microsoft Documentation some information about SetDPMaintenanceMode
https://docs.microsoft.com/en-us/sccm/develop/reference/core/servers/configure/setdpmaintenancemode-method-in-class-sms-distributionpointinfo

So to set Maintenance Mode use (enabled) use:
$smsdpinfo = [WmiClass]"\\SCCMSERVER.mydomain.net\root\SMS\Site_XXX:SMS_DistributionPointInfo"
$smsdpinfo.SetDPMaintenanceMode('["Display=\\SRVDP01.mydomain.net\"]MSWNET:["SMS_SITE=XXX"]\\SRVDP01.mydomain.net\','1')
with XXX = your Primary site Code
with SCCMSERVER.mydomain.net = your Primary SCCM Primary computername
with SRVDP01.mydomain.net = DP to set in Maintenance Mode

So to remove Maintenance Mode use (diabled) use:
$smsdpinfo = [WmiClass]"\\SCCMSERVER.mydomain.net\root\SMS\Site_XXX:SMS_DistributionPointInfo"
$smsdpinfo.SetDPMaintenanceMode('["Display=\\SRVDP01.mydomain.net\"]MSWNET:["SMS_SITE=XXX"]\\SRVDP01.mydomain.net\','0')

When it is OK, ReturnValue = 0


Seems someone already create a simpliest powershell to set Maintenance Mode. So I will not reinvent wheel (...this time :-) ... ). So please go to
https://sccmf12twice.com/2019/06/set-cmdistributionpointmaintenancemode/
or directly to script
https://github.com/CodyMathis123/CM-Ramblings/blob/master/Set-CMDistributionPointMaintenanceMode.ps1



Tuesday, June 19, 2018

SCCM - Get Content Distribution Package Type - Powershell

Sometimes, you need to know what is Package Type (Package ? Application ? Driver ?) in "\Monitoring\Overview\Distribution Status\Content Status"



 
For that you  must use SMS_PackageBaseClass (Microsoft doc at SMS_PackageBaseClass) using PackageType property


Value  = Description = Type (in "Content Status")
0 = Regular software distribution package. = "Package"
3 = Driver package. = "Driver package"
4 = Task sequence package.
5 = Software update package. = "Software Update Package"
6 = Device setting package.
7 = Virtual application package.
8 = Application package. = "Application"
257 = Image package. = "Operating system Image"
258 = Boot image package. = "Boot Image"
259 = Operating system install package. =  "Operating System Upgrade Package"
260 = VHD package.

Value 4 "Task sequence package" corresponding to "\Software Library\Overview\Operating Systems\Task Sequences" (if you enable column "Package Type" you will see 4)















Below a powershell script example to export some Package information to "export_packages_info.csv" file. 



<#
.Synopsis
   Get All Package Type

.EXAMPLE
   .\Get-AllPackageType .ps1

.NOTES
  Version:        1.0
  Author:        Franck RICHARD
  Creation Date:    2018-06
  Purpose/Change:

#>
[cmdletbinding()]
Param(
     [String]$CM="myprimary.mydomain.net"
    ,[String]$PrimarySiteCode="XXX"
)


# *************************

# Get all packages
#
Write-Host "Get all Packages"
[HashTable] $hashPackageByPackageID = @{}
$arrSMS_PackageBaseclass = @(Get-WmiObject -Namespace "root\SMS\Site_$PrimarySiteCode" -Class SMS_PackageBaseclass -ComputerName $CM)
Foreach ($SMS_PackageBaseclass in $arrSMS_PackageBaseclass) {
    if ($hashPackageByPackageID.ContainsKey($SMS_PackageBaseclass.PackageID) ) {
        # Should not arrive problem in DB
    } else {
        $hashPackageByPackageID[$($SMS_PackageBaseclass.PackageID)] = $SMS_PackageBaseclass
    }
}

# *************************

# Write all package name and Package Type
#
$strContent = "PackageId;PackageTypeValue;ObjectPath;Name"  + "`r`n"

Foreach ($PackageID in $hashPackageByPackageID.Keys) {
    $SMS_PackageBaseclass = $hashPackageByPackageID[$PackageID]

    $PackageType = $SMS_PackageBaseclass.PackageType
    $Name = $SMS_PackageBaseclass.Name
    $ObjectPath = $SMS_PackageBaseclass.ObjectPath

            Switch ($PackageType) {
            0 {
                $PackageTypeValue = "Standard Package"
            }
            3 {
                $PackageTypeValue = "Driver Package"
            }
            4 {
                $PackageTypeValue = "Task Sequence Package"
            }
            5 {
                $PackageTypeValue = "Software Update Package"
            }
            6 {
                $PackageTypeValue = "Device Setting Package"
            }
            7 {
                $PackageTypeValue = "Virtual App Package"
            }
            8 {
                $PackageTypeValue = "Application Package"
            }
            257 {
                $PackageTypeValue = "Operating system Image Package"
            }
            258 {
                $PackageTypeValue = "Boot Image Package"
            }
            259 {
                $PackageTypeValue = "Operating System Upgrade Package"
            }
            260 {
                $PackageTypeValue = "VHD package"
            }
        } # switch end

    $strLine = $PackageID + ";" + $PackageTypeValue + ";" + $ObjectPath + ";" + $Name  + "`r`n"
    $strContent = $strContent + $strLine

}
Write-Host "Write export_packages_info.csv file with all package informations"
$strContent | Out-File -FilePath  "export_packages_info.csv"





If you just need Package Type information because you use  Remove-CMContentDistribution cmdlet  or another cmdlet "Package Type" dependent, better thing is to use an hashtable with only PackageType. Something like:
$hashPackageType[$($SMS_PackageBaseclass.PackageID)] = $($SMS_PackageBaseclass.PackageType)
Then when you have you PackageID to know your PackageType
$PackageType = $hashPackageType[$PackageID]




Wednesday, February 15, 2012

Simple Powershell Password Obfuscation

There is many ways to encrypt password in SHA1, MD5 or any other encrypter in powershell using .NET libraries.
This time, I only need a simple and fast obfuscation powershell encoder/decoder to avoid plain text password. I choose this simple solution:
I encode in decimal letter then I add 1
Ex: A = 41 (byte char in hexadecimal) = 65 (byte char in decimal)
obfuscation add 1 so obfuscation result = 65+1 = 66
obfuscation decoder sub 1 so 66-1 = 65 = A
((download scripts)

to encode
$strEncoded = ""
$strToEncode = "ABCD"
$strToEncode.ToCharArray() | Foreach { $strEncoded = $strEncoded + ([BYTE][CHAR]($_)+1)  + " " }
Write-Host $strEncoded

encode result:
66 67 68 69

to decode
$strDecoded = ""
$strToDecode = "66 67 68 69"
$strToDecode.Trim().Split(" ") | Foreach { $strDecoded = $strDecoded + [CHAR][BYTE](($_)-1) }
Write-Host $strDecoded 

decode result:
ABCD

Example of obfuscation encoder for your password
#
# Simple Password Obfuscation encoder
# 
# by Franck RICHARD 
# 2012 February
#

$strComputername = Read-Host "Enter Computername"
$username = Read-Host "Enter Username"
$password = read-host "Enter a Password"

# To encode password
$strToEncode = $password
$strEncoded = ""
$strToEncode.ToCharArray() | Foreach { $strEncoded = $strEncoded + ([BYTE][CHAR]($_)+1)  + " " }

$line = $strComputername + ";" + $username + ";" + $strEncoded
Write-Host $line

result with computer mycomputer, user myuser and password mypasswor;
Enter Computername: mycomputer
Enter Username: myuser
Enter a Password: mypassword
mycomputer;myuser;110 122 113 98 116 116 120 112 115 101


Example of obfuscation decoder for your password
you need a test file servers.txt using line generated above
mycomputer;myuser;110 122 113 98 116 116 120 112 115 101
mycomputer2;myuser2;111 102 120 113 98 116 116 120 112 115 101


#
# Simple Password Obfuscation decoder
# 
# by Franck RICHARD 
# 2012 February
#

$strContent = Get-Content servers.txt
Foreach ($strLine in $strContent) {
 $strInfos = $strLine.Trim().Split(";") 
 $strDecoded = ""
 $strToDecode = $strInfos[2]
 $strToDecode.Trim().Split(" ") | Foreach { $strDecoded = $strDecoded + [CHAR][BYTE](($_)-1) }
 Write-Host "Computername:" $strInfos[0] "User:" $strInfos[1] "Password:" $strDecoded
}

Saturday, July 2, 2011

Check your ip/computername with nslookup in powershell

Nslookup is a great tool for testing and troubleshooting. However, if you need to check a large range of IP/Computername in mass, nslookup is not the better choice. So, this below script could help you to do the same in powershell. (Download script)


#
# NSLookup
#
# by F.Richard 2011-05
#


# ***********************************************

Function NSlookup {
Param($hostname)
#$iphostEntry = [System.Net.Dns]::GetHostEntry($hostname)
# Rexolve obsolete but better than GetHostEntry
$iphostEntry = [System.Net.Dns]::Resolve($hostname)
$line = $iphostEntry.HostName

$strSeparator = ";"
foreach ($addr in $iphostEntry.AddressList) {
$line = $line + $strSeparator + $Addr.IPAddressToString
$strSeparator = "|"
}

$strSeparator = ";"
foreach ($alias in $iphostEntry.aliases) {
$line = $line + $strSeparator + $alias
$strSeparator = "|"
}

return $line
}



# ***********************************************

Function TestFile {
Param(
[String] $strFilename,
[String] $strCurDir
)
if ($strFilename) {
$strCurDir = $(if ($strCurDir) {$strCurDir} else {if ($MyInvocation.MyCommand.CommandType -eq "Function") {(Get-Location).Path} else {Split-Path -parent $MyInvocation.MyCommand.Path} })
If ((Test-Path("$strFilename")) -eq $False){
If ($strFilename.ToUpper().Contains($strCurDir.ToUpper()) ) {
Write-Host "ERROR: file $strFilename NOT exist"
return
} Else {
If ((Test-Path("$strCurDir\$strFilename")) -eq $False){
Write-Host "ERROR: file $strFilename NOT exist"
Write-Host "ERROR: file $strCurDir\$strFilename NOT exist"
return
} Else {
$strFilename = "$strCurDir\$strFilename"
}
}
}
return $strFilename
}
}


# ***********************************************

Function GetFileIntoArr {
Param(
[String] $strFilename,
[String] $strCurDir,
[Ref]$arrFile,
[String] $strComment
)
$strComment = $(if ($strComment) {$strComment} else {"#"})
$strCurDir = $(if ($strCurDir) {$strCurDir} else {if ($MyInvocation.MyCommand.CommandType -eq "Function") {(Get-Location).Path} else {Split-Path -parent $MyInvocation.MyCommand.Path} })

$retFilename = TestFile -strFilename $strFilename -strCurDir $strCurDir
if ($retFilename) {
$Content = Get-Content "$retFilename"
Foreach ($line in $Content) {
$comment = $False
If ($line.Trim().length -gt 0) { # take only line with data and without # at begininng of the line
# if we do not want to use comment
If ($strComment -eq "#") {
If ($line.substring(0,1) -eq "#") {
$comment = $True
}
}
If ($comment -eq $False) {
# Get Search & Replace
$arrFile.Value += $line.Trim()
}
}
}
return $True
} else {
return $False
}
}

# ***********************************************

#
# MAIN PROGRAM
#

# Verify Arguments Number
If($Args.Count -lt 2) {
Write-Host "Syntax:"$MyInvocation.MyCommand.Name "inputfilename outputfilename"
Write-Host " Example:"$MyInvocation.MyCommand.Name" 'inputfile.txt' 'outputfile.txt' "
Write-Host " Example:"$MyInvocation.MyCommand.Name" -inputfile 'inputfile.txt' -outputfile 'outputfile.txt' "
Write-Host
Break
}

$inputfile = $args[0]
$outputfile = $args[1]
$date = get-date -format "yyyy-MM-dd"
$Content = "#Date;Computer;Hostname;IP`r`n"
$Content | Out-File -encoding ASCII $outputfile
[Array] $arrComputers = @( )

if ($inputfile) {
if (!(GetFileIntoArr -strFilename $inputfile -arrFile ([Ref]$arrComputers))) {
Break
}
} else {
Write-Host "ERROR: you need a filename.txt as second parameter inputfile"
Break
}
Foreach ($computer in $arrComputers) {
$nslookup = NSlookup($computer)
$line = $date + ";" + $computer + ";" + $nslookup
#+ "`r`n"
Write-Host $line
$line | Out-File -append -encoding ASCII $outputfile
}


Example of Result:

#Date;Computer;Hostname;IP
2011-06-01;COMPUTER1;computer1.dns1.my.net;192.1.1.45;COMPUTER1.dns2.my.net
2011-06-01;COMPUTER2;COMPUTER2.si.net;192.1.1.100
2011-06-01;COMPUTER3;COMPUTER3.si.net;192.1.1.101
2011-06-01;COMPUTER4;COMPUTER4.si.net;192.1.102

Wednesday, June 29, 2011

Find your VMware local VMFS datastore with powershell

To find your local VMFS datastore

Solution 1: name all your local vmfs LOCAL_xxx
Get all your local datastore by using
Get-Datastore | Get-View | Where-Object { $_.Name -match "LOCAL_*" } | Select-Object  @{n="Name";e={$_.Name}}}

Name
----
LOCAL_ESX01
LOCAL_ESX02
LOCAL_ESX03



Solution 2: use MultipleHostAccess info from Get-Datastore
(Thanks to http://blogs.vmware.com/vipowershell/2009/08/how-to-list-datastores-that-are-on-shared-storage.html?cid=6a00d8341c328153ef0120a52e7f0b970b for MultipleHostAccess tip)
You can use this:
Get-Datastore | Get-View | Select-Object  @{n="Name";e={$_.Name}}, @{n="San_Nas";e={$_.Summary.MultipleHostAccess}}

Name San_Nas
---- -------
NFS_VOL2 True
LOCAL_ESX01 False
NFS_VOL1 True
LOCAL_ESX02 False
LOCAL_ESX03 False



Solution 3: use Vendor / Model SCSILun informations from VMHost get-view
Get-VMHost | Get-View | Foreach-Object { $vmhost=$_.Name; $_.Config.StorageDevice.ScsiLun |  Select-Object @{n="Hostname";e={$vmhost}},@{n="Model";e={$_.Model}},@{n="Vendor";e={$_.Vendor}} }


Hostname Model Vendor
-------- ----- ------
esx01 LOGICAL VOLUME HP
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx01 SYMMETRIX EMC
esx02 RAID 5 DGC
esx02 SYMMETRIX EMC
esx02 SYMMETRIX EMC
esx02 RAID 5 DGC
esx03 LOGICAL VOLUME HP
esx03 2810XIV IBM
esx03 2810XIV IBM
esx03 2810XIV-LUN-0 IBM
esx03 2810XIV IBM



Example of SAN vendor/model
Vendor / Model
VMware / Block device
EMC / SYMMETRIX
IBM / 2810XIV

Example of Local storage
Vendor / Model
HP / LOGICAL VOLUME
DGC / RAID 5

Friday, June 17, 2011

Optimize your vmware powershell: part 1 - Get-Datacenter

Remember Get-Datacenter | Get-View = Get-View -ViewType Datacenter
For better performance, use
Get-View -ViewType
Use "-Property property1,property2,property3" switch if you don't need all properties. Less data to take = better performance too.

Execution time results after the execution of some commands:

Command

seconds

Get-View -ViewType Datacenter -Property Name

0,093652985

Get-View -ViewType Datacenter

0,128286732

Get-Datacenter

0,190378198

Get-Datacenter | Get-View

0,241663792

Get-View -ViewType Datacenter -Property Name | Foreach-Object { Get-VIObjectByVIView $_.MoRef }

0,296987547

Get-View -ViewType Datacenter | Foreach-Object { Get-VIObjectByVIView $_.MoRef

0,342440257



Get-Datastore fields and its equivalent fields with Get-View

Command

Equivalent Fields

$dc0 = Get-Datacenter | Where-Object { $_.Name -eq "Datacenter_1" }

$dc1 = Get-View -ViewType Datacenter | Where-Object { $_.Name -eq "Datacenter_1" }

$dc0.ExtensionData

$dc1

$dc0.Name

$dc1.Name

$dc0.Id

$dc1.MoRef

$dc0.ParentFolderId

$dc1.Parent

$dc0.CustomFields

[Array] $arrFields = @()
$dc1 | Foreach-Object {
$datacenter = $_
$datacenter.AvailableField | Foreach-Object {
$availablefield = $_
$Key = $availablefield.Name
$Value = ($datacenter.CustomValue | Where-Object { $_.Key -eq $availablefield.Key}).Value

$objParent = New-Object PSObject
$objParent | Add-Member -MemberType noteproperty -Name "Key" -Value $key
$objParent | Add-Member -MemberType noteproperty -Name "Value" -Value $value
$arrFields += $objParent
}
}

$arrFields

Another way to improve your scripts: use -Filter switch when you want specific data. Some lines can also be better than 1 cmdlets , but it's not always the case (see below)

Command

seconds

#Equivalent

#Get-Datacenter -Name Datacenter_2

Get-View -ViewType Datacenter -Filter @{"Name"="Datacenter_2"}

0,11421332

#Equivalent

#Get-Datacenter -Name Datacenter_2

Get-View -ViewType Datacenter | Where-Object { $_.Name -eq "Datacenter_2" }

0,13915101

Get-Datacenter -Name Datacenter_2

0,18590567

Get-Datacenter -Id Datacenter-datacenter-3472

0,18141816

Get-Datacenter -Cluster Cluster_2

0,37470311

#Equivalent

# Get-Datacenter -Cluster Cluster_2

$cluster=" Cluster_2"

$parent = (Get-View -ViewType ComputeResource -Filter @{"Name"=$cluster} -Property Parent).Parent.ToString()

While ($parent.ToString().Substring(0,5).ToUpper() -ne "DATAC") {

$parent = (Get-View -ViewType Folder -Property Parent | Where-Object { $_.MoRef.ToString() -eq $parent}).Parent.ToString()

}

Get-Datacenter -Id $parent

0,4999502

Get-Datacenter -VMHost ESX01

0,8159789

#Equivalent

# Get-Datacenter -VMHost ESX01

$parent = (Get-View -ViewType HostSystem -Filter @{"Name"=" ESX01"} -Property Parent).Parent.ToString()

If ($parent.ToString().Substring(0,5).ToUpper() -eq "CLUST") {

$parent = (Get-View -ViewType ComputeResource -Property Parent | Where-Object { $_.MoRef.ToString() -eq $parent}).Parent.ToString()

}

While ($parent.ToString().Substring(0,5).ToUpper() -ne "DATAC") {

$parent = (Get-View -ViewType Folder -Property Parent | Where-Object { $_.MoRef.ToString() -eq $parent}).Parent.ToString()

}

Get-Datacenter -Id $parent

0,7234534

#Equivalent

# Get-Datacenter -VM VM01

$vm=" VM01"

$parent = (Get-View -ViewType VirtualMachine -Filter @{"Name"=$vm} -Property Parent).Parent.ToString()

While ($parent.ToString().Substring(0,5).ToUpper() -ne "DATAC") {

$parent = (Get-View -ViewType Folder -Property Parent | Where-Object { $_.MoRef.ToString() -eq $parent}).Parent.ToString()

}

Get-Datacenter -Id $parent

0,6182902

Get-Datacenter -VM VM01

5,26492918



Some cmdlets result properties

[vSphere PowerCLI]> Get-Datacenter | select *

ParentFolderId : Folder-group-d1
ParentFolder : Datacenters
CustomFields : {}
ExtensionData : VMware.Vim.Datacenter
Id : Datacenter-datacenter-3472
Name : Datacenter_2
Uid : /VIServer=@localhost:443/Datacenter=Datacenter-datacenter-3472/

ParentFolderId : Folder-group-d1
ParentFolder : Datacenters
CustomFields : {}
ExtensionData : VMware.Vim.Datacenter
Id : Datacenter-datacenter-10
Name : Datacenter_1
Uid : /VIServer=@localhost:443/Datacenter=Datacenter-datacenter-10/


[vSphere PowerCLI]> Get-View -ViewType Datacenter


VmFolder : Folder-group-v11
HostFolder : Folder-group-h12
DatastoreFolder :
NetworkFolder :
Datastore : {Datastore-datastore-123, Datastore-datastore-233, Datastore-datastore-235, Datastore-datastore-237...}
Network : {Network-network-1634, Network-network-1636, Network-network-6006, Network-network-3456...}
Parent : Folder-group-d1
CustomValue : {}
OverallStatus : gray
ConfigStatus : gray
ConfigIssue : {}
EffectiveRole : {-1}
Permission : {113, 113, -5, -2...}
Name : Datacenter_1
DisabledMethod : {}
RecentTask : {}
DeclaredAlarmState : {alarm-1.datacenter-10, alarm-2.datacenter-10, alarm-3.datacenter-10, alarm-4.datacenter-10...}
TriggeredAlarmState : {alarm-3.host-184, alarm-3.host-3310, alarm-3.host-3834, alarm-3.host-5972...}
AlarmActionsEnabled : False
Tag :
Value : {}
AvailableField : {}
MoRef : Datacenter-datacenter-10
Client : VMware.Vim.VimClient

VmFolder : Folder-group-v3473
HostFolder : Folder-group-h3474
DatastoreFolder :
NetworkFolder :
Datastore : {Datastore-datastore-3554, Datastore-datastore-3556, Datastore-datastore-3558, Datastore-datastore-3560...}
Network : {Network-network-9660, Network-network-6759, Network-network-6761, Network-network-6760...}
Parent : Folder-group-d1
CustomValue : {}
OverallStatus : gray
ConfigStatus : gray
ConfigIssue : {}
EffectiveRole : {-1}
Permission : {107, 107, 107, 107...}
Name : Datacenter_2
DisabledMethod : {}
RecentTask : {}
DeclaredAlarmState : {alarm-1.datacenter-3472, alarm-2.datacenter-3472, alarm-3.datacenter-3472, alarm-4.datacenter-3472...}
TriggeredAlarmState : {alarm-3.host-11857, alarm-3.host-11873, alarm-3.host-6439, alarm-4.vm-9648}
AlarmActionsEnabled : False
Tag :
Value : {}
AvailableField : {}
MoRef : Datacenter-datacenter-3472
Client : VMware.Vim.VimClient

[vSphere PowerCLI]> Get-Datacenter | Where-Object { $_.Name -eq "Datacenter_1" } | Get-Member

TypeName: VMware.VimAutomation.ViCore.Impl.V1.Inventory.DatacenterImpl

Name MemberType Definition
---- ---------- ----------
ConvertToVersion Method ConvertToVersion()
Equals Method System.Boolean Equals(Object obj)
GetHashCode Method System.Int32 GetHashCode()
GetHostFolder Method VMware.VimAutomation.ViCore.Interop.V1.Inventory.FolderInterop GetHostFolder()
GetType Method System.Type GetType()
GetVmFolder Method VMware.VimAutomation.ViCore.Interop.V1.Inventory.FolderInterop GetVmFolder()
get_CustomFields Method System.Collections.Generic.IDictionary`2[[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] get_CustomFields()
get_ExtensionData Method System.Object get_ExtensionData()
get_Id Method System.String get_Id()
get_Name Method System.String get_Name()
get_ParentFolder Method VMware.VimAutomation.ViCore.Types.V1.Inventory.Folder get_ParentFolder()
get_ParentFolderId Method System.String get_ParentFolderId()
get_Uid Method System.String get_Uid()
IsConvertableTo Method System.Boolean IsConvertableTo(Type toType)
ToString Method System.String ToString()
CustomFields Property System.Collections.Generic.IDictionary`2[[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] CustomFields {get;}
ExtensionData Property System.Object ExtensionData {get;}
Id Property System.String Id {get;}
Name Property System.String Name {get;}
ParentFolder Property VMware.VimAutomation.ViCore.Types.V1.Inventory.Folder ParentFolder {get;}
ParentFolderId Property System.String ParentFolderId {get;}
Uid Property System.String Uid {get;}

[vSphere PowerCLI]>Get-View -ViewType Datacenter | Where-Object { $_.Name -eq "Datacenter_1"   } | Get-Member

TypeName: VMware.Vim.Datacenter

Name MemberType Definition
---- ---------- ----------
Destroy Method System.Void Destroy()
Destroy_Task Method VMware.Vim.ManagedObjectReference Destroy_Task()
Equals Method System.Boolean Equals(Object obj)
GetAllEventsView Method VMware.Vim.EventHistoryCollector GetAllEventsView(EventFilterSpec eventFilterSpec)
GetAllTasksView Method VMware.Vim.TaskHistoryCollector GetAllTasksView(TaskFilterSpec taskFilterSpec)
GetEntityOnlyEventsCollectorView Method VMware.Vim.EventHistoryCollector GetEntityOnlyEventsCollectorView(EventFilterSpec eventFilterSpec)
GetEntityOnlyTasksCollectorView Method VMware.Vim.TaskHistoryCollector GetEntityOnlyTasksCollectorView(TaskFilterSpec taskFilterSpec)
GetEventCollectorView Method VMware.Vim.EventHistoryCollector GetEventCollectorView(EventFilterSpecRecursionOption recursionOption, EventFilterSpec eventFilterSpec)
GetHashCode Method System.Int32 GetHashCode()
GetTaskCollectorView Method VMware.Vim.TaskHistoryCollector GetTaskCollectorView(TaskFilterSpecRecursionOption recursionOption, TaskFilterSpec taskFilterSpec)
GetType Method System.Type GetType()
get_AlarmActionsEnabled Method System.Boolean get_AlarmActionsEnabled()
get_AvailableField Method VMware.Vim.CustomFieldDef[] get_AvailableField()
get_Client Method VMware.Vim.VimClient get_Client()
get_ConfigIssue Method VMware.Vim.Event[] get_ConfigIssue()
get_ConfigStatus Method VMware.Vim.ManagedEntityStatus get_ConfigStatus()
get_CustomValue Method VMware.Vim.CustomFieldValue[] get_CustomValue()
get_Datastore Method VMware.Vim.ManagedObjectReference[] get_Datastore()
get_DatastoreFolder Method VMware.Vim.ManagedObjectReference get_DatastoreFolder()
get_DeclaredAlarmState Method VMware.Vim.AlarmState[] get_DeclaredAlarmState()
get_DisabledMethod Method System.String[] get_DisabledMethod()
get_EffectiveRole Method System.Int32[] get_EffectiveRole()
get_HostFolder Method VMware.Vim.ManagedObjectReference get_HostFolder()
get_MoRef Method VMware.Vim.ManagedObjectReference get_MoRef()
get_Name Method System.String get_Name()
get_Network Method VMware.Vim.ManagedObjectReference[] get_Network()
get_NetworkFolder Method VMware.Vim.ManagedObjectReference get_NetworkFolder()
get_OverallStatus Method VMware.Vim.ManagedEntityStatus get_OverallStatus()
get_Parent Method VMware.Vim.ManagedObjectReference get_Parent()
get_Permission Method VMware.Vim.Permission[] get_Permission()
get_RecentTask Method VMware.Vim.ManagedObjectReference[] get_RecentTask()
get_Tag Method VMware.Vim.Tag[] get_Tag()
get_TriggeredAlarmState Method VMware.Vim.AlarmState[] get_TriggeredAlarmState()
get_Value Method VMware.Vim.CustomFieldValue[] get_Value()
get_VmFolder Method VMware.Vim.ManagedObjectReference get_VmFolder()
PowerOnMultiVM Method VMware.Vim.ClusterPowerOnVmResult PowerOnMultiVM(ManagedObjectReference[] vm, OptionValue[] option)
PowerOnMultiVM_Task Method VMware.Vim.ManagedObjectReference PowerOnMultiVM_Task(ManagedObjectReference[] vm, OptionValue[] option)
QueryConnectionInfo Method VMware.Vim.HostConnectInfo QueryConnectionInfo(String hostname, Int32 port, String username, String password, String sslThumbprint)
Reload Method System.Void Reload()
Rename Method System.Void Rename(String newName)
Rename_Task Method VMware.Vim.ManagedObjectReference Rename_Task(String newName)
setCustomValue Method System.Void setCustomValue(String key, String value)
SetViewData Method System.Void SetViewData(ObjectContent objectContent, String[] properties)
ToString Method System.String ToString()
UpdateViewData Method System.Void UpdateViewData(Params String[] properties), System.Void UpdateViewData()
WaitForTask Method System.Object WaitForTask(ManagedObjectReference taskReference)
AlarmActionsEnabled Property System.Boolean AlarmActionsEnabled {get;}
AvailableField Property VMware.Vim.CustomFieldDef[] AvailableField {get;}
Client Property VMware.Vim.VimClient Client {get;}
ConfigIssue Property VMware.Vim.Event[] ConfigIssue {get;}
ConfigStatus Property VMware.Vim.ManagedEntityStatus ConfigStatus {get;}
CustomValue Property VMware.Vim.CustomFieldValue[] CustomValue {get;}
Datastore Property VMware.Vim.ManagedObjectReference[] Datastore {get;}
DatastoreFolder Property VMware.Vim.ManagedObjectReference DatastoreFolder {get;}
DeclaredAlarmState Property VMware.Vim.AlarmState[] DeclaredAlarmState {get;}
DisabledMethod Property System.String[] DisabledMethod {get;}
EffectiveRole Property System.Int32[] EffectiveRole {get;}
HostFolder Property VMware.Vim.ManagedObjectReference HostFolder {get;}
MoRef Property VMware.Vim.ManagedObjectReference MoRef {get;}
Name Property System.String Name {get;}
Network Property VMware.Vim.ManagedObjectReference[] Network {get;}
NetworkFolder Property VMware.Vim.ManagedObjectReference NetworkFolder {get;}
OverallStatus Property VMware.Vim.ManagedEntityStatus OverallStatus {get;}
Parent Property VMware.Vim.ManagedObjectReference Parent {get;}
Permission Property VMware.Vim.Permission[] Permission {get;}
RecentTask Property VMware.Vim.ManagedObjectReference[] RecentTask {get;}
Tag Property VMware.Vim.Tag[] Tag {get;}
TriggeredAlarmState Property VMware.Vim.AlarmState[] TriggeredAlarmState {get;}
Value Property VMware.Vim.CustomFieldValue[] Value {get;}
VmFolder Property VMware.Vim.ManagedObjectReference VmFolder {get;}

Sunday, June 5, 2011

GetSpecialFolderPath in Powershell

To complete "Enumerate your own enum in Powershell" post, I give you this below script to use GetSpecialFolderPath
(Download it)
You can remove # comment in this script if you need to see some examples of array or hashtable use


#
#
# GetSpecialFolderPath
#
# by F.Richard 2011-05
#
#

#Requires -Version 2.0


# CSIDL
# http://msdn.microsoft.com/en-us/library/bb762494%28v=vs.85%29.aspx
# for windows XP and later OS
# KNOWNFOLDERID
# http://msdn.microsoft.com/en-us/library/dd378457%28v=vs.85%29.aspx
# for Vista and later OS
# Recognized Environment Variables
# http://technet.microsoft.com/en-us/library/cc749104%28WS.10%29.aspx

# DllImport
$signature = @"
[DllImport("Shell32.dll")]
public static extern int SHGetSpecialFolderPath(UIntPtr hwndOwner, System.Text.StringBuilder lpszPath, CSIDL iCsidl, int fCreate);


public enum CSIDL : int {
CSIDL_DESKTOP = 0x0000,
CSIDL_INTERNET = 0x0001,
CSIDL_PROGRAMS = 0x0002,
CSIDL_CONTROLS = 0x0003,
CSIDL_PRINTERS = 0x0004,
CSIDL_PERSONAL = 0x0005,
CSIDL_FAVORITES = 0x0006,
CSIDL_STARTUP = 0x0007,
CSIDL_RECENT = 0x0008,
CSIDL_SENDTO = 0x0009,
CSIDL_BITBUCKET = 0x000a,
CSIDL_STARTMENU = 0x000b,
CSIDL_MYDOCUMENTS = CSIDL_PERSONAL,
CSIDL_MYMUSIC = 0x000d,
CSIDL_MYVIDEO = 0x000e,
CSIDL_DESKTOPDIRECTORY = 0x0010,
CSIDL_DRIVES = 0x0011,
CSIDL_NETWORK = 0x0012,
CSIDL_NETHOOD = 0x0013,
CSIDL_FONTS = 0x0014,
CSIDL_TEMPLATES = 0x0015,
CSIDL_COMMON_STARTMENU = 0x0016,
CSIDL_COMMON_PROGRAMS = 0x0017,
CSIDL_COMMON_STARTUP = 0x0018,
CSIDL_COMMON_DESKTOPDIRECTORY = 0x0019,
CSIDL_APPDATA = 0x001a,
CSIDL_PRINTHOOD = 0x001b,
CSIDL_LOCAL_APPDATA = 0x001c,
CSIDL_ALTSTARTUP = 0x001d,
CSIDL_COMMON_ALTSTARTUP = 0x001e,
CSIDL_COMMON_FAVORITES = 0x001f,
CSIDL_INTERNET_CACHE = 0x0020,
CSIDL_COOKIES = 0x0021,
CSIDL_HISTORY = 0x0022,
CSIDL_COMMON_APPDATA = 0x0023,
CSIDL_WINDOWS = 0x0024,
CSIDL_SYSTEM = 0x0025,
CSIDL_PROGRAM_FILES = 0x0026,
CSIDL_MYPICTURES = 0x0027,
CSIDL_PROFILE = 0x0028,
CSIDL_SYSTEMX86 = 0x0029,
CSIDL_PROGRAM_FILESX86 = 0x002a,
CSIDL_PROGRAM_FILES_COMMON = 0x002b,
CSIDL_PROGRAM_FILES_COMMONX86 = 0x002c,
CSIDL_COMMON_TEMPLATES = 0x002d,
CSIDL_COMMON_DOCUMENTS = 0x002e,
CSIDL_COMMON_ADMINTOOLS = 0x002f,
CSIDL_ADMINTOOLS = 0x0030,
CSIDL_CONNECTIONS = 0x0031,
CSIDL_COMMON_MUSIC = 0x0035,
CSIDL_COMMON_PICTURES = 0x0036,
CSIDL_COMMON_VIDEO = 0x0037,
CSIDL_RESOURCES = 0x0038,
CSIDL_RESOURCES_LOCALIZED = 0x0039,
CSIDL_COMMON_OEM_LINKS = 0x003a,
CSIDL_CDBURN_AREA = 0x003b,
CSIDL_COMPUTERSNEARME = 0x003d,
CSIDL_FLAG_CREATE = 0x8000,
CSIDL_FLAG_DONT_VERIFY = 0x4000,
CSIDL_FLAG_DONT_UNEXPAND = 0x2000,
CSIDL_FLAG_NO_ALIAS = 0x1000,
CSIDL_FLAG_PER_USER_INIT = 0x0800
}
"@



# Register shell32 functions
If (-not ("Shell32.Tools" -as [Type])) {
$type = Add-Type -MemberDefinition $signature -Name Tools -Namespace Shell32 -Using System.Text -PassThru
} else {
If ($debug) { Write-Host "Shell32.Tools already Registered" }
}
# Get Common Desktop Directory
$hwnd = New-Object UIntPtr
$lpData = New-Object System.Text.StringBuilder(260) # MAX_PATH = 256
$CSIDL = "CSIDL_COMMON_DESKTOPDIRECTORY"
if([Shell32.Tools]::SHGetSpecialFolderPath($hwnd, $lpData, $CSIDL, 0)) {
Write-Host $CSIDL "=" $lpData
}


# Enum To Array
$arrEnum=[Enum]::GetNames([Shell32.Tools+CSIDL])
# Remove remark to display name and value
#foreach ($name in $arrEnum) {
# Write-Host "Name:$name Value:"([Shell32.Tools+CSIDL]::$name).value__
#}


# Enum To Hash
$hashEnum = @{ }
[Enum]::GetValues([Shell32.Tools+CSIDL])| % {$hashEnum["$_"] = $_.value__ }
# Remove remark to display name and value
#foreach ($name in $hashEnum.keys) {
# Write-Host "Name:$name Value:"$hashEnum["$name"]
#}


foreach ($CSIDL in $arrEnum) {
if ([Shell32.Tools]::SHGetSpecialFolderPath($hwnd, $lpData, $CSIDL, 0)) {
Write-Host $CSIDL "=" $lpData
}
}


Windows 2003 english example results with myuser user


C:\> .\GetSpecialFolderPath.ps1
CSIDL_COMMON_DESKTOPDIRECTORY = C:\Documents and Settings\All Users\Desktop
CSIDL_DESKTOP = C:\Documents and Settings\myuser\Desktop
CSIDL_PROGRAMS = C:\Documents and Settings\myuser\Start Menu\Programs
CSIDL_PERSONAL = C:\Documents and Settings\myuser\My Documents
CSIDL_MYDOCUMENTS = C:\Documents and Settings\myuser\My Documents
CSIDL_FAVORITES = C:\Documents and Settings\myuser\Favorites
CSIDL_STARTUP = C:\Documents and Settings\myuser\Start Menu\Programs\Startup
CSIDL_RECENT = C:\Documents and Settings\myuser\Recent
CSIDL_SENDTO = C:\Documents and Settings\myuser\SendTo
CSIDL_STARTMENU = C:\Documents and Settings\myuser\Start Menu
CSIDL_DESKTOPDIRECTORY = C:\Documents and Settings\myuser\Desktop
CSIDL_NETHOOD = C:\Documents and Settings\myuser\NetHood
CSIDL_FONTS = C:\WINDOWS\Fonts
CSIDL_TEMPLATES = C:\Documents and Settings\myuser\Templates
CSIDL_COMMON_STARTMENU = C:\Documents and Settings\All Users\Start Menu
CSIDL_COMMON_PROGRAMS = C:\Documents and Settings\All Users\Start Menu\Programs
CSIDL_COMMON_STARTUP = C:\Documents and Settings\All Users\Start Menu\Programs\Startup
CSIDL_COMMON_DESKTOPDIRECTORY = C:\Documents and Settings\All Users\Desktop
CSIDL_APPDATA = C:\Documents and Settings\myuser\Application Data
CSIDL_PRINTHOOD = C:\Documents and Settings\myuser\PrintHood
CSIDL_LOCAL_APPDATA = C:\Documents and Settings\myuser\Local Settings\Application Data
CSIDL_COMMON_FAVORITES = C:\Documents and Settings\All Users\Favorites
CSIDL_INTERNET_CACHE = C:\Documents and Settings\myuser\Local Settings\Temporary Internet Files
CSIDL_COOKIES = C:\Documents and Settings\myuser\Cookies
CSIDL_HISTORY = C:\Documents and Settings\myuser\Local Settings\History
CSIDL_COMMON_APPDATA = C:\Documents and Settings\All Users\Application Data
CSIDL_WINDOWS = C:\WINDOWS
CSIDL_SYSTEM = C:\WINDOWS\system32
CSIDL_PROGRAM_FILES = C:\Program Files
CSIDL_PROFILE = C:\Documents and Settings\myuser
CSIDL_SYSTEMX86 = C:\WINDOWS\system32
CSIDL_PROGRAM_FILES_COMMON = C:\Program Files\Common Files
CSIDL_COMMON_TEMPLATES = C:\Documents and Settings\All Users\Templates
CSIDL_COMMON_DOCUMENTS = C:\Documents and Settings\All Users\Documents
CSIDL_COMMON_ADMINTOOLS = C:\Documents and Settings\All Users\Start Menu\Programs\Administrative Tools
CSIDL_ADMINTOOLS = C:\Documents and Settings\myuser\Start Menu\Programs\Administrative Tools
CSIDL_COMMON_MUSIC = C:\Documents and Settings\All Users\Documents\My Music
CSIDL_COMMON_VIDEO = C:\Documents and Settings\All Users\Documents\My Videos
CSIDL_RESOURCES = C:\WINDOWS\resources
CSIDL_CDBURN_AREA = C:\Documents and Settings\myuser\Local Settings\Application Data\Microsoft\CD Burning
CSIDL_FLAG_PER_USER_INIT = C:\Documents and Settings\myuser\Desktop
CSIDL_FLAG_NO_ALIAS = C:\Documents and Settings\myuser\Desktop
CSIDL_FLAG_DONT_UNEXPAND = C:\Documents and Settings\myuser\Desktop
CSIDL_FLAG_DONT_VERIFY = C:\Documents and Settings\myuser\Desktop
CSIDL_FLAG_CREATE = C:\Documents and Settings\myuser\Desktop



Windows XP french example results with myuser user


c:\> .\GetSpecialFolderPath.ps1
CSIDL_COMMON_DESKTOPDIRECTORY = C:\Documents and Settings\All Users\Bureau
CSIDL_DESKTOP = C:\Documents and Settings\myuser\Bureau
CSIDL_PROGRAMS = C:\Documents and Settings\myuser\Menu Démarrer\Programmes
CSIDL_PERSONAL = D:\DONNEES
CSIDL_MYDOCUMENTS = D:\DONNEES
CSIDL_FAVORITES = C:\Documents and Settings\myuser\Favoris
CSIDL_STARTUP = C:\Documents and Settings\myuser\Menu Démarrer\Programmes\Démarrage
CSIDL_RECENT = C:\Documents and Settings\myuser\Recent
CSIDL_SENDTO = C:\Documents and Settings\myuser\SendTo
CSIDL_STARTMENU = C:\Documents and Settings\myuser\Menu Démarrer
CSIDL_MYMUSIC = D:\DONNEES\Ma musique
CSIDL_MYVIDEO = D:\DONNEES\Mes vidéos
CSIDL_DESKTOPDIRECTORY = C:\Documents and Settings\myuser\Bureau
CSIDL_NETHOOD = C:\Documents and Settings\myuser\Voisinage réseau
CSIDL_FONTS = C:\WINDOWS\Fonts
CSIDL_TEMPLATES = C:\Documents and Settings\myuser\Modèles
CSIDL_COMMON_STARTMENU = C:\Documents and Settings\All Users\Menu Démarrer
CSIDL_COMMON_PROGRAMS = C:\Documents and Settings\All Users\Menu Démarrer\Programmes
CSIDL_COMMON_STARTUP = C:\Documents and Settings\All Users\Menu Démarrer\Programmes\Démarrage
CSIDL_COMMON_DESKTOPDIRECTORY = C:\Documents and Settings\All Users\Bureau
CSIDL_APPDATA = C:\Documents and Settings\myuser\Application Data
CSIDL_PRINTHOOD = C:\Documents and Settings\myuser\Voisinage d'impression
CSIDL_LOCAL_APPDATA = C:\Documents and Settings\myuser\Local Settings\Application Data
CSIDL_COMMON_FAVORITES = C:\Documents and Settings\All Users\Favoris
CSIDL_INTERNET_CACHE = C:\Documents and Settings\myuser\Local Settings\Temporary Internet Files
CSIDL_COOKIES = C:\Documents and Settings\myuser\Cookies
CSIDL_HISTORY = C:\Documents and Settings\myuser\Local Settings\Historique
CSIDL_COMMON_APPDATA = C:\Documents and Settings\All Users\Application Data
CSIDL_WINDOWS = C:\WINDOWS
CSIDL_SYSTEM = C:\WINDOWS\system32
CSIDL_PROGRAM_FILES = C:\Program Files
CSIDL_MYPICTURES = D:\DONNEES
CSIDL_PROFILE = C:\Documents and Settings\myuser
CSIDL_SYSTEMX86 = C:\WINDOWS\system32
CSIDL_PROGRAM_FILES_COMMON = C:\Program Files\Fichiers communs
CSIDL_COMMON_TEMPLATES = C:\Documents and Settings\All Users\Modèles
CSIDL_COMMON_DOCUMENTS = C:\Documents and Settings\All Users\Documents
CSIDL_COMMON_ADMINTOOLS = C:\Documents and Settings\All Users\Menu Démarrer\Programmes\Outils d'administration
CSIDL_ADMINTOOLS = C:\Documents and Settings\myuser\Menu Démarrer\Programmes\Outils d'administration
CSIDL_COMMON_MUSIC = C:\Documents and Settings\All Users\Documents\Ma musique
CSIDL_COMMON_PICTURES = C:\Documents and Settings\All Users\Documents\Mes images
CSIDL_COMMON_VIDEO = C:\Documents and Settings\All Users\Documents\Mes vidéos
CSIDL_RESOURCES = C:\WINDOWS\resources
CSIDL_CDBURN_AREA = C:\Documents and Settings\myuser\Local Settings\Application Data\Microsoft\CD Burning
CSIDL_FLAG_PER_USER_INIT = C:\Documents and Settings\myuser\Bureau
CSIDL_FLAG_NO_ALIAS = C:\Documents and Settings\myuser\Bureau
CSIDL_FLAG_DONT_UNEXPAND = C:\Documents and Settings\myuser\Bureau
CSIDL_FLAG_DONT_VERIFY = C:\Documents and Settings\myuser\Bureau
CSIDL_FLAG_CREATE = C:\Documents and Settings\myuser\Bureau

Sunday, May 15, 2011

findstr does not support unicode

I often use findstr command on my windows XP to find some informations in text files (grep for unix)

For example with this command

findstr /i "PC2K01" *.*

you will have something like:

File_WIN_PC01_20110414.csv:2011-04-14;PC2K01;;G:;72;62;WINDOWS
File_WIN_PC01_20110414.csv:2011-04-14;PC2K01;;H:;54;49;WINDOWS


I don't remember having problems to find something with findstr command. Except today, when I try to find a computer name in some files. I was completely sure this computer exist in my files and findstr doesn't find this computer...
Finally, I found manually the file containing my computer. So I decided to understand why findstr didn't work. 2 reasons appears to me immediatly: 1st-findstr is bugged. 2nd-there is an encoding problem. To verify this 2nd reason I tested all my files with Get-FileEncoding.ps1
like this

Import-Module .\Get-FileEncoding.ps1
Get-ChildItem | select name, @{n='Encoding';e={Get-FileEncoding $_.FullName}}


Then it appears some file are in Unicode

Name Encoding
---- --------
1.csv ASCII
2.csv Unicode UTF-16 Little-Endian
3.csv ASCII
4.csv ASCII
5.csv ASCII
6.csv ASCII


To verify my idea was good, I just tested something that exist in unicode file 2.csv. In file 2.csv there is the string mystring and only in this file.

findstr /i "mystring" 2.csv

and nothing appears. Findstr does not support unicode....

The solution: convert all your files to ansi.
For this, use this command to create files ANSI_1.csv ANSI_2.csv ...

Get-ChildItem | Foreach-Object { Get-Content -Path $_.Fullname | Out-File ANSI_$_ -Encoding Default }

(for information, you can also do it manually by using notepad / file save as / and changing encoding)

some other ideas if you don't want to convert your files to ansi:
- use find command which is unicode (yes find is unicode / not findstr...)

- use Microsoft sysinternals strings utility
http://technet.microsoft.com/en-us/sysinternals/bb897439

- use powershell

Select-String *.* -pattern "string" | Select-Object filename,pattern,line

Friday, May 6, 2011

Enumerate your own enum in Powershell

Enumeration does not really exist in Powershell. However, when I wrote my ExportRegistyToFile Powershell script, I use 2 techniques of "enumeration".

1st: easily way using hash
Declaration:

$DataTypes = @{"enum1" = "1"; "enum2" = "2"; "enum3" = "3"}


Enumeration:

$DataTypes.Keys

That display (remember hash is not array, so you can have enum2 before enum1 but you set enum1 before enum2)

enum2
enum1
enum3



Enumerate a key and his value:

$enum = "enum2"
Write-Host "Enum:" $enum "value:" $DataTypes ["$enum"]

which display

Enum: enum2 value: 2


Now, 2nd technique to do an enumeration by using add-type (this is the same technique you use when you want to do a pinvoke for accessing win32 api)
Declaration:

$signature = @"
public enum MyEnum : int {
enum1 = 0x0001,
enum2 = 0x0002,
enum3 = 0x0003
}
"@
$type = Add-Type -TypeDefinition $signature -Name Enum -Namespace Data -Using System.Text -PassThru



Enumeration (with + tips - Namespace.functionname+yourenum)

[Enum]::GetNames([Data.Enum+MyEnum])

which display

enum1
enum2
enum3



Enumerate a key and his value:

$enum = "enum2"
Write-Host "Enum:" ([Data.Enum+MyEnum]::$enum) "value:" ([Data.Enum+MyEnum]::$enum.value__)

which display

Enum: enum2 value: 2



There is a great article on scripting guys blog that explain this last technique
http://blogs.technet.com/b/heyscriptingguy/archive/2010/06/06/hey-scripting-guy-weekend-scripter-the-fruity-bouquet-of-windows-powershell-enumerations.aspx


Below a powershell script to test these 2 techniques (Download it)

#
#
# Enum
#
# by F.Richard 2011-05
#
#

#Requires -Version 2.0

$signature = @"
public enum MyEnum : int {
enum1 = 0x0001,
enum2 = 0x0002,
enum3 = 0x0003
}
"@

# Register Enum functions
If (-not ("Data.Enum" -as [Type])) {
$type = Add-Type -TypeDefinition $signature -Name Enum -Namespace Data -Using System.Text -PassThru
} else {
If ($debug) { Write-Host "Data.Enum already Registered" }
}


[Enum]::GetNames([Data.Enum+MyEnum])
$enum = "enum2"
Write-Host "Enum:" ([Data.Enum+MyEnum]::$enum) "value:" ([Data.Enum+MyEnum]::$enum.value__)


$DataTypes = @{"enum1" = "1"; "enum2" = "2"; "enum3" = "3"}
$DataTypes.Keys
$enum = "enum2"
Write-Host "Enum:" $enum "value:" $DataTypes["$enum"]