2014/09/04

PowerShell - WMF 5.0 July preview uninstallation fails


Today the PowerShell Team released a new version of the WMF : v5 September preview, I really like the faster beta cycle !

Having the beta preview already installed (July version), I first open Add/Remove Programs (appwiz.cpl) and start to uninstall this version (KB2969050).

Once the uninstallation is completed, Windows ask to reboot. However at the next boot I get a message saying the Update did not work and Windows is Undoing the change, reverting to the previous state...then reboot again.


2014/09/01

PowerShell - Sum similar entries from multiple CSV files

One of my script is scheduled to download everyday the proxy logs files from multiple proxies (Approx 1>2GB per file) of the previous day. The second step is to parse each of them and get the top 200 domain names within a specific environment. Finally at the end of the month another script create a report on the monthly internet usage.

I thought this was an interesting exercise even if some tools would probably do a better job ($$$). Also we shouldn't take those results too seriously since some protocols like Ajax or HTML5 talk a lot to the servers, keep refreshing pages even if you are not actively working on them.

In this post, I will talk about the last part of this process and how I combine all those files to get a real monthly top domains.


2014/08/24

PowerShell/SCSM - Retrieving Active Directory Object Classes


Following my previous post, today I continue my SCSM journey. I had to create a new automation workflow using SCSM and SCORCH to give the ability to a portal user to add an Active Directory Account to one or more group(s).

Once you get the input of the user, the selected user account and groups impacted by the request are added to the Service Request Related Item, in the Configuration Item field.

Finding this information with PowerShell was not easy. Also Users and Groups are tagged as "User Class" and we want to avoid querying the Active Directory to verify is a user is really a user and a group... really a group object.

2014/08/23

PowerShell/SCSM - My first steps

I recently started to work with System Center Service Manager 2012 R2 (also known as SCSM) which provides provides an integrated platform for automating and adapting an organization's IT service management best practices, such as those found in Microsoft Operations Framework (MOF) and Information Technology Infrastructure Library (ITIL). It provides built-in processes for incident and problem resolution, change control, and asset lifecycle management.

2014/08/17

PowerShell - Parse this: NetStat.exe

In the last couple of months I had to parse different types of output using PowerShell and I thought it would be a cool idea to explain how this can be done. Command line tool: Netstat.exe

This small tool allows you to display active TCP connections, ports on which the computer is listening, Ethernet statistics, the IP routing table, IPv4 and IPv6 statistics.

In this example I will use the parameter '-n' which displays active TCP connections (without name resolution).


2014/08/12

PowerShell Summit 2014 Europe (English)


French version

The European PowerShell Summit, organised by PowerShell.org guys, will be in Amsterdam from the September 29th to the October 1st 2014 at the Park Hotel. Details at http://powershell.org/wp/community-events/summit/

The Summit will feature 3 days of PowerShell sessions from PowerShell team members, PowerShell MVPs and other PowerShell experts. It’s the in-person gathering place for PowerShell enthusiasts and PowerShell users. It’s a place to make new connections, learn new techniques, and offer something to your peers and colleagues.  If you can't get your PowerShell questions answered at the PowerShell Summit you'll never get an answer.

PowerShell Summit 2014 Europe (Français/French)


English version.

La conférence PowerShell Summit Europe organisera sa première édition du 29 septembre au 1er octobre 2014.
Trois jours de sessions PowerShell par les membres de l'équipe PowerShell, MVPs et d'autres experts PowerShell.

C'est le lieu de rassemblement pour des tous enthousiastes et utilisateurs PowerShell ; l'endroit pour faire de nouvelles connexions, apprendre de nouvelles techniques et offrir quelque chose à vos pairs et collègues.

Pour avoir participé aux deux premières Éditions Nord Amérique en avril 2013 et avril 2014 à Seattle, si vous voulez développer vos connaissances et découvrir comment d'autres professionnel TI utilisent PowerShell dans leur environement... c'est la conférence de prédilection auxquel vous devez assister!!!!

2014/07/01

PowerShell - Handy function to connect to Office365 services


I just started to play with a Microsoft Office 365 environment (Azure Active Directory, Lync Online and Exchange Online) and I thought I would make it through PowerShell obviously :-)

But when you start your PowerShell console... you need to load modules, connect to each services, enter your credentials...yada yada yada...

With Office 365 you can administer the following services using PowerShell:
  • Azure Active Directory
  • Exchange Online PowerShell
  • SharePoint Online PowerShell
  • Lync Online PowerShell