jb2201

$csv = import-csv “path to csv.csv” Foreach ($row in $csv) { $row.reg = “new_” + $row.reg + “@school.com” } $csv | export-csv “path to new csv.csv” Should work I think, written on my mobile though so it may need some tweaking / quotes changing!

Update: sorry just noticed somebody has mentioned this already! Just for info the Activ Arena 50 pens are compatible with the ActivBoard 2’s, the boards require a firmware update but the pens work after that. https://support.prometheanworld.com/product/-activarena-/

Nice one glad you got it sorted!

Are you running it from one workstation and calling the commands on remote folders on each server? If so I would utilise powershell remoting so that the commands are running on the servers directly.

In my opinion you want an / a pair of Aruba 5400r for core switches and Aruba 2540 at the edge, you want your l3 core switch providing your routing so that you’re not bottle necking by allowing a router with a 1gb uplink to handle the routing. This is on the more pricey side but it’s a good long term solution, as the core will be a chassis switch you can pick and choose which modules you need to suit your needs.

You could look to PowerShell for this, I created a script that took a list of servers and did exactly this (plus other things like physical drive health from OMSA) then took a HTML template and filled any tags I had specified with the data, ended up being a lot more straight forward than it sounds.

Aruba (HP ProCurve) 2540 series switches are a great switch if you’re budget allows it, if you’re after something a bit cheaper though I’ve heard good things about the Ubiquiti Unifi kit as long as you don’t require layer 3 features like IP routing (although their edgeswitch series does support this).

I’m struggling to see how Exchange is the cheaper option for schools? Office 365 is free to education.

If you have the budget available I would suggest a pair of Aruba 5406zl chassis switches serving as the core with 1 x 24 port rj45 module and 3 x 8 port SFP+ modules. For cabs I would recommend running enough OM3 fibre so that each switch can have two 10gig fibre links back to the cores. Also run two cable routes for the OM3 and give each switch one fibre from each route for resiliency. Won’t be cheap but it will be built to last!! If you wanted a cheaper option you could drop down to one core switch or just have 1 x 10 gig link to each switch then put a resilient uplink in between the switches. For edge switches in the main server room I would connect these with DAC cables rather than fibre to reduce costs.

We just wrapped the ESR exe installer in an MSI and it worked great, only gripe with Firefox in general is that it doesn’t have flash built in like the other browsers.

Was it enrolled in meraki and supervised? If so you should be able to get an activation lock bypass code out of meraki which you can enter to remove the restriction. See here: https://documentation.meraki.com/SM/Monitoring_and_Reporting/Activation_Lock_Bypass_for_iOS_Devices

As long as the gateway on your devices is set to the up of the smoothwall,transparent filtering will still work without the need for the smoothwall to be in line [emoji4]

Probably data de-duplication enabled on the server, once the garbage collection scheduled tasks run overnight it should free space up if the data isn’t duplicated elsewhere.

Are you running Hyper-V? If so I would try and get all your vm os drives on your 10k disks for better performance. I wouldn't go RAID5 personally on 7.2k disks as the performance won't be great, RAID10 all the way for those.

Are you going through a proxy server? If so make sure that the IP of your Mac server is being bypassing the proxy.