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.

Sadly not, still the same problem.

Still the same problem using OWA.

Hi, Hoping someone can help. All of our users are unable to get the correct search result using Outlook 2010. They all can search for any emails older than the 20/07/2016 but anything after that they get no results. I've tried rebuilding the indexing in Outlook, but this hadnt done anything and my best guess it's something on the Exchange 2010 server? Any help would be greatly appreciated. Stuart

One of my favourites!

Thanks for all the replies, can get working on something next week.

Like the idea of having a forecast for projected costs and renewals, that's what I think I will be trying to setup. Stuart

Perfect place to start, than yo very much. Have this projected completed in no time... I hope

Sounds perfect, we've had a few problems with renewals not getting to me but sent to someone who isn't in so as you can imagine causes problems

Evening, Can I ask how people document their renewals? I was thinking of having a spreadsheet with the months of the academic year and when the renewals are up and the cost. Just so we know how much we have been paying over the last few years too and if we buy a 3 year licence we know when it's up for renewal. Stuart

Evening All, Just a random question, do you think that there is a way to have a table in MySQL with all the information in, and then I can have it copy the information from the table to another table? Sounds random but I want to make a kinda reference table with the data and then copy it to several other tables. Thanks in anticipation. Stuart