ITGURU

Several ways: Pull the plug from the wall, log in to the switch and see which port shows as 'down' to find it then trace to patch panel port number. each switch should have a MAC address table, select the Port, view the MAC address and find it in DHCP from your asset list if you record MAC addresses.

No rats indoors so should be fine. Only ever had rodent damage to fibre outdoors but that's before it was replaced with armoured.

We are possibly going to be setting up a new IT Room. As the rest of the school is Cat5e does it make sense to continue with this or should I install Cat6? Due to the decommission of a building which was ALL cat 6 I have recovered the patch leads, so wondering whether to make the new room cat6 to re-use the cables or stick with Cat5e Whats your thoughts? thanks.

We used to license by core, but now it works out cheaper for us to license by Server + CALs

Thanks! It gave me a rough idea , so cracked it by part internet search and part your example! Now got each date, each year group and the total! SELECT date, COUNT(CASE WHEN year = 'Year 7' THEN 1 ELSE NULL END) AS Year7 ,COUNT(CASE WHEN year = 'Year 8' THEN 1 ELSE NULL END) AS Year8 , COUNT(CASE WHEN year = 'Year 9' THEN 1 ELSE NULL END) AS Year9 , COUNT(CASE WHEN year = 'Year 10' THEN 1 ELSE NULL END) AS Year10, COUNT(CASE WHEN year = 'Year 11' THEN 1 ELSE NULL END) AS Year11 ,COUNT(*) AS Total FROM tablename WITH ( NOLOCK ) group by date

I have an in-house designed system where the following happens: On each unique date, I have several SQL entries for each school year group. i.e: 07/06/2017 Year 7 07/06/2017 Year 7 07/06/2017 Year 8 07/06/2017 Year 9 07/06/2017 Year 10 07/06/2017 Year 10 08/06/2017 Year 7 I have an SQL query which can show the below using the query: SELECT DISTINCT year, COUNT(*) AS Count, date AS [Date] FROM tablename GROUP BY year, date order by date desc Date, Year Count 07/06/2017 Year 7 2 07/06/2017 Year 8 1 07/06/2017 Year 9 1 07/06/2017 Year 10 2 However, What i'm looking for is a query to generate the following - so that for each date, I have a count column for each year group Date, Year 7 Year 8 Year 9 Year 10 07/06/2017 2 1 1 2 08/06/2017 1 I am unable to get the right query/syntax to get this to show as required. Any help much appreciated. Thanks.

Copy and paste the data into a new document - worked for us when we used to get this, either saying disk full or out of memory. Was nothing to do with either but copying into a new document then allowed it to save.

It did on windows 7 - whenever I added a PC in as an exclusion deny 'read' on the policy and rebooted the computer it picked up the amended policy, remove it from the local policy and users could log in.

I signed up but not had any contact yet.

I have a GPO on windows 10 machines (on the latest update) which sets the policy item 'deny logon locally' with a security group of which all staff users are a member of so that only students can login to the computer. However, wanting to open up computers (the same way as I did on windows 7 ones) i add the computer into the policy with the deny setting so it doesnt allow the policy, but still got the message the login type is not allowed. As a full test I removed the GPO object entirely from the student computers group, ran gpupdate /force and checked with gpresult and the entry has gone but still won't allow staff to login. If i run gpedit.msc on the local pc, it is still showing the entry - I can manually remove it and staff can now login, but seems that the policy is not taking any effect on the workstations when remove the GPO or add the deny entry, However, when i add new workstations to the AD group with the GPO applied it adds the entry in, but seems once it has done this it won't remove it or amend it; any ideas?

150 licenses is very good to be free for lifetime if there are no strings attached.. I generally only send notification emails to staff for SIMS updates etc..

Use a laptop? it's what I usually do as in the same switch as the device . Alternatively could you port mirror across a VLAN setup on both switches?

Oh so your referring to games installed locally on the PC, I did wonder as don't have games on the PCs anyway! thought you was referring to internet games

Found it! Was the transport config Get-TransportConfig | ft MaxSendSize, MaxReceiveSize

I have an on-site exchange server with receive connector set ar the default 35mb. Our Mail filtering provider has a limit of 50mb. Whenever i sent any emails from external inbound, they fail with the following: This message wasn't delivered to anyone because it's too large. The limit is 12 MB. This message is 31 MB. I cannot work out where it is getting this setting from - where else would it be set? Thanks.

Whats the best SATA drive for 24/7 running for reliability. I need the best possible uptime/reliability of a SATA Drive array without going down the SAS route. Are the WD Red drives meant to be up to the same job as SAS drives, as i've had 2 before DOA.... Whats the best choice of SATA drive for RAID Arrays in devices such as Synology etc that will be on 24/7

Do they all support iscsi to extend a windows server storage? how would performance compare to local attached drives when using iscsi?

Does anyone have a sample CCTV policy anywhere ?

We use normal PC screens as well as TVs for our digital signage. We use ATEN kit which send the video signals over Cat5e cable and can be daisy chained.

I'll always be Physical server for SIMS for me - Dedicated sever with dedicated disks gives the best performance than a VM with a VHD as it's heavily used.

I can understand it IF you had got the malware then yes you would shut everything down to be safe, however if you still have a clean running network why would you take it down? I didn't see Microsoft or any other company shut down their networks. proactive monitoring through it worked for us.

I'm not sure why everyone is jumping in feet first disabling SMB1 without proper testing! If you have patched all your systems, have app rules an AV rules in place to prevent the file extensions, and registry entries being creating (as documented by McAfee) there should be no need to be disabling SMB1. Doing it during term time...well how silly is that! At least wait until the holidays! It's no wonder things break! It's the reason I NEVER install SIMS updates as soon as they are released, OR windows updates. I wait at least a week before installing so everyone else has find the issues first!

All my servers are set to notify me of updates. Every half term I install the latest updates and reboot manually at evenings or weekends. That way I can check everything is still working OK once the server has rebooted, rather than letting it reboot overnight (when backups take place) and finding it failed or something stopped working the next morning.

We just remotely monitor the students and report any playing games. We can block their access instantly, for a whole room i did once implement an ACL rule on the switch to block port 80 traffic.