Painlessly Get Data from PowerShell to Excel
Doug Finke has written an awesome article - complete with a module! - to help get data into Excel spreadsheets.
Doug Finke has written an awesome article - complete with a module! - to help get data into Excel spreadsheets.
When Microsoft first released the DSC Resource Kit (in Wave 10 as of this writing), they opened the door to community contributions. Our own PowerShell.org GitHub repo consists partly of DSC resource that used Microsoft’s code as a baseline, and then corrected problems or expanded capabilities.
What we never had was a way for Microsoft to circle back, pick up those enhancements, and include them as part of an official future Resource Kit Wave. Now, we do.
The NJ PowerShell User Group is having a meetup on Tuesday, April 28th from 6:00 - 8:00 PM. The first half hour will be for socializing, pizza, and playing pool at our coffee bar. Agenda: 6:00 – 6:30: Pizza and socializing 6:30 – 7:30: Presentation 7:30 - 8:00: Q & A Please note that the Webex meeting will start at 6:00 PM, but the actual presentation won’t start until 6:30. In-Person a ttendees must register, print out their EventBrite ticket, and present it at the door.
Every IT pro needs a lab. It’s not just the fact that we all have a little mad scientist in us, it’s a playground for experimentation and learning. By “lab” I do not mean a formal test or dev environment, but a much more informal setting that typically goes before the “dev” part gets started. This lab need not be expensive. A little creative repurposing and virtualization will go a long way towards getting started with a home lab.
Updated : October 01, 2015 ** Question **: What is the fastest solution to count all the users in Active Directory domain? ** Answer **: To answer this question, I will compare 17 different commands in a domain with 75 000 users. `[System.GC]::WaitForPendingFinalizers() [System.GC]::Collect() Set-Location -Path ‘C:\demo’ Add-Type -AssemblyName System.DirectoryServices.Protocols Import-Module -Name .\S.DS.P.psd1 Add-PSSnapin -Name ‘Quest.ActiveRoles.ADManagement’ $searcher = [adsisearcher]’(&(objectclass=user)(objectcategory=person))' $searcher.SearchRoot = ‘LDAP://DC=domain,DC=com’ $searcher.PageSize = 1000 $searcher.PropertiesToLoad.AddRange((‘samaccountname’)) function Get-QueryResult { [CmdletBinding()] Param ( [Parameter(Mandatory=$true)] [int]$Id ) switch ($id) { 1 { ( Get-ADUser -Filter ‘objectClass -eq “user” -and objectCategory -eq “person”’ -SearchBase ‘DC=domain,DC=com’ -Properties SamAccountName).
The NJ PowerShell User Group is having a meetup on Thursday, March 6th from 6:00 - 8:00 PM. The first half hour will be for socializing, pizza, and playing pool at our coffee bar. Registration: EventBrite You must register to attend in person. Agenda: 6:00 – 6:30: Pizza and socializing 6:30 – 7:30: Presentation 7:30 - 8:00: Q & A Please note that the Webex meeting will start at 6:00 PM, but the actual presentation won’t start until 6:30
The NJ PowerShell User Group is having a meetup on Thursday, January 8th from 6:00 - 8:00 PM. If interested, please register through the Eventbrite website to track attendance for ordering pizza. For those attending online (Webex) we will send a follow-up email with the meeting link based on Eventbrite online registrants. Agenda: 6:00 – 6:30: Pizza and socializing 6:30 – 7:30: Presentation 7:30 - 8:00: Q & A Please note that the Webex meeting will start at 6:00 PM, but the actual presentation won't start until 6:30 In-Person attendees must register, print out their EventBrite ticket, and present it at the door.
At the 2nd of October, Lee Holmes gave a presentation about the current and future state of the Windows Management Framework (WMF) during the Dutch PowerShell User Group (DuPSUG) at the Microsoft headquarters in The Netherlands. The slide decks and recorded videos will be made available soon, but this is what was discussed: The release cycle of the Windows Management Framework (WMF) Faster incremental releases of preview versions are being released.
Aside from classes and new DSC features, which I’ve already written about, there are a number of less-headline, but still-very-awesome, new capabilities. This article is based on the September 2014 preview release of WMF 5.0. Information is highly subject to change. First up is the **ability to automatically create PowerShell cmdlets from an OData endpoint. **Huh? OData is a kind of web service (basically); PowerShell gains the ability to look at the endpoint and construct a set of proxy cmdlets that let you interact with the endpoint more naturally.
When Desired State Configuration (DSC) came out - gosh, just about a year ago - I kept telling people that there was more to come. And a lot of it is now just around the corner in PowerShell v5. This article is written to the September 2014 preview release - things may change for the final release. A major set of changes in DSC is a much more detailed and granular configuration of the Local Configuration Manager (LCM), the local “agent” that makes DSC work on the target node.
Try adjusting your search terms or browse all content.