PowerShell General

Hashtable export-csv format output

ddan — Thu, 16 May 2013 05:35:29 GMT

Hi,

I have a Hashtable that looks like this:

NAME;VALUE

LibraryA;345

LibraryB;867

LibraryC;858

RegionalLibraryT;156

RegionalLibraryY;99

LibraryG;689

This is not the order in which I created the Hashtable, after I am done processing, this is the result I get when calling it.

How do I go about putting it in the order I would like to specify (not assending/desending etc) but in an order of my choice (by row). I will eventually like to export it to csv.

Something like:

RegionalLibraryT;value

RegionalLibraryY;value

LibraryC;value

LibraryB;value

LibraryA;value

Thanks

adding new values to a psobject?

Sven — Fri, 17 May 2013 12:16:22 GMT

Hi,

maybe I'm too stupid but I looked through the web for two days now and I can't find a solution.

I created a PSobject and added some properties and values. it looks like this:

  $script:resultall = new-Object PSobject
  Add-Member -InputObject $resultall -memberType NoteProperty -Name DisplayName -Value "Test1"
  Add-Member -InputObject $resultall -memberType NoteProperty -Name Status -Value "Status1"

Now I want to add a second line with similar values to my object but it doesn't work in any way.

Every hint is welcome...

Sven

Download files from Codeplex with start-bitstransfer

THT — Mon, 20 May 2013 10:36:25 GMT

Hello, I'm quite new to Powershell. I want to download some files from the internet.

In some cases there is no problem:

Getting Windows6.1-KB974405-x64.msu from Microsoft:

Start-BitsTransfer 'http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu' "g:\"

which is

<a href="http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu">Hier klicken</a> on the download site.

but if I want to download something from Codeplex it won't work.

<a tabindex="9" id="fileDownload1" href="http://autospsourcebuilder.codeplex.com/downloads/get/486671" class="FileNameLink">AutoSPSourceBuilder.zip</a>

I tried

Start-BitsTransfer 'http://autospsourcebuilder.codeplex.com/downloads/get/486671/AutoSPSourceBuilder.zip' "g:\"

Result

Start-BitsTransfer : HTTP-Status 500: Der Server kann die Anforderung aufgrund eines unbekannten Fehlers nicht erfüllen.

Bei Zeile:1 Zeichen:19
+ Start-BitsTransfer <<<< 'http://autospsourcebuilder.codeplex.com/downloads/get/486671/AutoSPSourceBuilder.zip' "g:\"
+ CategoryInfo : InvalidOperation: (:) [Start-BitsTransfer], Exception
+ FullyQualifiedErrorId : StartBitsTransferCOMException,Microsoft.BackgroundIntelligentTransfer.Management.NewBitsTransferCommand

also

Start-BitsTransfer 'http://autospsourcebuilder.codeplex.com/downloads/get/486671' "g:\"

Start-BitsTransfer 'http://autospsourcebuilder.codeplex.com/downloads/get/486671#' "g:\"

with the same result.

Any ideas, how to download from codeplex?

Many thanks in advance,

Thorsten

reboot a list of servers and output results to file.

psnewbie2013 — Mon, 20 May 2013 15:04:56 GMT

I am new to powershell and i am trying to write a simple script that will reboot a list of machines (XP, and 7) and input the results of the reboots to a text file. I created the below script that reboots the machine and creates the output file, but when I open the file I do not see any results in it.

restart-computer (get-content c:\reboot\rebootlist.txt) | out-file -filepath c:\results.txt

I also found the below script but for some reason it will not work, but it's not rebooting the machines. I can get it to show me the list of machines in the text file but it does not reboot them. My plan was to get it working and output the results to a file, but it's not working out for me.

Get-Content C:\reboot\rebootlist.txt |
   Where {test-connection $_ -quiet -count 2} |
   foreach {
    write-host "Restarting $_ "-force "Green"
    Restart-Computer $_ -force -whatif}

Please let me know if you have any suggestions.

Call a 2nd PS, as another user and bring back paramters

Matt Chapman — Mon, 20 May 2013 13:46:07 GMT

I'm new to PS, but not scripting in general and am trying to create a script to automate our Win7 build process.

For various reasons, the machine will be built off the domain, then join itself to an existing machine account at the end.

In order to get the right set of applications installed, the machine account is added to an AD group when created and this info will need to be pulled back to call the applications.

During the build, the machine gets logged on as a local user with admin rights which has no access to the domain.

Now we come to the issue I am having...

I can get the PS1 to call PS2 one and pull back the required parameters, but only while logged on with a domain account.

The PS1 is as follows with some options I've tried commented out:

#Invoke-Command -FilePath R:\PostBuild\OUInfo.ps1 #Invoke-Command -Credential $strCred -ScriptBlock {$strOU, $strCompName = & "R:\PostBuild\OUInfo.ps1"} $strOU, $strCompName = & "R:\PostBuild\OUInfo.ps1" -Credential $strCred

There is a working command above this to set $strCred - I know this works as it has been copied from a working PS.

When I try either of the Invoke-Command lines, I just get the following error:

Invoke-Command : Parameter set cannot be resolved using the specified named parameters.

At R:\PostBuild\PostBuild.ps1:10 char:15

+ Invoke-Command <<<< -FilePath R:\PostBuild\OUInfo.ps1

+ CategoryInfo : InvalidArgument: (:) [Invoke-Command], ParameterBindingException

+ FullyQualifiedErrorId : AmbiguousParameterSet,Microsoft.PowerShell.Commands.InvokeCommandCommand

But the line not using Invoke-Command works while run as a network user but doesn't use the credentials provided and thus falls over when run as a local user.

Sorry if I've been a bit ambiguous here, I may not be explaining myself properly

Does anyone know of a way to do what I need to do?

Thanks in advance

Matt

Very Old FTP, Need Password Encripted

Derleth — Thu, 16 May 2013 17:33:11 GMT

We have a very very very old mainframe here and the FTP that can pull from it is also old and I need to pull a couple of files from it on a daily basis using PowerShell (PS.) This is not a problem, it’s very easy. The problem is I can’t encrypt the password because the only way I can figure out how to get the files is to have PS call a text file that fills in the FTP info.
ftp -s:C:\POWERSHELL\LIVESCRIPTS\FTP.txt

The text file simply has…
open 123.456.78.90
AccountName
Password123
get 'taz.arc.tape.daily' E:\DAILY\DAILY1\DAILY
quit

Note that the target is ‘taz.arc.tape.daily’ and has periods instead of backslashes. This is because there really is not a path, the full file name is ‘taz.arc.tape.daily’ but when I pull it down it becomes simply ‘daily’

This opens the FTP, logs on and pulls the file from the FTP to the location I want and closes the FTP. It works perfectly except the fact that anybody can open the text file and see the password. I know how to encrypt the password in PS but what I need to know is… Ether how to encrypt the password in the text file or how to have the password be a variable in PS that can be used at that spot in the text file.

One solution I came up with is to have PS make the text file and delete it at the end of the script. This is not perfect because somebody could grab the text file before PS has the chance to delete it. It is at least making it harder for someone to get the password but I would like it to be a lot more secure than that.

Any help is appreciated. Thank you, -Dan

Import-PSSession, bug or bug-like feature?

JMMurrah — Fri, 17 May 2013 13:36:12 GMT

Good Morning,

I've come across a strange error with the import-pssession cmdlet, and wanted to run it by the experts. I'm using it in a larger account creation script the import the exchange cmdlets from an exchange server to create a mailbox. In testing it all in the shell the below commands work fine:

$session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri http://$exchangeserver/powershell

Import-PSSession -session $session -AllowClobber -DisableNameChecking

However, when I run them in my larger script, I get the below error:

Import-PSSession : Cannot convert null to type "System.DateTime".

At C:\scripts\importbug.ps1:8 char:5

+ Import-PSSession -session $session -AllowClobber -DisableNameChecking

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : MetadataError: (:) [Import-PSSession], ArgumentTransformationMetadataException

+ FullyQualifiedErrorId : RuntimeException,Microsoft.PowerShell.Commands.ImportPSSessionCommand

Now I couldn't for the life of me figure out what Import-PSSession would be doing with any dateTime values, or even what null variable I was passing to it. After deconstructing my script I narrowed it down the following minimum code to illustrate the error:

Function Get-Exchangecmdlets {

param(

[string]$ExchangeServer,

[datetime]$date

)

$session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri http://$exchangeserver/powershell -AllowRedirection -Authentication Kerberos

Import-PSSession -session $session -AllowClobber -DisableNameChecking

}

Get-Exchangecmdlets -ExchangeServer 'exchangeserver1' #This throws the error

Get-Exchangecmdlets -ExchangeServer 'exchangeserver1' -Date "10/10/2013" #This does not

So it seems that when import-pssession runs, it validates all the variables in its parent function. Since $Date wasn't specified, it was null, which can't be converted to DateTime, hence the error. This error also appeared with parameters using the [validatescript] setting, such as:

Function Get-Exchangecmdlets {

[cmdletbinding()]

param(

[string]$ExchangeServer,

[ValidateScript({test-path (Split-Path -Path $_ -Parent)})]

[string]$ErrorLog

)

$session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri http://$exchangeserver/powershell -AllowRedirection -Authentication Kerberos

Import-PSSession -session $session -AllowClobber -DisableNameChecking

}

Get-Exchangecmdlets -ExchangeServer 'exchangeserver1' #This throws the error

Import-PSSession : Cannot bind argument to parameter 'Path' because it is an empty string.

At C:\scripts\importbug.ps1:10 char:5

+ Import-PSSession -session $session -AllowClobber -DisableNameChecking

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidData: (:) [Import-PSSession], ParameterBindingValidationException

+ FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Microsoft.PowerShell.Commands.ImportPSSessionCommand

I didn’t test the other validation methods, but I suspect they’ll all throw the error.

Once identified this is easy enough to work around, I simply made a separate function for the import-pssession with no optional parameters and no validation. However, since optional parameters should only be validated if a value is provided, this seems rather bug-like to me. Nothing in the documentation for Import-PSSession jumped out at me as suggesting that variables are re-processed or anything like that.

Thoughts?

Need help putting a Log file and Error codes

osramos — Tue, 14 May 2013 13:57:24 GMT

Hi there guys. I am a rookie in PS and i need some help of you.

I have this script below to copy files/folder from one location to a list of servers, and i have 2 problems. The firts is to put some king of error output to a log when the copy of a file is unsucessfull ou sucessfull, and the other is how to put all this in a file Log. Because sometime we must show the logs of the copied files to our custumers when something is goin wrong.

#Point the script to the text file

$Computers = Get-Content "C:\DEP\servers.txt"

# sets the varible for the file location ei c:\temp\ThisFile.exe
#$Source = Get-Content -path "C:\DEPLOYMENT\SOURCE1"
# sets the varible for the file destination
#$Destination = Read-Host "\edp\sit_swaf\work\patches\dm_patches\"
$rc = 0
$Destination = "\output\"
$date = (Get-Date -UFormat "%Y%m%d%H%M")+".log"

# displays the computer names on screen

$log = "C:\LOGS\copy_files.$date

foreach($path in $Computers)
{

    Echo "########################################################################################" >> $log
    Echo "`n########################################################################################" >> $log
    Echo "Working with Server $Computers" >> $log

    Copy-Item -Recurse -Path "C:\SOURCE1\*.*" -Destination \\$path\$Destination -Force

      if ($rc - neq 0)
    {
         Echo "`n########################################################################################" >> $log
          Echo "Copy files with error in $Computers" >> $log

    }

     Echo "`nCompleted Working with $server" >> $log
}

Echo "########################################################################################" >> $log

Could someone help me on this?

Regards,

osramos

Output to SQL

ScholesScores — Thu, 16 May 2013 11:28:08 GMT

Hi,

I have a script that will query WMI on my servers and return key metrics (disk space, memory use etc) to a SQL database. I have the basics and can successfully write to the SQL database but I've hit a problem when there are multiple rows being returned for a single item.

For example, I query Win32_Volume for each server in a list. Each server has at least 3 volumes which PowerShell outputs as seperate "group" of data for each volume:

The problem is when the data is written to the SQL table, it is written as one row, with 3 pieces of information in each column.

I want it in SQL as one row per volume per server.

I have the same issue when a server has multiple occurences of the same item, network adapter, processors etc.

I've tried pipeing the results into each Format- but that does't change what's written into SQL. I'm guessing I need to put the result into an array and perform a seperate SQL INSERT for each element but I don't know where to start!

The full script (as it stands):

Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100

# get server names from SQL table to loop through
$DataSet = Invoke-Sqlcmd -Database ServerStats -Query "SELECT ServerName FROM [ServerStats].[dbo].[ServerList]" -ServerInstance <SQL>

# get disk stats
foreach ($element in $DataSet)
{
$element
$Server = $element.ServerName

# Get metrics for each server in the ServerStats.ServerList
$Output = Get-WmiObject -Class Win32_Volume -Computer $Server | Select-Object SystemName,Capacity,DriveType,DriveLetter,FreeSpace -ExcludeProperty "_*"

    # Output to SQL Server table
    ##Connect to the SQL server and the Database
    $conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=<SQL>; Initial Catalog=ServerStats; Integrated Security=SSPI")

    ## Open DB Connection
    $conn.Open()

        #Create SQL Insert Statement with your values
        $insert_stmt = "INSERT INTO Disk(ComputerName,Size,DiskType,DriveLetter,FreeSpace) VALUES ('$Server','$($Output.Capacity)','$($Output.DriveType)','$($Output.DriveLetter)','$($Output.FreeSpace)')"

        ## Create your command
        $cmd = $conn.CreateCommand()
        $cmd.CommandText = $insert_stmt

        ## Invoke the Insert statement
        $cmd.ExecuteNonQuery()

    ## Close DB Connection
    $conn.Close()
}
# end disk stats

# get network adapter stats
foreach ($element in $DataSet)
{
$element
$Server = $element.ServerName

# Get metrics for each server in the ServerStats.ServerList
$Output = Get-WmiObject -Class Win32_NetworkAdapter -Computer $Server | Select-Object PSComputerName,ServiceName,MACAddress,Name,Speed -ExcludeProperty "_*"

    # Output to SQL Server table
    ##Connect to the SQL server and the Database
    $conn = New-Object System.Data.SqlClient.SqlConnection("Data Source=<SQL>; Initial Catalog=ServerStats; Integrated Security=SSPI")

    ## Open DB Connection
    $conn.Open()

        #Create SQL Insert Statement with your values
        $insert_stmt = "INSERT INTO NetworkAdapter(ComputerName,ServiceName,MACAddress,Name,Speed) VALUES ('$Server','$($Output.ServiceName)','$($Output.MACAddress)','$($Output.Name)','$($Output.Speed)')"

        ## Create your command
        $cmd = $conn.CreateCommand()
        $cmd.CommandText = $insert_stmt

        ## Invoke the Insert statement
        $cmd.ExecuteNonQuery()

    ## Close DB Connection
    $conn.Close()
}
# end network adapter stats

Any help would be appreciated..

Speed up powershell script with PrimalForms

lgieske — Wed, 15 May 2013 09:10:13 GMT

Hi,

i wrote a script that requires user interaction, the gui was designed with Primalforms. The user can run the script with a simple desktop link.

The first time i run the script the start takes ca. 10-15 seconds. Some user thougth that nothing happens and starts the script again.

Does anyone know a way to show a status while loading the script or any other ideas to show informations that the script starts?

Tanks.

$PrinterList = IMPORT-CSV C:\printersL.csv

Morphius_ca — Thu, 09 May 2013 19:46:56 GMT

Need to include a csv file command below

Location.ps1

$printer = Get-WmiObject win32_printer -Comp PPR235QFLS01| Where-Object { $_.name -eq "OTT235Q-354A-X7535" }

$printer.Location = "OTT235QDC"

$printer.Put()

Also tried

$PrinterList=IMPORT-CSV C:\printer.csv
$USERLIST | FOREACH-OBJECT { $_ }

FOREACH ($Printer in $PrinterList) {
$Location=$Printer.Location
$printer = Get-WmiObject win32_printer -Comp PPR235QFLS01| Where-Object { $_.name -eq "$($Printer.Name)" }
$printer.Location = "$($Printer.Location)"
$printer.Put()
}

I need to update the printer location on roughly 900 printers in print management (Print Management Microsoft Corporation Version: 6.1.7600.16385)

csv file as:

Server, Location, Printer Name,

Remi

Clearing only Variables if they are not null

Goldy — Tue, 14 May 2013 15:04:15 GMT

So, either i'm missing something or it's just not possible in the fashion i'm doing it.

So I take all the variables I have and put them in an array like

$vararray = @("A","B","C","D")

Then I tried something like

$vararray | % {

if ($_ -ne $Null) {

clear-variable -name $_

}

But that will not work b/c $_ will always be a letter

So, then I tried to build a string out of it, but that didn't work either.

Please tell me i'm missing something and there is something simple to do this other than If statements

Extracting Cisco hardware data from Rancid

Steve4586 — Thu, 02 May 2013 07:24:52 GMT

Hi all,

I have extracted data from RANCID using egrep across the CVS to provide information on the device FDQN, Chassis Type, Serial No and the part number and serial numbers of any cards or slots occuried.

My problem is having cleaned the data I have the output in a text file, I need to output this to csv to use either in Access or Excel. However, each device maybe simple e.g. 2950 switch with 4 elements or a complex device e.g. 6509 with multiple slots occupied and various modules in the slots creating an unknown number of lines for the device.

My data runs to around 5 - 6,000 devices. Normally I would create an PSObject and use that, but I can't see how to do this with data of variable lines output.

Any pointers will be welcomed and helpful.

Environment: XXX
Hostname: xxxx.xx
Chassis type: WS-CBS3020-HPQ - a WS-CBS3020-HPQ router
Processor ID: XXXX
Serial No: XXXX

AND

Environment: XXX
Hostname: XXXX
Chassis type: 1721 - a 1721 router
Processor ID: XXXXL
PID: 1721
Serial No: XXXX
PID: 1700 Chassis Slot
Serial No:
PID: C1721 Mainboard
Serial No: XXXX
PID: 1700 DaughterCard Slot
Serial No: XXXX
PID: WAN Interface Card - Serial (1T)1.0
Serial No: XXXX
PID: PowerQUICC Serial
Serial No: XXXX
PID: 1700 DaughterCard Slot
Serial No: XXXX

AND

Environment: XXXX
Hostname: xxx.xxx
Chassis type: 2821 - a 2821 router
Processor ID: XXXX
Serial No: XXXX
Serial No: XXXX
Serial No: XXXX

Thank you

start-CMPackageDeployment is broken, how to bypass?

AmnonFeiner — Sun, 12 May 2013 00:45:07 GMT

I am looking for some help or ideas. We used Greg Ramsey's script as the base to handle the scenario in the subject, unfortunately the Cmdlet to do the same for legacy packages seem to be broken by CU1.

the error

WARNING: Mandatory schedule or events must be set for Required offer type.

the command

Start-CMPackageDeployment -CollectionName mycollection -PackageId NY1000DE -StandardProgramName USER -AllowSharedContent $True -AllowUsersRunIndependently $True -DeploymentAvailableDay 2013/05/07 -DeploymentAvailableTime 20:00 -DeployPurpose Required -FastNetworkOption RunProgramFromDistributionPoint -PersistOnWriteFilterDevice $False -RerunBehavior RerunIfFailedPreviousAttempt -ScheduleEvent AsSoonAsPossible -SlowNetworkOption DownloadContentFromDistributionPointAndLocally -So

Does anyone have an idea or sample how I could bypass the issue? I am reading the Deployment characteristics, trying to delete the old and create a new Required one.

thank you

P.S.

No SCCM specific forum :-)?

Out-Gridview to Excel with column headers

slittle — Sat, 11 May 2013 13:31:32 GMT

I am running an external application that creates a Powershell Out-Gridview, perfoms sendkeys for ^a and ^c then pastes the values into a new instance of Excel.

Works fine, but would like to include the column headers as first row in Excel.

Is this possible, or should I just output to .csv then Invoke-Item?

Stan

My Options for Invoke-Command

Lery — Thu, 09 May 2013 21:22:44 GMT

I'm running into a real road block. I need to execute a method on a .NET COM object remotely. The only way I know to do this on a remote computer is through invoke-command. The problem is security My knowledgeable VB guy says that he can do it through a VB script with no prerequisites. The environment I'm running my invoke-command on absolutely has not had enable-psremoting run on their endpoints. So invoke-command is now useless. The only option I can come up with is to download PSEXEC and use that to enable psremoting. I just hate that solution.

In case you're wondering, my command is:

invoke-command -computer computername -scriptblock {(New-Object -Comobject Obiwan.Kenobi)update(1)}

Works fine if the target computer has had enable-psremoting run on it. If it has not, I'm SOL.

Copy sections from a text file out to another text file

operez — Mon, 04 Feb 2013 18:05:04 GMT

I'm new to powershell, but I need to read a text file and copy sections out to another text file. Is this possible?

I need to read the first text file line by line until I come to a specific word, (like 'keyword') then starting with the next line copy each line read to another text file until I come to another set of words. (like 'this' or 'that') then go back to reading the text file until I come to the first 'keyword' again and start copying lines to the second text file again, until I come to 'this' or 'that' again and repeat through the file. The text file is 26,000+ lines long.

Can someone help me with this?

Best way to install roles and features in server 2008 r2

Chaitanyakumar G — Fri, 26 Apr 2013 08:23:39 GMT

Hi All,

I want to install below roles in server 2008 r2. I use import-module servermanager, add-windows feature myroles_and_features. Here are the roles and features:

gpmc,Web-Server,Web-Common-Http,Web-Default-Doc,Web-Mgmt-Tools,Web-Mgmt-Console,Web-Scripting-Tools,Web-Mgmt-Service,Web-Mgmt-Compat,Web-Metabase,Web-WMI,Web-Lgcy-Scripting,Web-Lgcy-Mgmt-Console,RDS-RD-Server,RDS-Licensing,NET-Framework, NET-Framework-Core, Application-Server.

What is the best way to install all these roles with the add-windows feature command. Because I think some of the above roles might need a restart. For example, if I execute all the above roles at a time, It throws me an error saying application-server is not installed. So, I am executing all the above roles except application-server role, then reboot and then install application-server role. Hence I want to know what is the best way to install all the above roles.

Chaitanya.

ConvertFrom-Json cannot read my Json

slittle — Tue, 07 May 2013 22:49:12 GMT

I have posted the attached json on two validation sites and it was validated but if I pass it on the pipeline to convertfrom-json I get an error. Other json files I have tried work.

{
    "Cars": [
        {
            "Year": "2000",
            "Make": "Acura",
            "Model": "Integra"
        },
        {
            "Year": "2000",
            "Make": "Acura",
            "Model": "NSX"
        },
        {
            "Year": "2000",
            "Make": "Acura",
            "Model": "RL"
        },
        {
            "Year": "2000",
            "Make": "Acura",
            "Model": "TL"
        },
        {
            "Year": "2000",
            "Make": "Audi",
            "Model": "A4"
        },
        {
            "Year": "2000",
            "Make": "Audi",
            "Model": "A6"
        },
        {
            "Year": "2000",
            "Make": "Audi",
            "Model": "A8"
        },
        {
            "Year": "2000",
            "Make": "Audi",
            "Model": "S4"
        },
        {
            "Year": "2000",
            "Make": "Audi",
            "Model": "TT"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "3 Series"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "5 Series"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "7 Series"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "M"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "M5"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "X5"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "Z3"
        },
        {
            "Year": "2000",
            "Make": "BMW",
            "Model": "Z8"
        },
        {
            "Year": "2000",
            "Make": "Buick",
            "Model": "Century"
        },
        {
            "Year": "2000",
            "Make": "Buick",
            "Model": "LeSabre"
        },
        {
            "Year": "2000",
            "Make": "Buick",
            "Model": "Park Avenue"
        },
        {
            "Year": "2000",
            "Make": "Buick",
            "Model": "Regal"
        },
        {
            "Year": "2000",
            "Make": "Cadillac",
            "Model": "Catera"
        },
        {
            "Year": "2000",
            "Make": "Cadillac",
            "Model": "DeVille"
        },
        {
            "Year": "2000",
            "Make": "Cadillac",
            "Model": "Eldorado"
        },
        {
            "Year": "2000",
            "Make": "Cadillac",
            "Model": "Escalade"
        },
        {
            "Year": "2000",
            "Make": "Cadillac",
            "Model": "Seville"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Astro"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Astro Cargo"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Blazer"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "C/K 2500 Series"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "C/K 3500 Series"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Camaro"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Cavalier"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Corvette"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Express"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Express Cargo"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Impala"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Lumina"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Malibu"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Metro"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Monte Carlo"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Prizm"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "S-10"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Silverado 1500"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Silverado 2500"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Suburban"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Tahoe"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Tahoe Limited/Z71"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Tracker"
        },
        {
            "Year": "2000",
            "Make": "Chevrolet",
            "Model": "Venture"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "300M"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "Cirrus"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "Concorde"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "Grand Voyager"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "LHS"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "Sebring"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "Town and Country"
        },
        {
            "Year": "2000",
            "Make": "Chrysler",
            "Model": "Voyager"
        },
        {
            "Year": "2000",
            "Make": "Daewoo",
            "Model": "Lanos"
        },
        {
            "Year": "2000",
            "Make": "Daewoo",
            "Model": "Leganza"
        },
        {
            "Year": "2000",
            "Make": "Daewoo",
            "Model": "Nubira"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Avenger"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Caravan"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Dakota"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Durango"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Grand Caravan"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Intrepid"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Neon"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Ram Pickup 1500"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Ram Pickup 2500"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Ram Pickup 3500"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Ram Van"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Ram Wagon"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Stratus"
        },
        {
            "Year": "2000",
            "Make": "Dodge",
            "Model": "Viper"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Contour"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Contour SVT"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Crown Victoria"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Econoline Cargo"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Econoline Wagon"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Escort"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Excursion"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Expedition"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Explorer"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "F-150"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "F-150 SVT Lightning"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "F-250 Super Duty"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "F-350 Super Duty"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Focus"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Mustang"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Mustang SVT Cobra"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Ranger"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Taurus"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Windstar"
        },
        {
            "Year": "2000",
            "Make": "Ford",
            "Model": "Windstar Cargo"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "C/K 2500 Series"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "C/K 3500 Series"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Envoy"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Jimmy"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Safari"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Safari Cargo"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Savana"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Savana Cargo"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Sierra 1500"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Sierra 2500"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Sonoma"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Yukon"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Yukon Denali"
        },
        {
            "Year": "2000",
            "Make": "GMC",
            "Model": "Yukon XL"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "Accord"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "Civic"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "CR-V"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "Insight"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "Odyssey"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "Passport"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "Prelude"
        },
        {
            "Year": "2000",
            "Make": "Honda",
            "Model": "S2000"
        },
        {
            "Year": "2000",
            "Make": "Hyundai",
            "Model": "Accent"
        },
        {
            "Year": "2000",
            "Make": "Hyundai",
            "Model": "Elantra"
        },
        {
            "Year": "2000",
            "Make": "Hyundai",
            "Model": "Sonata"
        },
        {
            "Year": "2000",
            "Make": "Hyundai",
            "Model": "Tiburon"
        },
        {
            "Year": "2000",
            "Make": "Infiniti",
            "Model": "G20"
        },
        {
            "Year": "2000",
            "Make": "Infiniti",
            "Model": "I30"
        },
        {
            "Year": "2000",
            "Make": "Infiniti",
            "Model": "Q45"
        },
        {
            "Year": "2000",
            "Make": "Infiniti",
            "Model": "QX4"
        },
        {
            "Year": "2000",
            "Make": "Isuzu",
            "Model": "Amigo"
        },
        {
            "Year": "2000",
            "Make": "Isuzu",
            "Model": "Hombre"
        },
        {
            "Year": "2000",
            "Make": "Isuzu",
            "Model": "Rodeo"
        },
        {
            "Year": "2000",
            "Make": "Isuzu",
            "Model": "Trooper"
        },
        {
            "Year": "2000",
            "Make": "Isuzu",
            "Model": "VehiCROSS"
        },
        {
            "Year": "2000",
            "Make": "Jaguar",
            "Model": "S-Type"
        },
        {
            "Year": "2000",
            "Make": "Jaguar",
            "Model": "XJR"
        },
        {
            "Year": "2000",
            "Make": "Jaguar",
            "Model": "XJ-Series"
        },
        {
            "Year": "2000",
            "Make": "Jaguar",
            "Model": "XKR"
        },
        {
            "Year": "2000",
            "Make": "Jaguar",
            "Model": "XK-Series"
        },
        {
            "Year": "2000",
            "Make": "Jeep",
            "Model": "Cherokee"
        },
        {
            "Year": "2000",
            "Make": "Jeep",
            "Model": "Grand Cherokee"
        },
        {
            "Year": "2000",
            "Make": "Jeep",
            "Model": "Wrangler"
        },
        {
            "Year": "2000",
            "Make": "Kia",
            "Model": "Sephia"
        },
        {
            "Year": "2000",
            "Make": "Kia",
            "Model": "Spectra"
        },
        {
            "Year": "2000",
            "Make": "Kia",
            "Model": "Sportage"
        },
        {
            "Year": "2000",
            "Make": "Land Rover",
            "Model": "Discovery Series II"
        },
        {
            "Year": "2000",
            "Make": "Land Rover",
            "Model": "Range Rover"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "ES 300"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "GS 300"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "GS 400"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "LS 400"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "LX 470"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "RX 300"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "SC 300"
        },
        {
            "Year": "2000",
            "Make": "Lexus",
            "Model": "SC 400"
        },
        {
            "Year": "2000",
            "Make": "Lincoln",
            "Model": "Continental"
        },
        {
            "Year": "2000",
            "Make": "Lincoln",
            "Model": "LS"
        },
        {
            "Year": "2000",
            "Make": "Lincoln",
            "Model": "Navigator"
        },
        {
            "Year": "2000",
            "Make": "Lincoln",
            "Model": "Town Car"
        },
        {
            "Year": "2000",
            "Make": "Mazda",
            "Model": "626"
        },
        {
            "Year": "2000",
            "Make": "Mazda",
            "Model": "B-Series Pickup"
        },
        {
            "Year": "2000",
            "Make": "Mazda",
            "Model": "Millenia"
        },
        {
            "Year": "2000",
            "Make": "Mazda",
            "Model": "MPV"
        },
        {
            "Year": "2000",
            "Make": "Mazda",
            "Model": "MX-5 Miata"
        },
        {
            "Year": "2000",
            "Make": "Mazda",
            "Model": "Protege"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "C43 AMG"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "C-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "CL-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "CLK-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "E55 AMG"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "E-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "M-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "ML55 AMG"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "S-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "SL-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercedes-Benz",
            "Model": "SLK-Class"
        },
        {
            "Year": "2000",
            "Make": "Mercury",
            "Model": "Cougar"
        },
        {
            "Year": "2000",
            "Make": "Mercury",
            "Model": "Grand Marquis"
        },
        {
            "Year": "2000",
            "Make": "Mercury",
            "Model": "Mountaineer"
        },
        {
            "Year": "2000",
            "Make": "Mercury",
            "Model": "Mystique"
        },
        {
            "Year": "2000",
            "Make": "Mercury",
            "Model": "Sable"
        },
        {
            "Year": "2000",
            "Make": "Mercury",
            "Model": "Villager"
        },
        {
            "Year": "2000",
            "Make": "Mitsubishi",
            "Model": "Diamante"
        },
        {
            "Year": "2000",
            "Make": "Mitsubishi",
            "Model": "Eclipse"
        },
        {
            "Year": "2000",
            "Make": "Mitsubishi",
            "Model": "Galant"
        },
        {
            "Year": "2000",
            "Make": "Mitsubishi",
            "Model": "Mirage"
        },
        {
            "Year": "2000",
            "Make": "Mitsubishi",
            "Model": "Montero"
        },
        {
            "Year": "2000",
            "Make": "Mitsubishi",
            "Model": "Montero Sport"
        },
        {
            "Year": "2000",
            "Make": "Nissan",
            "Model": "Altima"
        },
        {
            "Year": "2000",
            "Make": "Nissan",
            "Model": "Frontier"
        },
        {
            "Year": "2000",
            "Make": "Nissan",
            "Model": "Maxima"
        },
        {
            "Year": "2000",
            "Make": "Nissan",
            "Model": "Pathfinder"
        },
        {
            "Year": "2000",
            "Make": "Nissan",
            "Model": "Quest"
        },
        {
            "Year": "2000",
            "Make": "Nissan",
            "Model": "Sentra"
        },
        {
            "Year": "2000",
            "Make": "Nissan",
            "Model": "Xterra"
        },
        {
            "Year": "2000",
            "Make": "Oldsmobile",
            "Model": "Alero"
        },
        {
            "Year": "2000",
            "Make": "Oldsmobile",
            "Model": "Bravada"
        },
        {
            "Year": "2000",
            "Make": "Oldsmobile",
            "Model": "Intrigue"
        },
        {
            "Year": "2000",
            "Make": "Oldsmobile",
            "Model": "Silhouette"
        },
        {
            "Year": "2000",
            "Make": "Plymouth",
            "Model": "Breeze"
        },
        {
            "Year": "2000",
            "Make": "Plymouth",
            "Model": "Grand Voyager"
        },
        {
            "Year": "2000",
            "Make": "Plymouth",
            "Model": "Neon"
        },
        {
            "Year": "2000",
            "Make": "Plymouth",
            "Model": "Prowler"
        },
        {
            "Year": "2000",
            "Make": "Plymouth",
            "Model": "Voyager"
        },
        {
            "Year": "2000",
            "Make": "Pontiac",
            "Model": "Bonneville"
        },
        {
            "Year": "2000",
            "Make": "Pontiac",
            "Model": "Firebird"
        },
        {
            "Year": "2000",
            "Make": "Pontiac",
            "Model": "Grand Am"
        },
        {
            "Year": "2000",
            "Make": "Pontiac",
            "Model": "Grand Prix"
        },
        {
            "Year": "2000",
            "Make": "Pontiac",
            "Model": "Montana"
        },
        {
            "Year": "2000",
            "Make": "Pontiac",
            "Model": "Sunfire"
        },
        {
            "Year": "2000",
            "Make": "Porsche",
            "Model": "911"
        },
        {
            "Year": "2000",
            "Make": "Porsche",
            "Model": "Boxster"
        },
        {
            "Year": "2000",
            "Make": "Saab",
            "Model": "3-Sep"
        },
        {
            "Year": "2000",
            "Make": "Saab",
            "Model": "5-Sep"
        },
        {
            "Year": "2000",
            "Make": "Saturn",
            "Model": "L-Series"
        },
        {
            "Year": "2000",
            "Make": "Saturn",
            "Model": "S-Series"
        },
        {
            "Year": "2000",
            "Make": "Subaru",
            "Model": "Forester"
        },
        {
            "Year": "2000",
            "Make": "Subaru",
            "Model": "Impreza"
        },
        {
            "Year": "2000",
            "Make": "Subaru",
            "Model": "Legacy"
        },
        {
            "Year": "2000",
            "Make": "Subaru",
            "Model": "Outback"
        },
        {
            "Year": "2000",
            "Make": "Suzuki",
            "Model": "Esteem"
        },
        {
            "Year": "2000",
            "Make": "Suzuki",
            "Model": "Grand Vitara"
        },
        {
            "Year": "2000",
            "Make": "Suzuki",
            "Model": "Swift"
        },
        {
            "Year": "2000",
            "Make": "Suzuki",
            "Model": "Vitara"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "4Runner"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Avalon"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Camry"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Camry Solara"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Celica"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Corolla"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "ECHO"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Land Cruiser"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "MR2 Spyder"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "RAV4"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Sienna"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Tacoma"
        },
        {
            "Year": "2000",
            "Make": "Toyota",
            "Model": "Tundra"
        },
        {
            "Year": "2000",
            "Make": "Volkswagen",
            "Model": "Cabrio"
        },
        {
            "Year": "2000",
            "Make": "Volkswagen",
            "Model": "EuroVan"
        },
        {
            "Year": "2000",
            "Make": "Volkswagen",
            "Model": "Golf"
        },
        {
            "Year": "2000",
            "Make": "Volkswagen",
            "Model": "GTI"
        },
        {
            "Year": "2000",
            "Make": "Volkswagen",
            "Model": "Jetta"
        },
        {
            "Year": "2000",
            "Make": "Volkswagen",
            "Model": "New Beetle"
        },
        {
            "Year": "2000",
            "Make": "Volkswagen",
            "Model": "Passat"
        },
        {
            "Year": "2000",
            "Make": "Volvo",
            "Model": "C70"
        },
        {
            "Year": "2000",
            "Make": "Volvo",
            "Model": "S40"
        },
        {
            "Year": "2000",
            "Make": "Volvo",
            "Model": "S70"
        },
        {
            "Year": "2000",
            "Make": "Volvo",
            "Model": "S80"
        },
        {
            "Year": "2000",
            "Make": "Volvo",
            "Model": "V40"
        },
        {
            "Year": "2000",
            "Make": "Volvo",
            "Model": "V70"
        }
    ]
}

Office 365 Script binding problem

taheito — Tue, 07 May 2013 18:23:49 GMT

I am working on a script that doing auto licensing for Office 365 Users,

here is the script

$password = ConvertTo-SecureString "password" -AsPlainText –Force $credential = New-Object System.Management.Automation.PsCredential("myusername",$password) $cred = Get-Credential -cred $credential Import-Module MSOnline Connect-MsolService -Credential $cred $msoExchangeURL = “https://ps.outlook.com/powershell/” $session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri $msoExchangeURL -Credential $cred -Authentication Basic -AllowRedirection $Users = Get-MsolUser -Maxresults 200000 -DomainName MyDomain.com –UnlicensedUsersOnly | Select UserPrincipalName $AccountSkuIdFACULTY = "MyDomain:STANDARDWOFFPACK_FACULTY" $AccountSkuIdSTUDENT = "MyDomain:STANDARDWOFFPACK_STUDENT" $UsageLocation = "US" $LicenseOptions = New-MsolLicenseOptions -AccountSkuId $AccountSkuId $LicenseOptionsFACULTY = New-MsolLicenseOptions -AccountSkuId $AccountSkuIdFACULTY -DisabledPlans SHAREPOINTWAC_EDU,MCOSTANDARD,SHAREPOINTSTANDARD_EDU $LicenseOptionsSTUDENT = New-MsolLicenseOptions -AccountSkuId $AccountSkuIdSTUDENT -DisabledPlans SHAREPOINTWAC_EDU,MCOSTANDARD,SHAREPOINTSTANDARD_EDU $Users | Where-Object {$_.CustomAttribute7 -like "S_*"}| ForEach-Object {Set-MsolUser -UserPrincipalName $_.UserPrincipalName -UsageLocation $UsageLocation Set-MsolUserLicense -UserPrincipalName $_.UserPrincipalName -AddLicenses $AccountSkuIdSTUDENT -LicenseOptions $LicenseOptionsSTUDENT }

when using this statement only it is working fine with me

Get-MsolUser -Maxresults 200000 -DomainName education.qa –UnlicensedUsersOnly | Select UserPrincipalName

but when binding it with | Where-Object {$_.CustomAttribute7 -like "S_*"} as below it does not getting any result and if i changed the $_.CustomAttribute7 -like "S_*" to $_.CustomAttribute7 -like "*" it works but getting all results

$Users | Where-Object {$_.CustomAttribute7 -like "S_*"}| ForEach-Object {Set-MsolUser -UserPrincipalName $_.UserPrincipalName -UsageLocation $UsageLocation
Set-MsolUserLicense -UserPrincipalName $_.UserPrincipalName -AddLicenses $AccountSkuIdSTUDENT  -LicenseOptions $LicenseOptionsSTUDENT }

can anyone help me please to get this script working

convertFrom-Json is not recognized as the name of a cmdlet

ericwood — Mon, 22 Apr 2013 19:28:18 GMT

I'm trying to use the convertfrom-json cmdlet and when I attempt to use it on windows 7 in powershell, i get that it is not recognized. I have read:

The Microsoft.PowerShell.Utility module is installed with Windows PowerShell.

It does not appear to be a module that get imported. Why can't I access this if I running powershell 2.0 on windows 7?

Thanks, Eric

Learning PS - this is what I want to do and below that is what I have- any suggestions

gasmann — Mon, 29 Apr 2013 02:06:40 GMT

1. List the last 50 entries in the System log using Get-WinEvent
2. Output 2 blank lines
3. List the last 50 entries in the Application log using Get-EventLog, sorting by Index
4. Output 2 blank lines

Using pipes, list the entries in the Application log using Get-EventLog that were written/generated in the last 30 days, sorting by Index

get-WinEvent -log system -maxevents 50
Write-host
Write-host
get-Eventlog -log application -newest 50 | sort-object -property index
Write-host
Write-host
$ara = @(get-eventlog -log application -newest 50)
foreach ( $element in $ara )
{
$val = $element.index.ToString()

Write-Host $val
}

getElementsByClassName???

TBlackbird — Fri, 03 May 2013 19:26:13 GMT

This is the strangest problem I've ever encountered. The following is the code in question:

$ie = New-Object -ComObject InternetExplorer.Application

$ie.Visible = $true

$ie.Navigate("www.google.com")

$ie.Document.body.getElementsByClassName("test")

Windows 7 32-bit fully patched, Powershell 3.0, IE 10 -- Doesn't work...gives:

Method invocation failed because [mshtml.HTMLBodyClass] doesn't contain a method named 'getElementsByClassName'.

Windows 7 64-bit fully patched, Powershell 3.0, IE 10 -- Does work

Any Ideas?

Need a PowerShell Consultant

captmark — Fri, 03 May 2013 14:37:28 GMT

We are working on a special HP infrastructure project and are in need of a great PowerShell developer for 6-8 weeks.

Custom Type for GetType().Name

ElBarbado — Thu, 02 May 2013 20:39:35 GMT

I have a bunch of functions in which I create PSObjects and add members to them with the add-member cmdlet. What I want to do is provide a custom name for the objects that I create. I tried overriding the GetType() function of the object but I really want to override properties and methods of what is returned from GetType() so that I can execute $myObject.GetType().Name and it returns the name that I assigned to my custom object. Is there an existing pattern out there to do this type of thin? I can't imagine that I'm the first one to desire this functionality yet I'm having no luck finding anything on this.

Thanks