Optimise WSUS database for sCCM

errors when synchronising updates from WSUS.  Increasing HTTP session times, max upload limits and max memory times can certainly help but if making major changes, it may also be necessary to make the infrastructure as clean as possible to improve efficiency.  Each second can make a huge difference.

The following SQL script should be run from within the Microsoft SQL Management Studio interface when connected to the database instance containing the SCCM database.  I got most if not all of this script from somewhere years ago.  I’ts been in my tool kit ever since. I’m sorry I cant give the original source.


USE SUSDB;
GO
SET NOCOUNT ON;
-- Rebuild or reorganize indexes based on their fragmentation levels
DECLARE @work_to_do TABLE (
objectid int
, indexid int
, pagedensity float
, fragmentation float
, numrows int
)
DECLARE @objectid int;
DECLARE @indexid int;
DECLARE @schemaname nvarchar(130);
DECLARE @objectname nvarchar(130);
DECLARE @indexname nvarchar(130);
DECLARE @numrows int
DECLARE @density float;
DECLARE @fragmentation float;
DECLARE @command nvarchar(4000);
DECLARE @fillfactorset bit
DECLARE @numpages int
-- Select indexes that need to be defragmented based on the following
-- * Page density is low
-- * External fragmentation is high in relation to index size
PRINT 'Estimating fragmentation: Begin. ' + convert(nvarchar, getdate(), 121)
INSERT @work_to_do
SELECT
f.object_id
, index_id
, avg_page_space_used_in_percent
, avg_fragmentation_in_percent
, record_count
FROM
sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'SAMPLED') AS f
WHERE
(f.avg_page_space_used_in_percent < 85.0 and f.avg_page_space_used_in_percent/100.0 * page_count < page_count - 1)
or (f.page_count > 50 and f.avg_fragmentation_in_percent > 15.0)
or (f.page_count > 10 and f.avg_fragmentation_in_percent > 80.0)
PRINT 'Number of indexes to rebuild: ' + cast(@@ROWCOUNT as nvarchar(20))
PRINT 'Estimating fragmentation: End. ' + convert(nvarchar, getdate(), 121)
SELECT @numpages = sum(ps.used_page_count)
FROM
@work_to_do AS fi
INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id
-- Declare the cursor for the list of indexes to be processed.
DECLARE curIndexes CURSOR FOR SELECT * FROM @work_to_do
-- Open the cursor.
OPEN curIndexes
-- Loop through the indexes
WHILE (1=1)
BEGIN
FETCH NEXT FROM curIndexes
INTO @objectid, @indexid, @density, @fragmentation, @numrows;
IF @@FETCH_STATUS < 0 BREAK;
SELECT
@objectname = QUOTENAME(o.name)
, @schemaname = QUOTENAME(s.name)
FROM sys.objects AS o
INNER JOIN sys.schemas as s ON s.schema_id = o.schema_id
WHERE
o.object_id = @objectid;
SELECT
@indexname = QUOTENAME(name)
, @fillfactorset = CASE fill_factor WHEN 0 THEN 0 ELSE 1 END
FROM
sys.indexes
WHERE
object_id = @objectid AND index_id = @indexid;
IF ((@density BETWEEN 75.0 AND 85.0) AND @fillfactorset = 1) OR (@fragmentation < 30.0)
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REORGANIZE';
ELSE IF @numrows >= 5000 AND @fillfactorset = 0
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD WITH (FILLFACTOR = 90)';
ELSE
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';
PRINT convert(nvarchar, getdate(), 121) + N' Executing: ' + @command;
EXEC (@command);
PRINT convert(nvarchar, getdate(), 121) + N' Done.';
END
-- Close and deallocate the cursor.
CLOSE curIndexes;
DEALLOCATE curIndexes;
IF EXISTS (SELECT * FROM @work_to_do)
BEGIN
PRINT 'Estimated number of pages in fragmented indexes: ' + cast(@numpages as nvarchar(20))
SELECT @numpages = @numpages - sum(ps.used_page_count)
FROM
@work_to_do AS fi
INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id
PRINT 'Estimated number of pages freed: ' + cast(@numpages as nvarchar(20))
END
GO
--Update all statistics
PRINT 'Updating all statistics.' + convert(nvarchar, getdate(), 121)
EXEC sp_updatestats
PRINT 'Done updating statistics.' + convert(nvarchar, getdate(), 121)
GO

Watching the output of this script is quite important.  The last 1000 lines provide the most information.

You will want to take note of the level of cleanup that has been achieved as this could indicate the levels of efficiency that you can expect.  The easiest way of doing this is to search for the words “have been updated”. Look at the number at the start of that line.  If it’s more than 0, the script has found indexes to rebuild.

Sample output is shown below:

Estimated number of pages in fragmented indexes: 393155

Estimated number of pages freed: 69459

Updating all statistics.2018-07-06 09:54:29.657

Updating [dbo].[tbUpdateClassificationInAutoDeploymentRule]

[PK__tbUpdate__EF57E38AB5DB6069], update is not necessary…

[_WA_Sys_00000002_00AA174D], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbEventNamespace]

[PK__tbEventN__D26A6B34F8C5246F] has been updated…

1 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbRevisionExtendedProperty]

[cRevisionExtendedProperty], update is not necessary…

[PK__tbRevisi__B4B1E3F0A229664B], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbDcRollupStatus]

[PK__tbDcRoll__3214EC0761B4055F], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbCategoryInAutoDeploymentRule]

[PK__tbCatego__89359C8D3A834AA7], update is not necessary…

[_WA_Sys_00000002_02925FBF], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbKBArticleForRevision]

[PK__tbKBArti__41E15B7381E7F648] has been updated…

[nc1KBArticleForRevision], update is not necessary…

[tbKBArticleForRevision_RevisionID_AK], update is not necessary…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbTargetGroupInAutoDeploymentRule]

[PK__tbTarget__EF99A0AB57E3CAE9], update is not necessary…

[_WA_Sys_00000002_047AA831], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbMoreInfoURLForRevision]

[PK__tbMoreIn__DF49EF3CD9A1749F], update is not necessary…

[nc_RevisionID_ShortLanguage], update is not necessary…

[_WA_Sys_00000004_04E4BC85] has been updated…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbDeletedDynamicCategory]

[PK__tbDelete__3214EC072B5F7A37], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [sys].[sqlagent_jobs]

[sqlagent_jobs_clust], update is not necessary…

[sqlagent_jobs_nc1_name], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbSchemaVersion]

[PK__tbSchema__3214EC270B90850F], update is not necessary…

[_WA_Sys_00000002_0662F0A3], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [sys].[sqlagent_jobsteps]

[sqlagent_jobsteps_clust], update is not necessary…

[sqlagent_jobsteps_nc1], update is not necessary…

[sqlagent_jobsteps_nc2], update is not necessary…

0 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbSecurityBulletinForRevision]

[PK__tbSecuri__2A32F464E5E42E8C] has been updated…

[nc1SecurityBulletinForRevision], update is not necessary…

[tbSecurityBulletinForRevision_RevisionID_AK], update is not necessary…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [sys].[sqlagent_job_history]

[sqlagent_job_history_clust], update is not necessary…

[sqlagent_job_history_nc1], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [sys].[sqlagent_jobsteps_logs]

[sqlagent_jobsteps_logs_nc1], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbSchemaVersionHistory]

[PK__tbSchema__3214EC27B3BDE56D], update is not necessary…

[_WA_Sys_00000002_093F5D4E], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbLocalizedPropertyForRevision]

[PK__tbLocali__D4CFF398BDB7EF27], update is not necessary…

[_WA_Sys_00000003_09A971A2] has been updated…

[_WA_Sys_00000002_09A971A2] has been updated…

2 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [sys].[plan_persist_query_text]

[plan_persist_query_text_cidx], update is not necessary…

[plan_persist_query_text_idx1], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbLocaleMap]

[PK__tbLocale__AE84BA92B17C16E3] has been updated…

1 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [sys].[plan_persist_query]

[plan_persist_query_cidx], update is not necessary…

[plan_persist_query_idx1], update is not necessary…

[_WA_Sys_0000000B_0AD2A005], update is not necessary…

[_WA_Sys_00000007_0AD2A005], update is not necessary…

0 index(es)/statistic(s) have been updated, 4 did not require update.

Updating [dbo].[tbFileForRevision]

[PK__tbFileFo__42CF22AD08F0CC92] has been updated…

[nc1FileForRevision], update is not necessary…

[_WA_Sys_00000003_0B91BA14] has been updated…

2 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [sys].[plan_persist_plan]

[plan_persist_plan_cidx], update is not necessary…

[plan_persist_plan_idx1], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbOSMap]

[PK__tbOSMap__AEE3B0B5D347E461] has been updated…

1 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [sys].[plan_persist_runtime_stats]

[plan_persist_runtime_stats_cidx], update is not necessary…

[plan_persist_runtime_stats_idx1], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbServerHealth]

[PK__tbServer__DB06D1C0AB2C4E74], update is not necessary…

[_WA_Sys_00000002_0D0FEE32] has been updated…

[_WA_Sys_00000003_0D0FEE32] has been updated…

2 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [sys].[plan_persist_runtime_stats_interval]

[plan_persist_runtime_stats_interval_cidx], update is not necessary…

[plan_persist_runtime_stats_interval_idx1], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbDownstreamServerRollupConfiguration]

[PK__tbDownst__3214EC27E574F228] has been updated…

1 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbFileHash]

[PK__tbFileHa__67EC15CEBA35EE03], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [sys].[plan_persist_context_settings]

[plan_persist_context_settings_cidx], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbProgramKeys]

[PK__tbProgra__998876FC76876942], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbEventRollupCounters]

[PK__tbEventR__3214EC274B4E5455] has been updated…

1 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbRevisionSupersedesUpdate]

[PK__tbRevisi__4333258303879077], update is not necessary…

[_WA_Sys_00000002_10566F31] has been updated…

1 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbComputersThatNeedDetailedRollup]

[cComputersThatNeedDetailedRollup], update is not necessary…

[_WA_Sys_00000002_11D4A34F] has been updated…

1 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbInstalledUpdateSufficientForPrerequisite]

[PK__tbInstal__C3A1622446A6B8C1], update is not necessary…

[nc1InstalledUpdateSufficientForPrerequisite], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbConfigurationA]

[PK__tbConfig__95AA539B6FE6A126], update is not necessary…

[_WA_Sys_0000000E_12FDD1B2] has been updated…

[_WA_Sys_00000018_12FDD1B2] has been updated…

[_WA_Sys_0000000F_12FDD1B2] has been updated…

[_WA_Sys_00000004_12FDD1B2] has been updated…

4 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbBundleAtLeastOne]

[tbBundleAtLeastOne_PK], update is not necessary…

[nc1BundleAtLeastOne], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbDriverTargetingGroup]

[PK_DriverTargetingGroup_DriverTargetingID], update is not necessary…

[AK_TargetGroupID], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbBundleAll]

[tbBundleAll_PK] has been updated…

[nc1BundleAll] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbDriverTargetingGroupPrerequisite]

[PK_DriverTargetingGroupPrerequisite_DriverTargetingID_LocalUpdateID], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbPrerequisite]

[PK__tbPrereq__25A953F9D1826CC2] has been updated…

[nc1Prerequisite] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbDriver]

[PK__tbDriver__258B78A91057D0C7], update is not necessary…

[nc1Driver], update is not necessary…

[nc2Driver], update is not necessary…

[_WA_Sys_00000008_19DFD96B] has been updated…

1 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbTargetedDriverHwid]

[PK_tbTargetedDriverHwid_TargetGroupID_LocalUpdateID_HardwareID], update is not necessary…

[IX_LocalUpdateID], update is not necessary…

[_WA_Sys_00000003_1B5E0D89], update is not necessary…

0 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbCompatiblePrinterProvider]

[PK__tbCompat__DA62685F505D11E7], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbDriverClass]

[PK__tbDriver__CB1927A03C8C1D86], update is not necessary…

[_WA_Sys_00000002_1DB06A4F], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbDriverFeatureScore]

[PK_tbDriverFeatureScore_OperatingSystem_FeatureScore_RevisionID_HardwareID], update is not necessary…

[IX_RevisionID], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbTargetGroup]

[PK__tbTarget__73CAF84D12F8EEA1] has been updated…

[_WA_Sys_00000007_1F98B2C1], update is not necessary…

[_WA_Sys_00000001_1F98B2C1], update is not necessary…

[_WA_Sys_00000006_1F98B2C1], update is not necessary…

[_WA_Sys_00000002_1F98B2C1], update is not necessary…

1 index(es)/statistic(s) have been updated, 4 did not require update.

Updating [dbo].[tbDistributionComputerHardwareId]

[PK_tbDistributionComputerHardwareId_DistributionComputerHardwareId_RevisionID_HardwareID], update is not necessary…

[IX_RevisionID], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbConfiguration]

[PK__tbConfig__737584F78BF438A6] has been updated…

[_WA_Sys_00000002_24285DB4] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbFlattenedTargetGroup]

[cFlattenedTargetGroup] has been updated…

[_WA_Sys_00000002_245D67DE], update is not necessary…

1 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbTargetComputerHardwareId]

[PK_tbTargetComputerHardwareId_TargetComputerHardwareId_RevisionID_HardwareID], update is not necessary…

[IX_RevisionID] has been updated…

1 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbPrerequisiteDependency]

[PK__tbPrereq__4E62540B2259B2A5], update is not necessary…

[nc1PrerequisiteDependency], update is not necessary…

[nc2PrerequisiteDependency], update is not necessary…

0 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbImplicitCategory]

[PK__tbImplic__D0AB88605C0E4471] has been updated…

[_WA_Sys_00000002_2610A626] has been updated…

[_WA_Sys_00000003_2610A626] has been updated…

[_WA_Sys_00000004_2610A626], update is not necessary…

3 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbTargetGroupType]

[PK__tbTarget__59800DAA3F5C598F], update is not necessary…

[_WA_Sys_00000002_2739D489], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbBundleDependency]

[PK__tbBundle__40BEE6EB50595A26], update is not necessary…

[nc1BundleDependency], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbExpandedTargetInTargetGroup]

[PK__tbExpand__017B08B6EC872E20], update is not necessary…

[nc1ExpandedTargetInTargetGroup], update is not necessary…

[_WA_Sys_00000003_29221CFB] has been updated…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbUpdateStatusPerComputer]

[cUpdateStatusPerComputer] has been updated…

[nc3UpdateStatusPerComputer] has been updated…

[nc2UpdateStatusPerComputer] has been updated…

[_WA_Sys_00000005_29572725] has been updated…

4 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbCategoryInSubscription]

[PK__tbCatego__D0AB886033D05F48] has been updated…

[_WA_Sys_00000001_29E1370A] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbUpdateSummaryForAllComputers]

[PK__tbUpdate__41FBF71B437115EA] has been updated…

[_WA_Sys_00000007_2B3F6F97] has been updated…

[_WA_Sys_00000006_2B3F6F97] has been updated…

[_WA_Sys_00000004_2B3F6F97] has been updated…

[_WA_Sys_00000003_2B3F6F97] has been updated…

[_WA_Sys_00000002_2B3F6F97] has been updated…

[_WA_Sys_00000005_2B3F6F97] has been updated…

7 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbLanguageInSubscription]

[PK__tbLangua__709AE7C06D191881], update is not necessary…

[_WA_Sys_00000001_2BC97F7C], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbTargetInTargetGroup]

[PK__tbTarget__017B08B62CCB0ED6], update is not necessary…

[nc1TargetInTargetGroup], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbEulaProperty]

[tbEulaProperty_PK] has been updated…

[nc1EulaProperty], update is not necessary…

[nc2EulaProperty], update is not necessary…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbSchedule]

[PK__tbSchedu__0AFEF4FFA9B4F84B] has been updated…

[_WA_Sys_00000002_2EA5EC27], update is not necessary…

[_WA_Sys_00000006_2EA5EC27] has been updated…

2 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbEulaAcceptance]

[PK__tbEulaAc__51426B64679B5E8B], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbLocalizedProperty]

[PK__tbLocali__ED9531CA12605109] has been updated…

[_WA_Sys_00000004_31B762FC] has been updated…

[_WA_Sys_00000002_31B762FC] has been updated…

[_WA_Sys_00000003_31B762FC] has been updated…

4 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbEmailNotificationRecipient]

[_WA_Sys_00000002_32767D0B], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbComputerSummaryForMicrosoftUpdates]

[PK__tbComput__2B1F0FB6578C2A17] has been updated…

[_WA_Sys_00000007_32E0915F] has been updated…

[_WA_Sys_00000006_32E0915F] has been updated…

[_WA_Sys_00000004_32E0915F] has been updated…

[_WA_Sys_00000003_32E0915F] has been updated…

[_WA_Sys_00000002_32E0915F] has been updated…

6 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbRevisionInCategory]

[PK__tbRevisi__15217053AF5A8197], update is not necessary…

[nc1RevisionInCategory], update is not necessary…

[_WA_Sys_00000003_336AA144] has been updated…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbFile]

[PK__tbFile__67EC15CE22F0B68E], update is not necessary…

[_WA_Sys_00000005_339FAB6E] has been updated…

[_WA_Sys_0000000A_339FAB6E] has been updated…

2 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbCategory]

[PK__tbCatego__19093A2B2AB80EBB] has been updated…

[nc1Category], update is not necessary…

[_WA_Sys_00000003_36470DEF] has been updated…

[_WA_Sys_00000001_36470DEF] has been updated…

3 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbXml]

[PK__tbXml__D14A66A92CE68940] has been updated…

[nc1tbXml] has been updated…

[nc2tbXml], update is not necessary…

[_WA_Sys_00000004_395884C4] has been updated…

3 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbRequestedTargetGroup]

[PK__tbReques__4AC8E77DC26A693B] has been updated…

[AK_Name] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbRevision]

[PK__tbRevisi__B4B1E3F16E301DBD] has been updated…

[UQ__tbRevisi__FFEE74505DA44DE1], update is not necessary…

[ncRevision_LocalUpdateID_RevisionNumber__IsLatestRevision], update is not necessary…

[_WA_Sys_0000000D_3B0BC30C] has been updated…

[_WA_Sys_00000003_3B0BC30C] has been updated…

[_WA_Sys_00000009_3B0BC30C] has been updated…

[_WA_Sys_00000005_3B0BC30C] has been updated…

[_WA_Sys_0000000C_3B0BC30C] has been updated…

[_WA_Sys_0000000E_3B0BC30C] has been updated…

[_WA_Sys_0000000A_3B0BC30C] has been updated…

8 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbRequestedTargetGroupsForTarget]

[PK__tbReques__EFB381C1A483E882] has been updated…

[nc1RequestedTargetGroupNamesForTarget] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbGroupAuthorization]

[PK__tbGroupA__CD594A31A0A1EA75], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbDeletedComputer]

[cDeletedComputer] has been updated…

[_WA_Sys_00000002_3E52440B], update is not necessary…

1 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbAuthorization]

[PK__tbAuthor__7C10E501989F4D8E], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbFileOnServer]

[c0FileOnServer], update is not necessary…

[PK__tbFileOn__CEB6B0F6C7814EE5], update is not necessary…

[_WA_Sys_00000005_40F9A68C] has been updated…

[_WA_Sys_00000007_40F9A68C] has been updated…

[_WA_Sys_00000006_40F9A68C] has been updated…

[_WA_Sys_00000004_40F9A68C] has been updated…

4 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbComputerTargetDetail]

[PK__tbComput__2B1F0FB62F2A098B] has been updated…

[_WA_Sys_00000019_412EB0B6] has been updated…

[_WA_Sys_00000018_412EB0B6] has been updated…

[_WA_Sys_00000016_412EB0B6] has been updated…

[_WA_Sys_00000015_412EB0B6] has been updated…

[_WA_Sys_00000014_412EB0B6] has been updated…

[_WA_Sys_00000013_412EB0B6] has been updated…

[_WA_Sys_00000011_412EB0B6] has been updated…

[_WA_Sys_0000000D_412EB0B6] has been updated…

[_WA_Sys_00000007_412EB0B6] has been updated…

[_WA_Sys_00000006_412EB0B6] has been updated…

[_WA_Sys_00000005_412EB0B6] has been updated…

[_WA_Sys_00000004_412EB0B6] has been updated…

[_WA_Sys_00000003_412EB0B6] has been updated…

[_WA_Sys_00000002_412EB0B6] has been updated…

[_WA_Sys_00000012_412EB0B6] has been updated…

16 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbRevisionExtendedLanguageMask]

[PK__tbRevisi__B4B1E3F1D654B4CC], update is not necessary…

[_WA_Sys_00000008_467D75B8], update is not necessary…

[_WA_Sys_00000007_467D75B8], update is not necessary…

[_WA_Sys_00000006_467D75B8], update is not necessary…

[_WA_Sys_00000005_467D75B8], update is not necessary…

[_WA_Sys_00000004_467D75B8], update is not necessary…

[_WA_Sys_00000003_467D75B8], update is not necessary…

[_WA_Sys_00000002_467D75B8], update is not necessary…

0 index(es)/statistic(s) have been updated, 8 did not require update.

Updating [dbo].[tbFileDownloadProgress]

[c0FileDownloadProgress], update is not necessary…

[PK__tbFileDo__FFEE7450646AF6B0], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbSingletonData]

[PK__tbSingle__3214EC271E8D720D] has been updated…

[_WA_Sys_00000004_489AC854] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbInventoryRule]

[PK__tbInvent__110458C27E00BE95] has been updated…

1 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbInventoryClass]

[PK__tbInvent__CB1927A0D2414B9F] has been updated…

[UQ__tbInvent__737584F6530A1416], update is not necessary…

1 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbComputerTarget]

[PK__tbComput__2B1F0FB6AF431FFF] has been updated…

[UQ__tbComput__A6BE3C55B28EB30E] has been updated…

[nc1ComputerTarget] has been updated…

[nc4ComputerTarget], update is not necessary…

[nc5ComputerTarget] has been updated…

[nc_EffectiveLastDetectionTime], update is not necessary…

[ncComputerTarget_FullDomainName] has been updated…

[_WA_Sys_00000004_4CA06362] has been updated…

[_WA_Sys_0000000E_4CA06362] has been updated…

[_WA_Sys_00000006_4CA06362] has been updated…

8 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbReference]

[_WA_Sys_00000003_4D5F7D71], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbInventoryProperty]

[PK__tbInvent__70C9A755BF901251] has been updated…

[nc_ClassID_Name], update is not necessary…

[_WA_Sys_00000004_4E0988E7], update is not necessary…

[_WA_Sys_00000003_4E0988E7], update is not necessary…

1 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbUpdate]

[PK__tbUpdate__41FBF71BABCFDA07] has been updated…

[UQ__tbUpdate__7A0CF324C4CE45ED], update is not necessary…

[nc1UpdateBooleanProperties] has been updated…

[_WA_Sys_00000007_4F12BBB9] has been updated…

[_WA_Sys_00000003_4F12BBB9] has been updated…

[_WA_Sys_00000009_4F12BBB9] has been updated…

[_WA_Sys_00000008_4F12BBB9] has been updated…

[_WA_Sys_00000006_4F12BBB9] has been updated…

[_WA_Sys_0000000C_4F12BBB9] has been updated…

[_WA_Sys_0000000A_4F12BBB9] has been updated…

9 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbInventoryXml]

[PK__tbInvent__2B1F0FB6FB655E45], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbFrontEndServersHealth]

[_WA_Sys_00000002_51300E55], update is not necessary…

[_WA_Sys_00000001_51300E55], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbClientWithRecentNameChange]

[c0ClientWithRecentNameChange] has been updated…

[nc1ClientWithRecentNameChange] has been updated…

[nc2ClientWithRecentNameChange] has been updated…

3 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbDownstreamServerTarget]

[PK__tbDownst__2B1F0FB6C66CBDA2], update is not necessary…

[ncDownstreamServerTarget_AccountServerID], update is not necessary…

[_WA_Sys_00000003_52593CB8], update is not necessary…

[_WA_Sys_00000008_52593CB8], update is not necessary…

0 index(es)/statistic(s) have been updated, 4 did not require update.

Updating [dbo].[tbInventoryClassInstance]

[PK__tbInvent__7B875D378A76BC62], update is not necessary…

[nc_TargetID_ClassID_KeyValue], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbConfigurationC]

[PK__tbConfig__95AA539B5F404C9D] has been updated…

[_WA_Sys_00000007_531856C7] has been updated…

[_WA_Sys_00000006_531856C7] has been updated…

[_WA_Sys_00000010_531856C7] has been updated…

[_WA_Sys_00000013_531856C7], update is not necessary…

4 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbInventoryPropertyInstance]

[PK__tbInvent__3C8BC7424D4DDAB6], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbDownstreamServerSummaryRollup]

[PK__tbDownst__2B1F0FB6840FA8D3], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbUpdateType]

[PK__tbUpdate__C6E976513C143C88], update is not necessary…

[_WA_Sys_00000002_56B3DD81], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbDownstreamServerClientSummaryRollup]

[PK__tbDownst__BB6E14AEA24B5A36] has been updated…

[_WA_Sys_0000000E_571DF1D5] has been updated…

[_WA_Sys_0000000D_571DF1D5] has been updated…

[_WA_Sys_0000000C_571DF1D5] has been updated…

[_WA_Sys_0000000B_571DF1D5] has been updated…

[_WA_Sys_00000009_571DF1D5] has been updated…

[_WA_Sys_00000008_571DF1D5] has been updated…

[_WA_Sys_00000007_571DF1D5] has been updated…

[_WA_Sys_00000006_571DF1D5] has been updated…

[_WA_Sys_00000005_571DF1D5] has been updated…

[_WA_Sys_00000004_571DF1D5] has been updated…

[_WA_Sys_00000003_571DF1D5] has been updated…

[_WA_Sys_00000001_571DF1D5] has been updated…

13 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbUpdateFlag]

[PK__tbUpdate__41FBF71BDB4B740D] has been updated…

[_WA_Sys_00000002_589C25F3] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbHandler]

[PK__tbHandle__9E0BC726AAE4466E] has been updated…

[_WA_Sys_00000002_5A846E65], update is not necessary…

[_WA_Sys_00000003_5A846E65], update is not necessary…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbLanguage]

[PK__tbLangua__B938558B9AC226DD] has been updated…

[nc1Language], update is not necessary…

[_WA_Sys_00000006_5C6CB6D7], update is not necessary…

[_WA_Sys_00000008_5C6CB6D7], update is not necessary…

1 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbDownstreamServerClientActivityRollup]

[PK__tbDownst__2C79B11A98CD4CE3] has been updated…

[_WA_Sys_00000003_5CD6CB2B] has been updated…

[_WA_Sys_00000002_5CD6CB2B] has been updated…

3 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbTarget]

[PK__tbTarget__2B1F0FB60BB31BD4], update is not necessary…

[nc1Target], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbTargetType]

[PK__tbTarget__B3CB14E1F7BEC913] has been updated…

1 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [dbo].[tbCategoryType]

[PK__tbCatego__0BDC1A59A6ED6486], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbDeployment]

[c0DeploymentRevision] has been updated…

[PK__tbDeploy__5EF8D7168D76D15E] has been updated…

[nc2DeploymentRevision], update is not necessary…

[nc5DeploymentRevision], update is not necessary…

[nc6DeploymentRevision], update is not necessary…

[nc_RevisionID_TargetGroupID_ActionID], update is not necessary…

[_WA_Sys_00000005_6383C8BA] has been updated…

[_WA_Sys_0000000F_6383C8BA] has been updated…

[_WA_Sys_00000008_6383C8BA] has been updated…

[_WA_Sys_00000002_6383C8BA] has been updated…

[_WA_Sys_00000011_6383C8BA] has been updated…

[_WA_Sys_00000010_6383C8BA] has been updated…

[_WA_Sys_00000004_6383C8BA] has been updated…

[_WA_Sys_00000013_6383C8BA] has been updated…

[_WA_Sys_0000000C_6383C8BA] has been updated…

[_WA_Sys_0000000A_6383C8BA] has been updated…

[_WA_Sys_00000006_6383C8BA] has been updated…

13 index(es)/statistic(s) have been updated, 4 did not require update.

Updating [dbo].[tbStateMachine]

[PK__tbStateM__C1BCE470C336BEFA], update is not necessary…

[nc1StateMachine], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbStateMachineState]

[PK__tbStateM__CFFF1AAC3E92B11A], update is not necessary…

[nc1StateMachineState], update is not necessary…

[stateNameUniqueForStateMachineID], update is not necessary…

[_WA_Sys_00000002_65F62111], update is not necessary…

0 index(es)/statistic(s) have been updated, 4 did not require update.

Updating [dbo].[tbStateMachineEvent]

[PK__tbStateM__6450F59EDC46160E], update is not necessary…

[nc1StateMachineEvent], update is not necessary…

[eventNameUniqueForStateMachineID], update is not necessary…

[_WA_Sys_00000002_68D28DBC], update is not necessary…

0 index(es)/statistic(s) have been updated, 4 did not require update.

Updating [dbo].[tbStateMachineTransition]

[PK__tbStateM__BE865E646E24342D], update is not necessary…

[_WA_Sys_00000003_6BAEFA67], update is not necessary…

[_WA_Sys_00000002_6BAEFA67], update is not necessary…

[_WA_Sys_00000004_6BAEFA67], update is not necessary…

0 index(es)/statistic(s) have been updated, 4 did not require update.

Updating [dbo].[tbStateMachineEventTransitionLog]

[PK__tbStateM__F57BD2D7B31942C0], update is not necessary…

[_WA_Sys_00000007_6D9742D9], update is not necessary…

[_WA_Sys_00000006_6D9742D9], update is not necessary…

[_WA_Sys_00000005_6D9742D9], update is not necessary…

[_WA_Sys_00000003_6D9742D9], update is not necessary…

[_WA_Sys_00000002_6D9742D9], update is not necessary…

0 index(es)/statistic(s) have been updated, 6 did not require update.

Updating [dbo].[tbNotificationEvent]

[PK__tbNotifi__2BA9DFBCF7B7A053], update is not necessary…

[_WA_Sys_00000004_7167D3BD], update is not necessary…

[_WA_Sys_00000003_7167D3BD] has been updated…

[_WA_Sys_00000002_7167D3BD], update is not necessary…

1 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbDeadDeployment]

[PK__tbDeadDe__5EF8D717A7C9E041], update is not necessary…

[nc1DeadDeployment], update is not necessary…

[nc2DeadDeployment], update is not necessary…

[nc3DeadDeployment] has been updated…

[_WA_Sys_00000012_71D1E811] has been updated…

[_WA_Sys_0000000F_71D1E811] has been updated…

[_WA_Sys_0000000D_71D1E811] has been updated…

[_WA_Sys_0000000C_71D1E811] has been updated…

[_WA_Sys_00000003_71D1E811] has been updated…

6 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbChangeTracking]

[c0ChangeTracking], update is not necessary…

[PK__tbChange__DD60B2101F76BE63] has been updated…

1 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbDynamicCategory]

[PK_DynamicCategory], update is not necessary…

[Unique_DynamicCategory_Name_Type], update is not necessary…

[IX_dbDynamicInventoryItem_Name], update is not necessary…

0 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbFlattenedRevisionInCategory]

[PK__tbFlatte__152170531F10F32F], update is not necessary…

[nc1FlattenedRevisionInCategory], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [sys].[queue_messages_1977058079]

[queue_clustered_index], update is not necessary…

[queue_secondary_index], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbServerSyncResult]

[PK__tbServer__54173E1B10FEBD02], update is not necessary…

[nc1ServerSyncResult], update is not necessary…

[nc2tbServerSyncResult], update is not necessary…

0 index(es)/statistic(s) have been updated, 3 did not require update.

Updating [dbo].[tbEventMessageTemplate]

[PK__tbEventM__24626EC313DE5327], update is not necessary…

[_WA_Sys_00000003_7775B2CE], update is not necessary…

[_WA_Sys_00000002_7775B2CE] has been updated…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [sys].[queue_messages_2009058193]

[queue_clustered_index], update is not necessary…

[queue_secondary_index], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbPreComputedLocalizedProperty]

[PK__tbPreCom__5FF1DDB6B93642F9] has been updated…

[nc1PreComputedLocalizedProperty], update is not necessary…

[ncPreComputedLocalizedProperty_RevisionID_ShortLanguage] has been updated…

[_WA_Sys_00000002_7908F585] has been updated…

[_WA_Sys_00000005_7908F585] has been updated…

[_WA_Sys_00000004_7908F585] has been updated…

[_WA_Sys_00000003_7908F585] has been updated…

6 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbEventInstance]

[PK__tbEventI__94C75A07EDACEB28], update is not necessary…

[nc3EventInstanceConstraint], update is not necessary…

[nc2EventInstance], update is not necessary…

[nc4EventInstance], update is not necessary…

[ncEventInstance_ComputerID_EventNamespaceID_EventID], update is not necessary…

[nc_EventNamespaceID_EventID], update is not necessary…

[_WA_Sys_0000000D_795DFB40] has been updated…

[_WA_Sys_00000002_795DFB40] has been updated…

[_WA_Sys_00000005_795DFB40] has been updated…

[_WA_Sys_00000004_795DFB40] has been updated…

4 index(es)/statistic(s) have been updated, 6 did not require update.

Updating [dbo].[tbRevisionLanguage]

[PK__tbRevisi__1F2266A9267FE531], update is not necessary…

[nc1RevisionLanguage], update is not necessary…

[_WA_Sys_00000003_797309D9] has been updated…

1 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbConfigurationB]

[PK__tbConfig__95AA539B7095AC47] has been updated…

[_WA_Sys_00000003_7A3223E8] has been updated…

[_WA_Sys_00000002_7A3223E8] has been updated…

3 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [sys].[queue_messages_2041058307]

[queue_clustered_index], update is not necessary…

[queue_secondary_index], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbPrecomputedCategoryLocalizedProperty]

[PK__tbPrecom__2DD8E6FD2944FFFA] has been updated…

[_WA_Sys_00000002_7AF13DF7] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [sys].[filestream_tombstone_2073058421]

[FSTSClusIdx], update is not necessary…

[FSTSNCIdx], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbEvent]

[PK__tbEvent__24626EC372C56C94] has been updated…

[_WA_Sys_00000002_7C3A67EB] has been updated…

[_WA_Sys_00000004_7C3A67EB], update is not necessary…

2 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbProperty]

[PK__tbProper__B4B1E3F17DCC3DA2] has been updated…

[nc1Property] has been updated…

[nc2Property] has been updated…

[_WA_Sys_00000005_7C4F7684] has been updated…

[_WA_Sys_00000006_7C4F7684] has been updated…

[_WA_Sys_0000000B_7C4F7684] has been updated…

[_WA_Sys_00000013_7C4F7684] has been updated…

[_WA_Sys_00000002_7C4F7684] has been updated…

[_WA_Sys_00000015_7C4F7684] has been updated…

[_WA_Sys_00000012_7C4F7684] has been updated…

[_WA_Sys_00000004_7C4F7684] has been updated…

[_WA_Sys_00000003_7C4F7684] has been updated…

12 index(es)/statistic(s) have been updated, 0 did not require update.

Updating [sys].[syscommittab]

[ci_commit_ts], update is not necessary…

[si_xdes_id], update is not necessary…

0 index(es)/statistic(s) have been updated, 2 did not require update.

Updating [dbo].[tbMapping_Target_DynamicCategory]

[PK__tbMappin__90B4D91DC468146D], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbAutoDeploymentRule]

[PK__tbAutoDe__3214EC27FB99FF98], update is not necessary…

[_WA_Sys_00000002_7CD98669] has been updated…

[_WA_Sys_00000003_7CD98669] has been updated…

2 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [sys].[filetable_updates_2105058535]

[FFtUpdateIdx], update is not necessary…

0 index(es)/statistic(s) have been updated, 1 did not require update.

Updating [dbo].[tbEventSource]

[PK__tbEventS__DF51BBD6DB0CB83D] has been updated…

[_WA_Sys_00000002_7F16D496] has been updated…

2 index(es)/statistic(s) have been updated, 0 did not require update.

Statistics for all tables have been updated.

Done updating statistics.2018-07-06 09:54:52.173

Piping Heaven/Piping Hell – Considines, Ennis.  Fridays from 4:30

Piping Heaven/Piping Hell – Considines, Ennis. Fridays from 4:30

Every Friday afternoon from 4:30, Blackie O’Connell and Cyril O’Donoghue along with a guest piper host this great session for and by pipers. Easily accessible by road, rail or bus, this session is a must on your list of activities. If you are a piper, you will be made most welcome.

Get your session featured. Email info@ceol.fm

In IT, How to avoid losing focus and motivation

When working in IT I find it is so easy to lose focus and lose motivation.  I am trying to work smarter and more consistently at the moment.  Therefore, I am targeting my priorities.  To do this, I am using a project tool and a to do list tool to help with this.  My personal choice is Planner and To Do in Office365 but that is not important. However, I will give a very brief reason why I am using these tools at the end.

So, why am I afraid of losing focus and losing motivation?

It is simple. So many things lead me down a rabbit whole.  Tasks that seem straightforward lead to sub tasks and before I know it, an entire hour is gone.

Take a simple example from this morning.  Someone asked me to look into group membership on Friday.  This group is automatically populated in active directory but it contains users that have left but whose accounts are still in the directory with a disabled state. Microsoft Planner in Office365 now uses this group so these old members are getting in the way of the active users.

So here is what happened:

  • I first went into azure active directory to search for the group.  However, it was not there.
  • I vaguely remember creating this group in Teams a few years ago. So I looked in Teams.  Sure enough.  The group is there.
  • However, the group in teams is made from a static list of users. That list was derived from a group membership but that group membership is the afore mentioned static group.
  • So back to Azure active directory I go to create a new dynamic group. The requirement is simple.  The criteria is based on department name and account status.
  • However, this does not update right away. It takes time for Azure active directory to run the dynamic group rule. So I wait and go on to something else.
  • Some time later, I check to find that I have somehow chosen the wrong clause in the department field. I mistakenly choose “Does not contain” instead of “Contains”. So I edit the group to make that change.
  • While in Azure active directory, I find that I cannot set focus to the edit fields any more. I will research that on my own time tonight. The work around now is to change out of the virtual PC cursor in Jaws and just use system focus. It is annoying but it is usable.  So, I add that to my to do list for when I put the children to bed later.  Speaking of to do lists, I mark off the to do item reminding me to fix the group membership.  Now I add another to do item for the creation of the dynamic group.  Because I want to be able to look back at the end of the day and acknowledge that the previous task lead to something more complicated and time consuming.
  • Now the group is populated correctly. So I go back to Teams, remove all the users from the team that was previously statically populated then populate that team with the new dynamic group I’ve created in Azure active directory.

All of this stuff takes time. So to the next part.  Why does this lead to the fear of reduced motivation?  Again, it is quite simple.  When so many tasks in IT lead to other tasks, even the smallest things can result in hours of work.  It is like finding that every time you need to put a screw into a plank of wood, you must first create the screw yourself by hand. In the dark. While it is raining. And you have given yourself 5 minutes because who needs a day to put screws into a plank of wood?

Here is my answer to this.

I use Outlook, Planner and To do because they link in in a really seamless and powerful way.  Here is an example:

  • I come in on a Monday morning after a great weekend. Last week is a distant memory.
  • I Open Teams and it shows me my pending tasks. These pending tasks are pulled from Planner, Outlook and to do items I have written directly during meetings etc.
  • There is a to do item there automatically created for me by an Email I received during the weekend. IN the Email it said something like attention required so To do used the subject of that Email and created a to do item.  I swipe up and that is now added to my to do list for today.
  • I go through Emails that I received on Friday while I was on leave and create a few more to do items. A few of them are for today so again, I swipe up and add them to my today list.
  • There is a project in Planner that someone else needs my input on so a task has been assigned to me. That has also appeared in my pending list.  The due date is today so I am going to put that into my today list as well.
  • I now switch to my today list and everything is there waiting for me.
  • As I complete something, I hear a satisfying tone and the item is marked as complete. It still stays on my today view though as a completed item. This gives me a sense of progress throughout the day as I hit that done button on more and more of the items.

Therefore, even though I may fall into that rabbit whole of connected tasks from time to time, I can still emerge from it with a better awareness of what I have achieved.  Prior to more efficiently self-managing my day to day task list, I often left work with a sense of bitterness with the perception of not achieving something tangible that day.  This is the biggest cause for me personally of reduced motivation.  However, when I can look back and remind myself that many small tasks were completed, that helps me stay motivated for the next day.

My video setup

I’ve been testing a lot with getting different audio and video from the iPhone and the iPad. This very short video shows you what I’m currently using for mobile video capture.

My aims:

  • Accessibility. The iPhone camera does a lot if not all of the focus, colour balance, colour correction etc automatically. Of course when Emma is recording video, she can use Filmic pro to set all this stuff manually.
  • Easy to use. The Gimbal really helps me to make sure the phone is straight. It also slows down my hand motions to make the phone movements more aceptable to people watching the video.
  • The 18mm lens. This increases the field of view in the video so if I’m not quite pointing the phone in the right direction, the extra viewing angle will help.

This video was shot on an iPhone and it was edited on an iPad. I’m also uploading the video using WordPress on the iPad.

Podcast: Audio comparason of microphones connected to an iPad. With a surprise.

This was an interesting trial but it has been a very complicated one as well.

Here’s what was tested:

  •  Shure MV88+
  • Zoom H6 with stereo microphone
  • Zoom H6 with OM3 attached
  • Presonus Studiolive 16 mixter with OM3 microphone.

Audio demonstration of the Shure MV88+ Microphone.

Listen to a demonstration of the Shure MV88+ microphone connected to an iPhone. This is a short recording but it should give you enough to go on if you want to compare the sound with other alternatives on the market. I choose this microphone for it’s portability and versatility. The sound was obviously incredibly important to me and stereo recording was something I have been looking out for.

The process of recording and editing audio on IOS devices is actually very smooth. But the WordPress app then causes things to become a little more bumpy. There is no support from within the app for browsing to audio. So it is necessary to save the audio to the file system using ferrite then upload it from there to WordPress. This isn’t obvious at the start as WordPress actually shows in the share sheet and lets you create a post. You will forgive me therefore when I Naively thought then that the audio was uploading along with the post. It certainly seemed that way.

In a future post, I aim to fully detail the process of recording, editing then publishing audio using IOS devices. It’s not as complicated as. You might think.

 

| Open Player in New Window

Audio review of editing audio with Ferrite on the iPad.

IN this recording, you can hear me editing audio using the Ferrite app on the iPad. this interface is very well thought out and quite efficient. Improvements would be great but in it’s current state, it’s very usable and accessible.

This also includes a demonstration of the Shure MV88+ microphone.

You can read more about Ferrite here.

IPad as main computer on the go. – Note taking, tracking and productivity.

Vincent in the comments has asked me to go through some of the methods I use to stay productive and to take notes.

So, let’s go through a few high level points first.

  • Firstly, productivity doesn’t come from a tool, it comes from a mineset. All the apps in the world won’t help your productivity if you don’t have that drive to get things done.
  • Vincent wanted me to explain how I move notes between the iPad and my Windows PC. I’ll address this later.
  • Taking notes is great of course, but keep track of to do items is really what is key here.

I have tried using OneNote, the Microsoft app that is probably one of the best out there for taking and organizing notes but I have found the accessibility of this app lacking on both IOS and Windows. The complexity of the features means that it is necessary to have a rather complex note taking area so this doesn’t seem to play well with screen readers. Jaws and Voiceover get into a spin when they see a file that can be opened and a drawing that can be modified in the same edit area as text. Not that I would be using the drawing functionality, but you get the idea.

So the app that I use for note taking is the native IOS app. This connects through Office365 so that I can read the notes in Outlook on my PC.

I also use the Microsoft To do app to keep track of my upcoming and in progress tasks. I have both apps opening side by side. When I hit the notes app icon that I’ve added to my dock, both apps open. Moving between apps is incredibly straight forward. There’s really nothing to it.

Sorry if this post seems a bit short but this is note taking and to do tracking at it’s best. It’s efficient, fast and simple. It requires no considerable thought and when I want it, the functionality is there and reliable.

IPad as main computer on the go. – Why an iPad?

A question I have been asked is the same question I would have asked a few years ago.

Why are you using an iPad when you don’t need the larger screen size?

This is a valid question. Or, it was until a short while ago.

IPad verses iPhone

IOS is still just IOS regardless of the device your using really isn’t it? That would be a no. IOS on the iPad has diverged and will probably continue to diverge in future versions. The widgets view on the home screen is the tip of the wedge in a raft of iPad specific features. Of course, picture in picture and snap view have been around for a while and the file browser has made leaps in advancement on both iPhone and iPad form factors in IOS 13 but overall, there have been more tablet related features released in IOS13 than any previous version. With the emergence of the iPad pro keyboard and that increased use of a traditional input method on modern devices has lead developers to add much more support for keyboard commands than has tipically been found in IOS. Also, the iPad that I am using has a fantastic 1tb of storage and the sound out of the four speakers is much stronger and cleaner than on the iPhone.

App layout differences

Apps have more screen space on the iPad and compared to just three years ago, the issue of seeking icons by sliding your finger around the screen has been massively reduced as app developers have become much better at more effectively using the additional screen realestate.

There are apps that are better on the iPad. Ferrite for audio editing has more space for controls and LumaFusion really takes advantage of the extra space. Luma fusion isn’t the easiest to use with Voiceover, but it’s possible with some work. Something more standard is Outlook. I like that the message list is shown on the left and the content of the message is on the right. It takes some getting used to but you can take advantage of that extra screen space on the iPad when using it with Voiceover.

Concluding soon

I will come to the end of these posts soon. So here’s a quick run down of what I’ve explored so far:

I’ll shortly cover the topics of audio and video editing using the iPad.

Blog Archive