andy_b

"We are aware of an issue with internet access at a number of schools. This is due to a power outage at one of the core data centres. The power company is onsite working to restore power. Once power is restored, services will resume and we apologise for the inconvenience."

Oh, and the internet that we have today is slow...... Even with only 52% utilization.

A December summary: 02/12 - No Internet 03/12 - No Internet 04/12 - Internet for about 4 hrs only 05/12 - Internet for about 8 hrs only 06/12 - No Internet until mid afternoon 10/12 - No Internet 11/12 - No Internet 12/12 - No Internet 13/12 - Internet back mid-day ish 15/12 - Slow internet, certificate errors, transparent proxy stopped working mid-day !!!!!!!!!!

=IF(LEFT(IF(A2="T","FM","")&IF(B2="T","-SE","")&IF(C2="T","-GT",""),1)="-",RIGHT(IF(A2="T","FM","")&IF(B2="T","-SE","")&IF(C2="T","-GT",""),LEN(IF(A2="T","FM","")&IF(B2="T","-SE","")&IF(C2="T","-GT",""))-1),IF(A2="T","FM","")&IF(B2="T","-SE","")&IF(C2="T","-GT","")) Simples (Although 7 possible options would make it rather long )

Quick thoughts were to concatenate some IF statements together: =IF(A2="T","FM","")&IF(B2="T","-SE","")&IF(C2="T","-GT","") ? Maybe a bit simple but seemed to work.

Yup its down: ... reason = DEL_REASON_PEER_NOT_RESPONDING Went down on 31/10 too: ... reason = PEER_DELETE-IKE_DELETE_NO_ERROR

One solution we have used to get around the right mouse / wheel mouse problem is to create an autohotkey script that either remaps the clicks or just does nothing - effectively disabling them. The teacher just runs the exe when they want to disable the wheel.

We use https://www.xnview.com/en/nconvert/ in a scheduled batch file.

In the past I've sent unique files to multiple users using Send-It-Quiet Command Line sendmail tool to send the emails and constructed the necessary commands in an excel spreadsheet and then just pasted it into the command line. Don't know if that is any help.

Link2ICT use McAfee Web Gateway. I'm sure it happened ages ago too. Raised a call to get them to unblock.

Seems edugeek is blocked this morning as: Technical/Business forums

We find this helps keep the monster under control: https://community.spiceworks.com/scripts/show/2998-adamj-clean-wsus

Bear in mind when using Net2 Software to open doors in a fire alarm condition: As per: https://www.paxtonaccess.ae/docs/Application%20Notes/AN1031-AE.pdf

Anybody have any luck with this? Don't think Konica really understood the problem on the phone and the engineer that came out didn't seem to understand what I was saying. Managed to convince him to update the firmware, but this didn't help. He was basically saying it was a network problem. So in the end I just setup FTP.

Process Monitor ? https://docs.microsoft.com/en-us/sysinternals/downloads/procmon

We use this to script our Veeam Free backups: https://www.veeam.com/blog/veeam-backup-free-edition-now-with-powershell.html Found that the retention settings didn't really suit us, so just set to keep all and scripted deletion of old files purely using powershell.

Hard to tell best way to do it without seeing spreadsheet, but attached spreadsheet is one way. demo.xlsx

On the Right hand side of the "Select pupils for CTF output" there is a remove button. This will remove any highlighted pupils from the list. Select the year group, highlight the last thirty and remove them, then Validate etc as normal. Then repeat but this time removing the first 200.

bah missed that one

Certificate for *.misportal.net has expired... https://link2ict.service-now.com/selfservice/kb_view_customer.do?sysparm_article=KB0013544

I tried it, just got "Unable to start", was on Windows 7 though:

For when you have all the monies: https://www.lightspeed-tek.com/products/redcat-access/

I have attached a quick demo - it relies on INDIRECT() and named ranges, but I suspect it could get out of hand pretty quickly..Countifs.xlsx

Ctrl f5 seemed to work for IE - but Chrome seemed to need a Browsing data clear. Don't know if its relevant - but this caused us issues for 15.4 (ePortal and Internet explorer Compatibility Mode) https://customers.advancedcomputersoftware.com/kA4240000000fjx?srPos=0&srKp=ka4&lang=en_US

I did say over the phone to Advanced that I felt the notes - especially the ePortal ones, seemed a fair bit more involved than the ones I was used to