Chief among dogs. The matching visit with my next guide dog.

Back in February 2012, I embarked on a matching visit with a guide dog I nicknamed Mr. Banks.  Without trying to be negative, matching and training with a new guide dog doesn’t always reach a successful conclusion but that dog could be a better match for someone else for many reasons.  So, to be fair to everyone, I don’t give the name of the dog until I’m reasonably sure that things will work out and the dog has officially qualified as a guide dog. I’m on this journey again as of last Thursday the 9th of July 2020.  I met with a rather large golden retriever lab cross that I’ll refer to as Chief from now on.  The posts on this blog over the next while will largely reflect on the beginnings of this next partnership.

Standard disclaimer.

Training with a new guide dog is hard work.  Some days go really well.  Some days go terribly.  There will be times I think this is the best dog in the world and there will be days that I’m near the point of sending him back to the training staff in Cork.  This is no reflection on guide dogs, Irish guide dogs for the Blind of Ireland, anyone else who uses a guide dog or even the long-term viability of this new partnership.  I write this account of my training with the Chief, my latest guide dog mainly as a personal account that I can look back on but also for friends and family who enjoy getting a bit of insight into this process.  I have also heard over the years that perspective guide dog users enjoy these personal and honest accounts.  But please remember that what works for me, may not work for you.  In the unlikely event I mention something here that verges on tactics or techniques for working a guide dog please be aware that these work or may not work for my situation.  Every guide dog and handler partnership is different.  So, your situation may be entirely different.

The matching visit.

With all of that introduction and formality out of the way, let me introduce you to a guide dog that I’m fondly calling the Chief.  I met him for the first-time last Thursday.  I had two other matching visits in February.   One went terribly and one went amazingly well but the dog that was amazing since became unsuitable for various reasons.  So, I was very nervous leading up to my first meeting with the Chief.  I hardly slept a wink the night before and my fingers drummed on the seat for the entire trip from Drogheda to Cork.  I have a lot resting on this.   I love having a guide dog.  Almost everything about a guide dog is fantastic for me.  I can navigate to more places, I can more confidently and easily get to places that I know well, I enjoy the soft clicking of the paws walking beside me, I like the social attention the dog gets and I love it when the partnership just works and the dog starts to do things that are unique to my situation.  For example, both Freddie, my first dog and Nama, my third guide dog curved around me at crossings.  I don’t know exactly why but having this very natural barrier between me and the road is always very comforting.  Emma, my wife, jokes it’s because in the head of the guide dog, their thinking “This egit probably isn’t going to stop on time”.  So, let me explain why I’m giving him the nickname Chief.

Chief has a very chief type name.  But he’s the chief for other reasons as well.   He’s assertive.  When he wants you to go somewhere, he doesn’t hesitate.  He just decides then implements.  This was obvious in crowds but there was one place he did this, and it made me smile every time.  We would find a crossing and the Chief would stop.   I would tell him to find the pole and without a second’s hesitation, he would make a lunge at the pole.  I don’t know if this is the way all guide dogs now find objects, but I find it amazing!  I wonder if it looks strange.  I must ask someone during training.   Another situation where he really showed his leadership skills was when we were walking across a really wide street in Cork.  There are several streets leading off this pedestrianised area and the guide dog mobility instructor GDMI for short tole me to prompt the dog to veer left.  Once I did this, the Chief instantly decided what street we were most likely looking for and without hesitation angled himself so that we were moving toward it. When we got to our destination, we sat talking for a short while.  The Chief took no prompting.  He lay down and took the chance to take a rest.   I like his independence.   He is a very different dog to my previous guide dogs from what I could tell during the brief matching visit but I’m really looking forward to seeing what the Chief is like on and off harness.   IN a few days from now, the Chief will come to Drogheda!  The training situation is very different now with Covid-19.  Instead of going to Cork and spending time in the dedicated training centre, the training will be delivered here.  I’m delighted about this.  I’ll provide updates from time to time during this process.  So, come back again soon.

IPad as main computer on the go. – Power shell

Power shell is now one of the best tools in a system administrators toolkit.  Anything you can do in a graphical environment relating to almost every Windows role or feature, you can do using power shell.

So it would have been brilliant if I could connect to a computer using Power shell on my iPad and issue commands directly. Kind of like using SSH to connect to a Linux server.

I found a great application called winRM and it looked like it was going to do exactly what I needed.  It provides management through WinRM.  This is very secure and provides access to the event viewer, services, IIS management console etc.

However, the most important part of the app is it’s Power shell console.  Unfortunately this console is not at all accessible when using Voiceover.  You can type commands but the output is not readable.

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

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.

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.

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.

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

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

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