Power shell. Working with CSV’s like you would a database table.

Feb 26, 2020 | , , ,

One of the features I most love about Power shell is it’s ability to let you work with a CSV file just as if it was a database table. Assuming your columns have names at the top of the file, you can select specific items, filter using where and even join them. Here’s a quick example:

$UserToRestore = Import-CSV c:\ps\Azure\AllAzureADUsers.csv | select UserPrincipalName, ObjectId | where UserPrincipalName -eq $EmailAddress
$NewUserPrincipalName = $UserToRestore.UserPrincipalName.Replace('Domain.TLD','SubDomain.onmicrosoft.com')
Restore-MsolUser -ObjectId $UserToRestore.ObjectId -AutoReconcileProxyConflicts -NewUserPrincipalName $NewUserPrincipalName

This is just so useful.

Delete all users and groups from azure Active Directory. Using Power shell.

Feb 25, 2020 | , ,

I don’t know why you would want to do this. Maybe your boss is being a pain in the rear and you feel like getting back at the world.  This may not be a good idea.  There’s a good chance this may make you rather unpopular around the office and could seriously impact your employment prospects in the future.  But who am I to judge.  Sometimes there’s a perfectly rational reason why you need to delete every user and group from Azure active directory.  So here goes.  Do it with just four lines of code.  I’m not giving you the command to connect because if you don’t know that, you certainly shouldn’t be doing the next part.

# Delete users. First download a CSV. Then delete them.
Get-AzureADUser -All $true | Export-Csv AllAzureADUsers.csv
Import-CSV AllAzureADUsers.csv | Foreach-Object { Remove-AzureADUser -ObjectId $_.UserPrincipalName }

#delete groups. First download a CSV of the groups then delete them.
Get-AzureADGroup -All $true | Export-Csv AllAzureADGroups.csv
Import-CSV AllAzureADGroups.csv | Foreach-Object { Remove-AzureADGroup -ObjectId $_.ObjectId }

Restore deleted users from Azure active directory

Okay. So you’ve deleted everyone but now you need to restore them again because you’ve decided you value your job after all.
This code restores the users but it restores them with a new UPN. This is really useful as if you’ve re-used that custom domain in another subscription for example, you can’t restore the users that were previously deleted using the same UserPrincipalName. OF course, if that’s not relevant just delete that part from the code.

Import-CSV c:\ps\Azure\AllAzureADUsers.csv | Foreach-Object {
$NewUserPrincipalName = $_.UserPrincipalName.Replace('domain.tld','SubDomain.onmicrosoft.com')
Restore-MsolUser -ObjectId $_.ObjectId -AutoReconcileProxyConflicts -NewUserPrincipalName $NewUserPrincipalName
}

You will notice, I’m re-using the CSV created when deleting the users earlier.

Retiring Nama. AKA Mr. Banks. My previous guide dog.

Feb 24, 2020 | , ,

Many of you have read this blog throughout the entire journey with Mr. Banks. AKA Nama.  I’m calling him both names as funny enough, some people that read this blog from the very first time I matched with my previous guide dog still refer to him as Mr. Banks.  I’ve spent some time over the past week reading over those old posts.   This has caused me to feel happy, sad, proud and anxious.  If you want a recap, I’ll add the links below.

I had never set out to document in such detail the rough outline of the working life of a dog in terms of the beginning trials and successes and the pride and sorrow of the end. But here it is. This post isn’t a sad post though. Stick with me for a moment and I’ll explain.

First, let me give you a bit of a history lesson. My first dog Freddie retired back in 2010.  I wrote a rather long post about that back then.  I also wrote a post about going back to visit Freddie after three months of his retirement had passed.

So it’s not my first time going through this process.  Interestingly, it’s very similar but also very different to the first time I retired a guide dog.

I retired Nama on Saturday 22nd February 2020 at 3:58 PM to a lovely couple Sarah Jane and David.  They came to the house for a while and we went on a quick walk so that I could show them that although Nama is now a pet and can be treated as such, he has also been a really exceptional working dog.   AS I said to them on Saturday, be warned.  If he can walk me around busy cities and complicated campuses with ease, he may use that energy now that he doesn’t have to work any more toward less innocent tasks.  Such as opening bags, getting into places he should be near etc.  Nama was a brilliant worker, but he has his own personality.  HE’s funny, playful, dedicated, loyal, giddy but most of all, he’s mischievous.

It struck me when retiring my first guide dog Freddie and it strikes me again when retiring Nama. That seven to eight year period of the partnership with a guide dog can be a time of massive change.  With Freddie, I moved house about a dozen times. I graduated from college then started full time work.  This time with Nama, we lived in the one house but we had other massive changes.   It all started with getting married in 2012.  Then in 2013 Méabh was born.  In 2015, Rían was born.  My grand mother died in 2015 as well.  I also moved job to take up work with Dublin City University.  We spent a month in Spain, we travelled to France and we had numerous trips to England.  When Nama joined our family in 2012, it was just Emma and I.  When he left on Saturday, we had children around us.

I created a video to show just some of the great work that Nama has done. This covers a bus, train and Luas as well as shopping centres, quiet roads and busy streets. It also highlights the relationship he had with my children as well.

Nama was actually in the delivery room when both my son and my daughter were born.  He has enabled me to do a lot. But this video will give you a better sense of this than a lengthy blog post.

I’m going to miss Nama.  So too will Emma, my wife and my children Rían and Méabh.   But we are very fortunate to have him in our family for so long.

Software update synchronisation failure. The single most annoying thing about SCCM.

Feb 21, 2020 | , ,

It’s a normal Friday morning so you look at the SCCM update deployments to make sure everything is running as expected but instead of getting the all clear, you find that synchronisation has encountered an error.

most likely this error is nothing to worry about. Every Month Windows sends out updates with new license agreements so the process runs something like this:

  1.  SCCM asks WSUS to synchronise updates.
  2. WSUS does what it’s told.
  3. SCCM tells WSUS to accept updates in particular categories.
  4. WSUS tells SCCM that it cant accept everything as there are updates where license agreements must be accepted first.
  5. SCCM throws it’s toys out of it’s pram because it’s not correctly handling the state from WSUS.
  6. WSUS is fine with this and leaves the updates ready to be accepted.
  7. SCCM grumbles loudly in WSync.log but checks again in 60 minutes.
  8. During the next check, it notices that there are updates with pending license agreements from the last synchronisation.
  9. It accepts these updates.
  10. But wait. there are now supplemental updates that also require that license agreements are accepted.
  11. Steps 7, 8 and 9 are run again, causing more errors in the WSync log.

This is infuriating and a complete waste of time.  And it’s the way sccm has done this since 2007.

But wait. there’s a way around it. 

No. there isn’t. 

All you can do really is either wait for the next synchronisation or go synchronise manually.  So dear reader, if you really want to waste more of your time, please follow this document. Because although you know that things are probably fine, you should still verify that this is the cause of the synchronisation failure. Because the one time you take it for granted that this is the cause is the one time something else has gone wrong and you’re left looking rather silly for not checking.

How do I check for synchronisation errors?

You should probably open SCCM.

  1.  Move to the monitoring work space available at the bottom left of the SCCM window.
  2. Move to “Software Update Point Synchronisation Status”
  3. Look at the status of the latest synchronisation on the right.  Illustrated in the following screen shot.
  4. The text you will see is something like:
    Microsoft Update 4097 17/05/2019 10:12:00 Failed 0X80131500 17/05/2019 10:09:00
    The error extracted from this is:
    Failed 0X80131500
  5. Expand System Status on the left.
  6. Now click on Site status.
  7. Right click on Software Update Point
  8. Expand Show messages then click Errors.
  9. In the drop down, select “Last 12 hours”
  10. You will see the error shown by the synchronisation service. In this screen shot you will also see other errors relating to MDM but please ignore those for the moment, that’s for another day and a larger cup of coffee.
  11. I don’t like screen shots so here’s some text showing the error that is shown above.
    Severity Type Site code Date / Time System Component Message ID Description
    Error Milestone DCU 17/05/2019 10:12:54 SCCM-VM-01.AD.DCU.IE SMS_WSUS_SYNC_MANAGER 6703 WSUS Synchronization failed. Message: Failed to sync some of the updates. Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.SyncUpdates.
  12. Now open windows explorer using your administrative account and browse to the following directory: Yes. Use your admin account. Surely the account your logged into Windows with isn’t the account you use for administering the network? If it is, please give yourself a bit of a kick.
    \\SCCMServer\{DriveOfSCCMInstallation}\Microsoft Configuration Manager\Logs
  13. Open the WSync.log file.  You’ll see lots of red near the bottom.
    little tip, if you’re ever coding something. never use colour to exclusively relay meaning. It’s completely ineffective for people like me who can’t see the screen.

That’s about it.  You can either re-synchronise the updates again or just wait… and wait… and wait… for the updates to finish synchronising using the automated schedule of ever 1 hour and hope for the best.

To manually synchronise, do the following:

  1.  Open SCCM.
  2. Move to the Software library work space.
  3. Expand Software updates
  4. Now right click All Software Updates.
  5. Click Synchronise all software updates in the context menu that is shown.

Optimise WSUS database for sCCM

Feb 20, 2020 | , , ,

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

Feb 3, 2020 | , ,

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

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

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

Feb 3, 2020 | , ,

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

Feb 3, 2020 | , ,

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

Jan 29, 2020 | , , , ,

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.