MikeW

This article outlines what needs to be done after a new certificate has been installed.

We are seeking to appoint a suitably skilled IT Network Technician to support the Network Manager to provide an effective and efficient IT service for our pupils and staff. We are looking for a candidate with previous experience in a similar role and: A working knowledge of Microsoft 365, Windows 10/Server 2019, VMware, IP networking, computer hardware and website management. Experience of working on a helpdesk with the ability to prioritise jobs and respond in a timely manner. Relevant and up to date experience of supporting large ICT networks. Strong interpersonal skills with a friendly outgoing manner. The ability to work well under pressure and meet deadlines. Excellent verbal and written communication skills. This is an exciting opportunity for the right candidate to become involved with several large IT projects due to be launching in the next 12 months. To download an application pack please visit our website : www.stmcollege.org.uk/about-us/vacancies or for more information on the role contact the college ([email protected] or 0161 336 2743)

St Thomas More RC College is seeking to appoint a suitably skilled IT Technician to support the Network Manager in providing an effective and efficient IT service for our pupils and staff. Link to full advert here

I've used Sims Bulk Import written by @matt40k to perform similar jobs in the past. https://simsbulkimport.uk/

We did our first parents evening last night using the School Cloud system, thankfully no issues at our end. A couple of parents reporting issues logging in and joining their appointments, but overall happy with the way it went. I've sent a survey out to parents to gather their thoughts.

I wasted the best part of an hour this morning on the phone to 'Community Brands' support trying to get through with similar issues on Groupcall Messenger (not for the first time either). What was once excellent support provided by Groupcall for their products is now in the hands of www.communitybrands.com and is non-existent. I will be looking elsewhere when contract renewal time comes around.

Here's mine if its any use - archives previous backups and compresses them # Set Variables $server = 'SERVER\INSTANCE' $user = 'user' $password = 'password' $date = (Get-Date).ToString("d-M-yyyy").Replace(",","-") # Clear Archive Folders Of Files Older Than 7 Days Get-ChildItem –Path “Z:\Archive\Databases\SIMS” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-Item Get-ChildItem –Path “Z:\Archive\Databases\FMS” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-Item Get-ChildItem –Path “Z:\Archive\Databases\Discover” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-Item Get-ChildItem –Path “Z:\Archive\Databases\SOLUS” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-Item Get-ChildItem –Path “Z:\Archive\Folders” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-Item # Move Last Backup To The Relevant Archive folder Move-Item "Z:\Current\Databases\SIMS*" "Z:\Archive\Databases\SIMS\" Move-Item "Z:\Current\Databases\FMS*" "Z:\Archive\Databases\FMS\" Move-Item "Z:\Current\Databases\Discover*" "Z:\Archive\Databases\Discover\" Move-Item "Z:\Current\Databases\SOLUS*" "Z:\Archive\Databases\SOLUS\" Move-Item "Z:\Current\Folders\*.zip" "Z:\Archive\Folders\" # Shrink Databases To Keep The File Size Low Set-Location -Path 'F:\Apps\SIMS\Setups\ShrinkDBLog' .\ShrinkDBLog.bat $server SIMS .\ShrinkDBLog.bat $server FMS .\ShrinkDBLog.bat $server Discover .\ShrinkDBLog.bat $server solus3_deployment_server # Transfer Users From Master Database OSQL -S"$server" -U $user -P $password -Q"exec sims.sims.db_p_transfer_login" OSQL -S"$server" -U $user -P $password -Q"exec fms.sims.db_p_transfer_login" # Backup The Sims Database Into The 'Current' Folder Set-Location -Path 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL\MSSQL\Binn' .\DbAttach.exe /server=$server /database=SIMS /user="$user" /password="$password" /backup /auto /path="Z:\Current\Databases\SIMS-$date.bak" # Backup The Discover Database Into The Current Folder .\Discover.Backup.Console.exe /operation=backup /database=Discover /username="$user" /password="$password" /server=$server /backupfilename=Z:\Current\Databases\Discover-$date.dbk # Backup The FMS Database Into the 'Current' Folder Set-Location -Path 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL\MSSQL\Binn\FMS'.\DbAttach.exe /server=$server /database=FMS /user="$user" /password="$password" /backup /auto /path="Z:\Current\Databases\FMS-$date.bak" # Backup The SOLUS Database Into the 'Current' Folder Set-Location -Path 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL\MSSQL\Binn'.\DbAttach.exe /server=$server /database=solus3_deployment_server /user="$user" /password="$password" /backup /auto /path="Z:\Current\Databases\SOLUS-$date.bak" #Wait For 15 Minutes Whilst Database Backups Completes Start-Sleep -s 900 # Zip Files To Save Space And Then Delete Originals Set-Location -Path C:\Windows\System32 $files = Get-Item "Z:\Current\Databases\*.bak" | Foreach-Object {$_ -replace ".bak", ""} foreach ($file in $files) { .\7za a -tzip $file'.zip' $file'.bak' } Remove-Item "Z:\Current\Databases\*.bak" # Zip SIMS And DOCSTORAGE Folders .\7za.exe a -tzip Z:\Current\Folders\DOCSTORAGE-$date.zip F:\DOCSTORAGE .\7za.exe a -tzip Z:\Current\Folders\SIMSFILES-$date.zip F:\Apps\SIMS -mx0 -xr!Solus3 -xr!Setups

I've used the SalamanderSoft SDS utility this morning and it works well, it's saved me many hours of swearing at SIMS reports and spreadsheets

From Wed 15th March it will be possible to request your O365 data to be stored in the UK : https://technet.microsoft.com/en-us/library/dn879433.aspx

Here's ours if its any use - it keeps 7 days backups in an archive folder# Set Variables$server = 'SERVER\SQL'$user = 'sa'$password = 'PASSWORD'$date = (Get-Date).ToString("d-M-yyyy").Replace(",","-")# Clear Archive Folders Of Files Older Than 7 DaysGet-ChildItem –Path “Z:\Archive\Databases\SIMS” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-ItemGet-ChildItem –Path “Z:\Archive\Databases\FMS” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-ItemGet-ChildItem –Path “Z:\Archive\Databases\Discover” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-ItemGet-ChildItem –Path “Z:\Archive\Databases\SOLUS” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-ItemGet-ChildItem –Path “Z:\Archive\Folders” –Recurse | Where-Object{$_.CreationTime –lt (Get-Date).AddDays(-7)} | Remove-Item# Move Last Backup To The Relevant Archive folderMove-Item "Z:\Current\Databases\SIMS*" "Z:\Archive\Databases\SIMS"Move-Item "Z:\Current\Databases\FMS*" "Z:\Archive\Databases\FMS"Move-Item "Z:\Current\Databases\Discover*" "Z:\Archive\Databases\Discover"Move-Item "Z:\Current\Databases\SOLUS*" "Z:\Archive\Databases\SOLUS"Move-Item "Z:\Current\Folders\*.zip" "Z:\Archive\Folders"# Shrink Databases To Keep The File Size LowSet-Location -Path 'F:\Apps\SIMS\Setups\ShrinkDBLog'.\ShrinkDBLog.bat $server SIMS.\ShrinkDBLog.bat $server FMSSTM.\ShrinkDBLog.bat $server Discover.\ShrinkDBLog.bat $server solus3_deployment_server# Transfer Users From Master DatabaseOSQL -S"$server" -U $user -P $password -Q"exec sims.sims.db_p_transfer_login"OSQL -S"$server" -U $user -P $password -Q"exec fmsstm.sims.db_p_transfer_login"# Backup The Sims Database Into The 'Current' FolderSet-Location -Path 'C:\Program Files\Microsoft SQL Server\MSSQL11\MSSQL\Binn'.\DbAttach.exe /server=$server /database=SIMS /user="$user" /password="$password" /backup /auto /path="Z:\Current\Databases\SIMS-$date.bak"# Backup The Discover Database Into The Current Folder.\Discover.Backup.Console.exe /operation=backup /database=Discover /username="$user" /password="$password" /server=$server /backupfilename=Z:\Current\Databases\Discover-$date.dbk# Backup The FMS Database Into the 'Current' FolderSet-Location -Path 'C:\Program Files\Microsoft SQL Server\MSSQL11\MSSQL\Binn\FMSSQL'.\DbAttach.exe /server=$server /database=FMSSTM /user="$user" /password="$password" /backup /auto /path="Z:\Current\Databases\FMS-$date.bak"# Backup The SOLUS Database Into the 'Current' FolderSet-Location -Path 'C:\Program Files\Microsoft SQL Server\MSSQL11\MSSQL\Binn'.\DbAttach.exe /server=$server /database=solus3_deployment_server /user="$user" /password="$password" /backup /auto /path="Z:\Current\Databases\SOLUS-$date.bak"#Wait For 15 Minutes Whilst Database Backups CompletesStart-Sleep -s 900# Zip Files To Save Space And Then Delete OriginalsSet-Location -Path C:\Windows\System32$files = Get-Item "Z:\Current\Databases\*.bak" | Foreach-Object {$_ -replace ".bak", ""}foreach ($file in $files) { .\7za a -tzip $file'.zip' $file'.bak' }Remove-Item "Z:\Current\Databases\*.bak"# Zip SIMS And DOCSTORAGE Folders.\7za.exe a -tzip Z:\Current\Folders\DOCSTORAGE-$date.zip F:\DOCSTORAGE.\7za.exe a -tzip Z:\Current\Folders\SIMSFILES-$date.zip F:\Apps\SIMS -mx0 -xr!Solus3 -xr!Setups

Have you added apollo.codio.com to your SSL Bypass list ?

Our PE dept has asked for a setup in the sports hall which will enable them to do performance analysis with pupils using their ipads, a large monitor and an apple tv box (or airserver whichever is more suitable), I obviously have concerns regarding damage, mobility and storage. Has anyone implemented a similar system and how did you do it ?TIA

Struggling with a similar issue - trying to create a report showing all students in specific reg groups with 100% attendance over the previous 4 weeks and then schedule it for individual form tutors. Can't see a method of exporting the 'inbuilt' Percentage Attendance report to enable me to edit it, reimport and then use with the SIMS scheduler.

I'm setting up scheduled reports in SIMS.net and want to run reports which will show behaviour incidents for the previous week/month. I can't find any mechanism within the SIMS reporting tool to do this. All I can specify is a range of dates which would have to be changed everytime the report was run - defeating the object of report scheduling. Am I missing someting obvious ? TIA

See this thread on RM Communities

Got my email on Saturday, only issue the new LanView client is an .exe not an .msi .

Web based access over https would be good though (a la RM Management Stuff)

I use the TVersity Media Server on my XP machine to stream .avi 's to my xbox - works well

29th Dec

No major problems this year so far , however last year was a nightmare. Just had 2 people in from Leeds Uni working for QCA observing the practice/pre tests and interviewing the kids afterwards.

You just need to set/change a password for root - have a look at http://www.netadmintools.com/art90.html

I spoke to the cabling contactor today to arrange a visit for a quotation, my main concern at the moment is that the teacher who's due to move in there wants to use modular pods/desks rather than benching, these are expensive in themselves and from what I can gather will also involve extra costs running power and data to each seperate pod (7 in total). The existing core switch has enough spare capacity to cope. Yes I've factored warranties and 2 WAP's into the costings. We just could not afford air-conditioning at present - some blinds and UV screening on the windows will have to do at present - both our other suites do have AC fitted, but as has been mentioned in another post I've had a battle with finance (and lost !!)

Hi All, I've been asked to cost a new IT suite consisting of 31 PC's (including licenses), Interactive Whiteboard, Projector, rewiring data and power points and new chairs/desks etc. Are there any other costs that I may be missing ? Thanks. MikeW

20 bottles of Stella (Head of ICT) 1 bottle red wine (Dep Head) and some cards javascript:emoticon('post', 'message', '') Yeah !!