Stuart-Hannah

That's right, we don't have anything on the staff machines.

It will on the student machines but not the machines in office location.

Thanks for your reply Steve, got a perfect place to start now looking at the TCP Multi thread now just need to figure out how to send commands now ha!

Maybe I'm just being too ambitious.

That was the idea, have the client installed on the machines with an initial idea of being able to select all the machines and power down or power up for times when we can't get access to the rooms because of locked doors. Once the agent is up and running I can then add additional functionality as and when required. Stuart

Hi All, I am looking to create a client server so of utility for within the School however online all I can find is examples of 'Chat or messaging and I want to develop the client server to be able to power down online agents. Where would you start, can't seem to find where to start. Stuart

Thanks everyone, had a few days to think about this... survey not happening as I know it won't get completed.

I am looking to put together a survey to understand where staff are up to with regards to their understanding of ICT. What sort of things would you ask? Stuart

Thank you soo much for such a details response. It's definitely giving me a starting point for me to build the system! I have just been banging my head at this part for a while now. Hopefully I'll have this understood before I k is it

Thanks for the reply. Basically I am running a report once or twice a year from SIMS which gives me a CSV. From the CSV I will get the information about the room, with data looking like the following that's imported into MySQL. Room Name Period Class name Staff Code Room1 MonA:1 7L/IT1 ASm Room1 MonA:2 8R/Ma1 PKa CREATE TABLE `tbl_misdata` ( `MIS_ID` int(11) NOT NULL, `MIS_Room` varchar(200) NOT NULL, `MIS_Period` varchar(200) NOT NULL, `MIS_Class` varchar(200) NOT NULL, `MIS_Staff` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; My Table (it_booking_Room1) has the structure of 'start_week' | MON1 | MON2 .. | Week So what I am trying to do is import the data from the mis table to the room table. Each week within the room table has the Week column so I am trying to use that in the query to enable me to work out if it's an A or B week and then copyt that data over. Hope that makes sence. Stuart

I am trying to load data from one table to another. In the source table (tbl_MISData) it has the data from the MIS, so for example it will have a column called Period - MONA:1, MONA2 and so on and one called Staff. ABC, DEF, and so on. What I am trying to do is get the data from this table another table. Here the problem, my table has all the columns in the table so for instance Monday is MON1, MON2, MON3, MON4, MON5, Week, Start_date and the table from MIS only has the lessons and not the frees so I was trying to MySQL this from one table to another and whatever it doesn't transfer will leave the default values of Free in. MySQL copy code (not working) SELECT * FROM `tbl_misdata` WHERE `MIS_Room` = 'IT1' OR MIS_Period = 'MONA%'; UPDATE it_booking_i1 SET Mon1 = 'MonA:1' WHERE it_booking_i1.Week = "A"; I am trying to get it to pull any information that matches the Mon where the Week matches the data. I hope I have explained this the best I can. Stuart

How about this one: https://www.futurelearn.com/courses/introduction-to-cyber-security It's free too!

Afternoon, Just been thinking of making life easier by putting together forms for staff when they raise things on the helpdesk so we can get things seen to quicker. For example I have just made a form for staff to use when they request the controlled assessment accounts. Does anyone do anything like this and if so, what else do you typically cover. Or am I making things more hassle. Still 'learning' as I go, trying to fix the world one step at a time. Stuart

We had a similar issue, turned out it was DPM and shadow copy

Sadly not, still the same problem.