-
Posts
6,514 -
Joined
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by kennysarmy
-
3rd Gen Apple TV's failing to install latest update
kennysarmy replied to kennysarmy's topic in Hardware
Hi, From https://ipsw.me/AppleTV3,1 none of them seem to relate to the version that the ATV reports to be on, which is 7.3 (8065) Very confusing. -
3rd Gen Apple TV's failing to install latest update
kennysarmy replied to kennysarmy's topic in Hardware
It gets to : Step 1 of 2: Preparing Update... Then jumps to; "The update was not successful" -
We have nearly 50 3rd Gen (A1469) models installed in classrooms, they are on either software release 7.2 or 7.3, they are ALL failing to install the latest update which I believe is 7.3.1 Has anyone got any 3rd Gen Apple TV's that they have been able to upgrade to the latest version successfully?
-
Photos!
-
We're not long in to our Office 365 Hybrid Setup. I'm getting about two emails a day with the subject line : Request to Reset Microsoft Online Services Password for Their password is their AD password and even if I reset it how would I pass this information on to the student? How do others handle student request for passwords to be reset when they are away from school? Cheers
-
[sims] Script to add student email addresses in to SIMS.net
kennysarmy replied to kennysarmy's topic in MIS Systems
Gave up waiting for Capita, so edited all 220 accounts manually ( between three of us it took 30 minutes!) -
[sims] Script to add student email addresses in to SIMS.net
kennysarmy replied to kennysarmy's topic in MIS Systems
Does anyone have access to any instructions for Patch 23212 they could send over in case there is something different to the instructions I'm following for 20343... -
[sims] Script to add student email addresses in to SIMS.net
kennysarmy replied to kennysarmy's topic in MIS Systems
You're right, I've been sent the new patch (with no instructions) so I've used the ones I've used previously which are here: https://faq.scomis.org/wp-content/uploads/2017/12/BulkImport.pdf It's now attempting to update the email addresses but fails with the following: Your database has been restored correctly and can be used normally. The error reported was Bulk load: An unexpected end of file was encountered in the data file. The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error. Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". The SQL Batch which caused the error was : ----------------------------------------------------------------------------------------- -- Main entry point set nocount on declare @Match_list table(person_id int) declare @imported bit, @upn_ni_tt varchar(200), @email_phone varchar(200), @student_import_E bit, @Staff_import_E bit, @stud_contact_import_E bit, @Staff_contact_import_E bit, @student_import_P bit, @Staff_import_P bit, @stud_contact_import_P bit, @Staff_contact_import_P bit, @maxDATE smalldatetime, @main varchar(200), @primary varchar(100), @location varchar(100), @person_type varchar(100), @surname varchar(200), @forename varchar(200), @midname varchar(200), @notes varchar(6000), @N int, @person_id int, @student_id int, @Matches int, @email_id int, @telephone_id int, @email_location varchar(100), @email_main varchar(100), @email_primary varchar(100), @email_notes varchar(2000), @phone_location varchar(100), @phone_main varchar(100), @phone_primary varchar(100), @phone_notes varchar(6000), @unchanged_emails int, @unchanged_phones int, @Staff_id int, @MASK varchar(3000), @msg varchar(4000), @Original_email_phone varchar(100), @REPlace_email bit, @REPlace_phone bit, @prev_max_phone_id int, @prev_max_email_id int, @use_for_fees_docs varchar(100), -- what the CSV asks for @use_for_fees_documents bit, -- what any existing email record has @MAIN_PHONE_PER_LOCATION bit -- To allow the utility to handle this situation incorrectly the same way that SIMS does (until SIMS -- is fixed). select @Staff_import_E = 0, @student_import_E = 0, @stud_contact_import_E = 0, @Staff_contact_import_E = 0, @student_import_P = 0, @Staff_import_P = 0, @stud_contact_import_P = 0, @Staff_contact_import_P = 0, @maxDATE = '20790606', @unchanged_emails = 0, -- number of records that were not imported because they exactly match existing data @unchanged_phones = 0 select @prev_max_email_id = max(email_id) from sims.sims_email select @prev_max_phone_id = max(telephone_id) from sims.sims_telephone if exists(select 1 from sims.db_update_log where description = '') begin set @MAIN_PHONE_PER_LOCATION = 1 end else begin set @MAIN_PHONE_PER_LOCATION = 0 end delete sims.tmp_email_phone_import delete sims.tmp_email_phone_import_log set @imported = 0 if (sims.conv_fnb_file_exists('D:\CSV_IMPORT\', 'EMAIL_PHONE.CSV') = 1) begin BULK INSERT sims.tmp_email_phone_import FROM 'D:\CSV_IMPORT\EMAIL_PHONE.CSV' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' , FIRSTROW = 1) set @imported = 1 end else if (sims.conv_fnb_file_exists('C:\CSV_IMPORT\', 'EMAIL_PHONE.CSV') = 1) begin BULK INSERT sims.tmp_email_phone_import FROM 'C:\CSV_IMPORT\EMAIL_PHONE.CSV' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' , FIRSTROW = 1) set @imported = 1 end else if (sims.conv_fnb_file_exists('S:\CSV_IMPORT\', 'EMAIL_PHONE.CSV') = 1) begin BULK INSERT sims.tmp_email_phone_import FROM 'S:\CSV_IMPORT\EMAIL_PHONE.CSV' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' , FIRSTROW = 1) set @imported = 1 end else if (sims.conv_fnb_file_exists('U:\CSV_IMPORT\', 'EMAIL_PHONE.CSV') = 1) begin BULK INSERT sims.tmp_email_phone_import FROM 'U:\CSV_IMPORT\EMAIL_PHONE.CSV' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' , FIRSTROW = 1) set @imported = 1 end -
[sims] Script to add student email addresses in to SIMS.net
kennysarmy replied to kennysarmy's topic in MIS Systems
Having issues with this, trying to bulk update all our new intake which are now on SIMS. Is this suggesting there is a replacement patch for my database? -
Script to report folders in C:\users and store results centrally?
kennysarmy replied to kennysarmy's topic in Windows 10
Sorted. I saved the file locally and then used this line: Copy-Item -Path D:\folder\test.txt -Destination \\server1\remoteshare\ and made sure the share had write permissions for Authenticated Users and Domain Computers on both the share and the folder. Might look at changing the script now so it counts the number of folders in C:\users as well! -
Script to report folders in C:\users and store results centrally?
kennysarmy replied to kennysarmy's topic in Windows 10
If I create the file locally it works, so in C:\Windows So is it possible using a powershell startup script to have access to domain resources? -
Script to report folders in C:\users and store results centrally?
kennysarmy replied to kennysarmy's topic in Windows 10
I need ideally it to run without having to logon so I've got it running as a startup script. I've set the NTFS permissions on the folder I need the file to be created in to include "Domain Computers" : Full Control. -
Script to report folders in C:\users and store results centrally?
kennysarmy replied to kennysarmy's topic in Windows 10
I've got the script running... but it can't write the results back Error Message = Access to the path '\\fp4\d$\Server_Apps\Utilities\pcaudit\uc\TEMP00-2019-08.txt' is denied. Fully Qualified Error ID = FileOpenFailure,Microsoft.PowerShell.Commands.OutFileCommand I've added "Domain Computers to the folder "\\fp4\d$\Server_Apps\Utilities\pcaudit\uc" with full control... -
Script to report folders in C:\users and store results centrally?
kennysarmy replied to kennysarmy's topic in Windows 10
This powershell script might work! Get-ChildItem -Path C:\users | Out-File \\dc01\netlogon\uc\$env:computername.txt But got to work out how to run the script at startup! -
Has anyone come across a script which can be run at startup which would report the contents of C:\users and save the results centrally? I've changed the location of my redirected desktops this summer and want to ensure the script I've run at startup has actually worked and cleaned out all the local profiles, it appears on some machines it's not worked
-
PM me.
-
Still on LTSB 1607 - no reasons yet to move - probably do some 2019 testing this academic year.
-
I have a redirected desktop group policy, it's been edited because I've changed the location of the centrally held desktops. The policy is working but any staff or students who have previously logged on to a PC are seemingly getting "cached" details which point them to a desktop location that no longer exists. If we delete the local profile then of course everything is fine. No amount of client rebooting or GPUPDATE /Force is fixing the problem. Any ideas before I have to go round all 850 clients and remove local profiles?
-
Error when adding new virtual center into Veeam
kennysarmy replied to kennysarmy's topic in Enterprise Software
In case it helps anyone else: Thank you for your time on the phone call and on the remote session. A brief recap for our session: 1) We were able to confirm, that connect was failing as it was going through the proxy - and as the services are running under local system account - and proxy exclusions are not applied to it. We've changed the service logon account to domain admin - and we were able to add the server just fine. 2) Permissions that are needed to service logon accounts: https://helpcenter.veeam.com/docs/backup/vsphere/required_permissions.html?ver=95u4 "The account used to run the Veeam Backup Service must be a LocalSystem account or must have the local Administrator permissions on the backup server." - so if the domain admin is in the local administrator group on Veeam server, it's fine to use it. 3) PsExec Microsoft tool - could be used to launch application from the particular user. In our case if you want to switch back service to logon with local system account, it is needed to disable proxy for it - so basically it's needed to start internet connection wizard (inetcpl.cpl) from local system account with this tool: https://docs.microsoft.com/en-us/sysinternals/downloads/psexec - Please let us know if you will have any additional questions or if we should go ahead and close this case. -
We have upgraded Virtual center to 6.7 U2c build number 14070654. Veeam server is running version 9.5.4.2866. When trying to add the new virtual center into Veeam we get the below error message. Anyone any ideas?
-
Upgrading the majority of our servers to 2019 in the summer but leaving SIMS on 2012 R2 until it's officially supported. Or maybe in the meantime we might even move to another MIS system (please!)
-
Managing IT jobs list over summer holidays
kennysarmy replied to DrBeaker's topic in How do you do....it?
Same here. -
Office 365 Emails for staff who get married and change name?
kennysarmy replied to kennysarmy's topic in Cloud Services
Just to add in further testing we found we had to do these two operations the other way around: Instead of: - Wait for AD Sync to take effect for user changes to be updated to Office 365 (could take up 30 minutes) OR run start-adsyncsynccycle -policytype delta - Connect to Office 365 via Powershell - Run the Set-MsolUserPrincipalName command to update the user's "username". We had to do: - Connect to Office 365 via Powershell - Run the Set-MsolUserPrincipalName command to update the user's "username". - Wait for AD Sync to take effect for user changes to be updated to Office 365 (could take up 30 minutes) OR run start-adsyncsynccycle -policytype delta
