jwonnacott

Thanks, yes ACS and it's a Sonicwall box. But in that case shouldn't I see it in the FW logs?

Hello all, Anybody had experience of class dojo on a clevertouch screen? The app is installed but when logging on it just says there was a problem. It seems that packets are not hitting the FW but I can see normal traffic from the Clevertouch traversing OK. Thanks, James.

Having worked in secondary for many years I'm now covering 7 primaries. Everything going fine except ipads. I really need to learn how to use the configurator but can find no useful information. For example: I have an ipad which went brick-like and had to be restored to original; did that OK with DHU and itunes., then attached it to the mac mini running configurator 2, told it to apply the blueprint which it seemed to do(downloade apps, fixed plaeholders, installed apps etc). Configurator is showing it has all apps and profiles but tthe ipad just sits there sayinh hello in many languages. What am I missing please? Thanks, James.

I've just been asked to resurrect our old FMS database (We stopped using FMS in 2011) to track down some mystery or other. I've fired up the old VM the server used to run on and attached the last backup of FMS.mdf (using dbattach as I recall it does something "special" with users), I can see all the tables etc.. I've fired up an old XP VM with the FMS programme on it and it's pointing to the server. No-one can remember their old username or password so I've reset the FMS_sysman password using SQL server Management studio. I'm getting " Invalid User ID/Password or Database Name" when I try to logon to FMS. Any ideas? Thanks, James

I've cobbled together a bit of SQL to list all stations that have not yet got their update. No doubt an SQLer will find it amusing (and hopefully improve it) but for what it's worth here it is. Just replace the package name in two places. SELECT [agent].[name] AS [name], [package].[description] AS [description2] FROM (SELECT DISTINCT * FROM [solus3].[agent_package_site] WHERE success =0) AS [aps] INNER JOIN [solus3].[agent_package] AS [ap] ON [aps].[agent_package_id] = [ap].[agent_package_id] LEFT OUTER JOIN [solus3].[distributed_deployment_plan] AS [dpp] ON [aps].[distributed_deployment_plan_guid] = [dpp].[distributed_deployment_plan_guid] LEFT OUTER JOIN [solus3].[agent_package] AS [ap1] ON [aps].[agent_package_id] = [ap1].[agent_package_id] LEFT OUTER JOIN [solus3].[target] ON [ap1].[target_guid] = [target].[target_guid] LEFT OUTER JOIN [solus3].[agent] ON [ap1].[agent_guid] = [agent].[agent_guid] LEFT OUTER JOIN [solus3].[target] AS [target1] ON [ap1].[target_guid] = [target1].[target_guid] LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp] ON [ap1].[recompiled_package_guid] = [rp].[recompiled_package_guid] LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp1] ON [ap1].[recompiled_package_guid] = [rp1].[recompiled_package_guid] LEFT OUTER JOIN [solus3].[package] ON [rp1].[package_guid] = [package].[package_guid] WHERE [package].[description] LIKE 'SIMS 2012 Autumn%' AND agent.name NOT LIKE '%removed%' EXCEPT SELECT [agent].[name] AS [name], [package].[description] AS [description2] FROM (SELECT * FROM [solus3].[agent_package_site] WHERE success =1) AS [aps] INNER JOIN [solus3].[agent_package] AS [ap] ON [aps].[agent_package_id] = [ap].[agent_package_id] LEFT OUTER JOIN [solus3].[distributed_deployment_plan] AS [dpp] ON [aps].[distributed_deployment_plan_guid] = [dpp].[distributed_deployment_plan_guid] LEFT OUTER JOIN [solus3].[agent_package] AS [ap1] ON [aps].[agent_package_id] = [ap1].[agent_package_id] LEFT OUTER JOIN [solus3].[target] ON [ap1].[target_guid] = [target].[target_guid] LEFT OUTER JOIN [solus3].[agent] ON [ap1].[agent_guid] = [agent].[agent_guid] LEFT OUTER JOIN [solus3].[target] AS [target1] ON [ap1].[target_guid] = [target1].[target_guid] LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp] ON [ap1].[recompiled_package_guid] = [rp].[recompiled_package_guid] LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp1] ON [ap1].[recompiled_package_guid] = [rp1].[recompiled_package_guid] LEFT OUTER JOIN [solus3].[package] ON [rp1].[package_guid] = [package].[package_guid] WHERE [package].[description] LIKE 'SIMS 2012 Autumn%' AND agent.name NOT LIKE '%removed%' ORDER BY [agent].[name] ASC Just bung it in a query in SQL Server Management Studio. Hope it helps someone. James