Bedders

All of this reminds me of these https://www.thinkgeek.com/product/ihvg/. I never did get around to purchasing them, but I might have to do so. I have a couple of victims in mind....

Making sure staff lock rooms when they're not in use is a good measure to prevent this. Charging the departments (assuming each of the suites are assigned to a specific department) might work. There's been another thread about this recently: http://www.edugeek.net/forums/hardware/186288-keyboards-keys-pulled-off.html

My old school purchased one a few years ago. It could make a duck by default. 10 ducks got printed over the first 6 months. As far as I know, it was never used since because no-one in D&T had the knowledge to create 3D models, and it wasn't offered in IT/Computing anywhere to be learnt by the students. Hope yours goes better

I had to read it three times to find it..

Take a picture every day of the damage, log it and the cost of the keyboards in the room at the time (say, £5-10 each?). Then take it to SLT and propose a saving of x hundreds of £££ if staff can learn to control their -ing classes. Or just don't replace the broken ones. That'll show them! EDIT to add not to take my advice too seriously, I'm tired and it's Friday.

Heaven! I used t' live darn are dirt track wi' e'en muddyer puddles.

Ouch, that looks like either a lot of nested IF's and a COUNTIF, or you could use VBA and make your own function (assuming you have security permissions to do this, and you know that you will only be distributing it amongst people who can enable macros etc.). In which case, you need to get every value from a given row and store it in an array, and then iterate through that array checking each pair of numbers before incrementing your count by 1. Something like the following VBA code in a new Module in Excel Visual Basic: Function CountGradeDrops(CellRange As Range) Dim firstNum, secondNum, count, index As Integer count = 0 index = 0 For Each cell In CellRange If index = 0 Then 'needs different logic if this is the first number being stored, as it doesn't need to compare firstNum = cell 'cell gets the value within that cell, not the reference e.g. A3 ElseIf index = 1 Then 'stores second number secondNum = cell Else firstNum = secondNum 'progress second number forward secondNum = cell End If If Not IsNull(secondNum) Then If secondNum < firstNum Then count = count + 1 'compare and count if required End If index = index + 1 'increment index Next cell CountGradeDrops = count End Function EDIT: Just to say that I know that the above code doesn't work, but I've suddenly got a lot to do (thanks colleagues) and so I posted what I had so far as a pointer. There's almost certainly a better way to do this than what I've suggested, it's just how I might look at the problem.

Assuming you only enter in a number or date to show each week (something like below), you could use the MAX function and select the range as ($2:$2). Providing you only entered a date that you actually had data for, that should pull the most recent week, and from there you can subtract 7 to get the preceding date (don't forget dates are stored as numbers - 03/07/2017 is 42919, and 26/06/2017 is 42912). [TABLE=class: grid, width: 500, align: left] [TR] [TD]week[/TD] [TD]12/06/2017[/TD] [TD]19/06/2017[/TD] [TD]26/06/2017[/TD] [TD]03/07/2017[/TD] [/TR] [TR] [TD]st(udent) 1[/TD] [TD]75%[/TD] [TD]80%[/TD] [TD]45%[/TD] [TD]69%[/TD] [/TR] [TR] [TD]st 2[/TD] [TD]54%[/TD] [TD]65%[/TD] [TD]45%[/TD] [TD]55%[/TD] [/TR] [/TABLE] All you then have to do is a HLOOKUP on each date to pull the marks, then subtract the two marks, work out what the total mark is out of 100 to get 1% (assuming it's a test with 60 marks, 60 goes in the total field), then multiply that by the subtraction of both marks. For example: [TABLE=class: grid, width: 400, align: left] [TR] [TD][/TD] [TD=align: center]A[/TD] [TD=align: center]B[/TD] [/TR] [TR] [TD]1[/TD] [TD]closest date[/TD] [TD]=max($2:$2)[/TD] [/TR] [TR] [TD]2[/TD] [TD]prev date[/TD] [TD]=CellAbove - 7[/TD] [/TR] [TR] [TD]3[/TD] [TD]st1 mark 1[/TD] [TD]hlookup closest date[/TD] [/TR] [TR] [TD]4[/TD] [TD]st1 mark 2[/TD] [TD]hlookup prev date[/TD] [/TR] [TR] [TD]5[/TD] [TD]total (test was out of)[/TD] [TD]60[/TD] [/TR] [TR] [TD]6[/TD] [TD]% change[/TD] [TD]=(B3/B5)-(B4/B5)[/TD] [/TR] [/TABLE] Hope this helps

Nope, desktop client, Windows 10 x64, TeamSpeak 3 version 3.1.4.2. That's strange - if I bookmark the server then try to connect, it didn't work. If I use the link in the top thread, it prompted me to request to increase my identity security level (see image below), then let me on when I did so. Wonder why that didn't appear the first time.

Just tried to connect to this, but getting the following error: <17:15:35> Insufficient identity security level for this server. You need to improve your identity security level. Wut did i do rong

Windows XP login sound.

Hi APOCH and swarohi, and welcome to the madhouse!

I think that we've TRIed that ANGLE before...

Here he is! (Sorry, I know I'm not finny... I'm hilarious!)

Oh wow that's epic Thanks for sharing and happy Friday!

Ok so the server decided that 12:44 was a good time for it to finish and restart. Thankfully a fair number of people were on lunch, but still..... I guess it solved the problem. Once I switched it back on again.

If you have the ability/time, it may be worth coding something that can run as a Windows Service that monitors network status (if it gets unplugged, does it have an Event ID in the event log?) and emails yourself or a designated mailbox, or just opens a popup every 10 seconds and takes focus to disrupt whatever the student is trying to do It does depend what problem you're trying to solve - if it's students unplugging the adapter to bypass monitoring, the above could help. If it's purely to annoy the next class then consider gluing them in (and using superglue dissolver to remove them), or cutting the clip on the RJ45 connector so that you need a screwdriver to release it?

Hi AlanD, Thanks for the warning - believe me I know! Although we are not a school, we do handle a lot of personal data, and running SQL 2000 on a Server 2003 R2 machine is not my idea of secure. On the other hand we are currently investing in a migration process to SQL Server 2016 on a Server 2016 box, however the challenges of migrating all of this system (including heavily in-house customised software) over the the new version have proved problematic without continued support from management and the departments within our business.

Well, I've got server problems today so I may not be revisiting this until next week as well!

If you use Impero, it has a feature to lock the screen when the network cable is unplugged. Just don't do what we did and apply it to laptops by mistake...

Thanks for the help Free. Yes, I can see WindowsUpdate.log and I can view the event logs. It looks like the last update complete successfully, but there's no call to start the next one. The last update was Microsoft Silverlight. In the Event Log it shows the following as being the last msiInstaller log entry: Event Type: Information Event Source: MsiInstaller Event Category: None Event ID: 1035 Date: 29/06/2017 Time: 20:49:35 User: NT AUTHORITY\SYSTEM Computer: Description: Windows Installer reconfigured the product. Product Name: Microsoft Silverlight. Product Version: 5.1.40416.0. Product Language: 1033. Reconfiguration success or error status: 0. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 7b 38 39 46 34 31 33 37 {89F4137 0008: 44 2d 36 43 32 36 2d 34 D-6C26-4 0010: 41 38 34 2d 42 44 42 38 A84-BDB8 0018: 2d 32 45 35 41 34 42 42 -2E5A4BB 0020: 37 31 45 30 30 7d 71E00} The WindowsUpdate.Log file shows these entries: 2017-06-29 20:49:36:104 896 658 DnldMgr Preparing update for install, updateId = {6FA27C4F-7654-4133-85AC-A21603E50768}.201. 2017-06-29 20:49:36:136 3932 1710 Handler ::::::::::::: 2017-06-29 20:49:36:136 3932 1710 Handler :: START :: Handler: Windows Patch Install 2017-06-29 20:49:36:136 3932 1710 Handler ::::::::: 2017-06-29 20:49:36:136 3932 1710 Handler : Updates to install = 1 2017-06-29 20:49:36:136 3932 1710 Handler : Installing update {6FA27C4F-7654-4133-85AC-A21603E50768}.201 2017-06-29 20:49:36:136 3932 1524 Handler Installing with parameters=-q -z -er, sandbox=C:\WINDOWS\SoftwareDistribution\Download\4c8caebca645ebcd32d4b6aae5bfc88c. 2017-06-29 20:49:45:485 3932 1524 Handler Install completed with 0x80070bc2. 2017-06-29 20:49:45:485 3932 1710 Handler : Install completed: result type = 0x1, installer error = False, error = 0x80070bc2, disabled until reboot = No, reboot required = Yes 2017-06-29 20:49:45:485 3932 1710 Handler ::::::::: 2017-06-29 20:49:45:485 3932 1710 Handler :: END :: Handler: Windows Patch Install 2017-06-29 20:49:45:485 3932 1710 Handler ::::::::::::: 2017-06-29 20:49:45:532 896 1018 AU >>## RESUMED ## AU: Installing update [updateId = {800AB899-CDE0-4E7E-9D49-751E356AB574}, succeeded] 2017-06-29 20:49:45:532 896 658 Report REPORT EVENT: {9F4367BE-D6C2-4E55-8F30-9784C3FA43AA} 2017-06-29 20:49:45:532+0100 1 199 101 {800AB899-CDE0-4E7E-9D49-751E356AB574} 201 0 AutomaticUpdates Success Content Install Installation successful and restart required for the following update: Update for Windows Server 2003 (KB3020338) 2017-06-29 20:49:45:532 896 658 DnldMgr Preparing update for install, updateId = {42E61FA7-4FCC-4A32-948E-8D3120670014}.100. 2017-06-29 20:49:45:783 3932 24c Handler ::::::::::::: 2017-06-29 20:49:45:783 3932 24c Handler :: START :: Handler: Command Line Install 2017-06-29 20:49:45:783 3932 24c Handler ::::::::: 2017-06-29 20:49:45:783 3932 24c Handler : Updates to install = 1 2017-06-29 20:49:47:674 4192 1094 Misc =========== Logging initialized (build: 7.6.7600.256, tz: +0100) =========== 2017-06-29 20:49:47:674 4192 1094 Misc = Process: c:\3280f3bc55d411164441cc\update\iesetup.exe 2017-06-29 20:49:47:674 4192 1094 Misc = Module: C:\WINDOWS\system32\wuapi.dll 2017-06-29 20:49:47:674 4192 1094 COMAPI ------------- 2017-06-29 20:49:47:674 4192 1094 COMAPI -- START -- COMAPI: Search [ClientId = Windows Internet Explorer 8 Setup Utility] 2017-06-29 20:49:47:674 4192 1094 COMAPI --------- 2017-06-29 20:49:47:690 4192 1094 COMAPI <<-- SUBMITTED -- COMAPI: Search [ClientId = Windows Internet Explorer 8 Setup Utility] 2017-06-29 23:06:37:945 896 17a0 Agent * Added update {9D460DA0-8983-4BB4-A839-DF88E5777488}.100 to search result 2017-06-29 23:06:37:945 896 17a0 Agent * Added update {3ABE760C-4578-4C84-A1CB-BF1DF019EFE4}.100 to search result 2017-06-29 23:06:37:945 896 17a0 Agent * Added update {596ADB47-108D-482D-85BA-A513621434B7}.100 to search result 2017-06-29 23:06:37:945 896 17a0 Agent * Added update {7079BEEB-6120-4AFD-AD07-FB4DFA284FBE}.100 to search result 2017-06-29 23:06:37:945 896 17a0 Agent Update {D9A1873D-B262-4943-9ACD-B4915CA81DEE}.200 is pruned out due to potential supersedence There are more entries more recently, but they seem to be referring to checking for updates rather than installing them. Is there anything generally I should be looking for? Many thanks

Morning all, So I need to expand a VHD on our primary SQL server, a virtual machine hosted on Hyper-V. I shut it down last night at 8:30pm and let it install the 18 updates it needs, and went to bed at 11:30pm with it installing update 11 of 18. This morning it is still installing the same update! Our SQL database and shared drive hosted on that server appear to still be live. Is there anything I can do to prevent this server from shutting down at an indeterminate time during the day, that won't cause data loss? Thanks in advance (it's too early in the morning for for this!)

Give the receptionist a shotgun.

One other thing to note as well: - Check which settings you edit. There's two parts under the Google heading in Group Policy Editor: Google Chrome, and Google Chrome (Default settings Users can override). I believe that policies set under Google Chrome take priority. User's (and administrators!) cannot change these settings if they're set under Google Chrome. Although this was my second foray into deploying software via GPO, it's gone well so far. My first doesn't really count because that was only dotNet Framework, didn't involve ADMX or anything. EDIT: @TIOAOA, @Tesla - this is where the thread now is.

Maybe show the PC's MAC address? Depending on your organisational structure, who to contact in the event of $MajorService failing on each site? (I'm talking about who within your team you'd go to for specific things such as Exchange, rather than who end-users would contact). Beyond that it looks like a fantastic idea!