Day 4 – Training with the Chief, my new guide dog.

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.

We’ve all been locked down for months now. When you say four months, it seems like a short amount of time. But when you think of it in terms of weeks, 17 weeks seems a hell of a lot longer. I started it so well! For over two months, I worked to a schedule where outdoor activities were integral to each day. But then students finished exams and project work really started to ramp up. So I stupidly got out of that habit of getting out for really long walks each day. I’ll admit it. I’ve gained weight, I’ve lost fitness and I’ve generally become a lot less physically active. So the long walks since around this time last week have really been a shock to the system. The muscles on the outsides of my lower legs beside my shin bones are sore when I walk, my hips are tired and I’m finding that after a few hours, I’m actually feeling tired. Up to the beginning of lockdown, I would have taken all of this in my stride! But I’m loving this. Monday we did 8km. Tuesday we jumped up to 13km. Wednesday we did 8 again and today we walked almost 12km. Tomorrow is probably going to be back up to 13km as the routes are quite a bit longer. It’s not that the training is that long. Training walks are usually a total of 6 or 7km but the walks afterword push it up quite a bit. Having a guide dog during lock down is the motivation I’m going to need to take proper breaks during the day and finish on time in the evening. I know this as this isn’t my first time working for long periods from home. I know that with Nama, I maintained that motivation to maintain a high level of physical activity because I knew I had that dependence that required it as well.

The chief is doing remarkably well. There are a few things I love about his work.

  • Curb approaches are so solid! He sees them as a destination where he will get a high value reward so he loves finding crossings, ramps etc.
  • The chief is brilliant at finding things. Bins, traffic light poles and shops that he has been to before. It’s like he can’t wait to show you that he’s found something.
  • Obstacle avoidance is just amazing. He shows such willingness to slow down and navigate around things. We’ve encountered some quite complex situations and he has done exceptionally well. That’s not to say everything was perfect. He brushed me off a bush yesterday and he brushed me off a bin today. But when he was corrected, he showed increased awareness to similar objects and maintained a good distance afterword.
  • Even when he encounters situations where I can let him be a little social, he’s quite quick to jump back into work mode when we resume walking.
  • He slows down just a little when one of the children are holding my hand while working.

Of course, there are a few things we need to work on.

  • There’s some sensitivity when getting the harness on first. Also, for the first minute of working, he’s a little uncomfortable but once he has a bit of a shake, he’s happy to proceed with his normal happy attitude.
  • Every day this week, he has spent on a walk. This is really not good. It’s very possible that this will work it’s self out but in the back of my mind, I have a very firm opinion about the ultimate outcome if this isn’t solved. I’m very satisfied though that with some more work and the continued establishment of a good routine that he can get past this. I’m also very fortunate that going back to work isn’t something I need to be considerate of for a long time so with all of these factors in mind, I’m not overly concerned. But I’ve had issues with dogs spending in the past and I would be lying to you if I said that I wasn’t afraid.

We’ve done so many monstrous routes in Drogheda. We’ve walked from the area of Tesco right up to the outskirts of Drogheda on the north side. This includes well known places such as the cottage hospital, over all of the bridges, down by the quays, over West street, Laurence’s street, shop street, Peter’s Street, Duke street, Stockwell street, the north road, Thomas street, the Chord road, the Donor road, Marlies lane, Duleek street, Priests lane, Mary’s street, John Paul court, Sundays gate, Ashfield and Balls grove.

Unfortunately this is going to result in a significantly shorter series of blog posts relating to training a new guide dog. Training from home is so much more relaxed, easy going and comfortable. For someone who is quite experienced with working with guide dogs, training in an area that I know very well has made the process much more approachable compared to when training in Cork. There’s an easy way to explain this. I have a really bad habit when training with a new guide dog. My right side feels really exposed and I’m not quite sure yet if I’m going to feel where the curbs are. So I hang back just a small bit so that I can be sure that I give myself an extra second. You might think this is perfectly reasonable. However, for a guide dog this is a terrible thing to do. In all situations, you must fake it until you make it. Even if you think you are about to walk off a cliff, you must trust the dog to do the job correctly but more important than that, you must show the dog that you trust it to do the job correctly. No, I’m sorry. There’s something even more important than that. You must never let the dog know that what it is doing is of critical importance so even though you might be terrified that there’s something near you that you’re about to smack your face off, you must approach it as if guiding you around this frightening and potentially dangerous object is the most fun thing in the world for the dog to do at that time. Of course, you can do this with body language and your voice. Also, every experience the dog has to this point has lead the dog to think that this kind of thing is a very positive experience so actually, once you can “Fake it until you Make it” and remain positive in your body language and voice, the cumulation of positive experience up to this point will actually do quite a lot of the work for you in making the dog think that this is such a great and fun thing to figure out. Especially with Nama, I learned that when work is fun, work is easy and enjoyable for both the dog and the handler. Nama was honestly a joy to be around. Because work for him was fun. Because work for him was fun, he did things during work that I also found a bit of fun too. For example, pulling my coat sleeves when we had been waiting on a bus for a little too long. Listening to the sniggers of people around me while Nama would pull the toggles of my rain jackets if my hand wasn’t in easy reach. Or going for coffee and someone I was with commenting that he was having a good role around under the table wagging his tail. I walked him onto a building site with impossible things to guide around and he still came out of it a happy dog. I’m not saying I have all the answers. I have only scratched the surface. One thing I’m loving about this training currently is the instructor is really interested in the technicalities of working with a guide dog and is quite happy to share some of this knowledge with me from time to time. I love learning about the technical side of working with a guide dog. The more I can understand how their minds work, how the training helps them to figure stuff out and how they become motivated to do something, the more I can help the dog by supporting him in the right way.

That’s all for tonight. I’m looking forward to tomorrow. I’m hoping my legs let me walk at a good speed, that the rain isn’t too heavy and that I don’t catch Covid-19 from being on the bus to Dublin!

If you have a comment, go on. Leave it here. Don’t leave it on twitter or Facebook. It’s much nicer to look back years from now and read what you are thinking.

Day 2 – Training with the Chief, my new guide dog.

We’re now six days in and it has been a roller-coaster with the chief. Let me start from the beginning. A lot has happened and if you stick with me for a few minutes, I think you will find it quite interesting.

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 chief arrived to my home here in Drogheda last Wednesday 15th July at about quarter past 1. He was a bundle of energy as he had just spent about three hours in a car traveling from Cork. The instructor and an apprentice came in and we sat down. For about thirty minutes we discussed the structure of the next three to four weeks and we covered some of the basics of obedience training. Of course, this is my fourth time training with a guide dog so the obedience training is something I’m very aware of however a bit of a refresher was welcome. Within what seemed to be no time at all, the instructor left and the chief was alone with me at last. Here’s the thing that’s really important that I need to explain to you. On the 15th I was launching a massive change in work to over four thousand people. So I was insanely busy. I had to fit in getting a new guide dog in with something I had been preparing for in work for over four months. So at a quarter past 2 I was back on a Zoom meeting with people and the chief was asked to independently entertain himself for a while. In fairness to him, he wasn’t any bother at all. A few times he introduced himself to the call by placing his head on my desk but overall, he was very well behaved. I finally finished up at 5pm and could then really get out and play properly with the chief. Of course, with it being such a busy day in work, I was still getting the occasional call until about 7pm but I still had plenty of time to keep the chief active and playing.

I learned very quickly that the chief loves play. A good game of tug of war really get’s him going. Like Nama, he gets very vocal during playing. He’ll growl ferociously. Unlike Nama, he also barks when pulling from side to side. I like when dogs feel comfortable to express themselves when playing. I encourage it to an extent. Playing is a great time for the dog to just have fun. It’s also the perfect time for obedience work to start. For example, the dog must sit before throwing the toy. If I say thank you or leave it, the dog must let go. If I say stay, the dog must wait until I tell him he can go. These commands are integrated into play time for maximum impact. For example. I’ll sometimes tell the chief to sit and stay. Then I’ll go to another room and loudly drop the toy. I’ll then tell him to come. This enforces the sit, stay and come commands all while he thinks that it’s great fun to find where in the house I’ve gone this time.

If you have read any of my posts about training with a new guide dog, you know that I’m going to talk about toileting. AKA spending. Spending / letting the dog relieve himself is a big part of establishing a reliable routine. Guide dogs go on command but regularity is key so that the dog isn’t asked to work when under pressure to have a wee or poo. So one of the things we try to do right away when a dog comes home for the first time is to spend. The Chief was having absolutely none of this. It took until sometime after 3pm when he finally had a wee. Luck wasn’t on my side though and unfortunately he didn’t spend in the defined dog toileting facilities. The place where the dog spends is called the run. I have a reasonably sized run a few metres outside my back door so that each dog I’ve had has a very easy place to identify. Of course, the chief is a bit of a stubborn hound so he decided that he would venture somewhere else and do it there instead. Fortunately, this hasn’t been persistent. In fact, he’s only spent outside the dog run once. Unfortunately though, he held off having a poo until about 5pm on Thursday evening! Pooing is something I’ll talk about later on. Again, there’s a few paragraphs devoted to toileting because having a reliable guide dog is really important.

As you would expect, the chief has been my shadow constantly from Wednesday to well, today! Everywhere I go, he is sure to follow. That’s fine though. It’s a good sign that he is attached to me and looks to me for reassurance. That bond is growing. He’s becoming very comfortable around me. But my good mood today hasn’t been there all along. On Saturday, he spent twice at unexpected times while out of the house. See? Spending / toileting is something that I’ll go back to from time to time. But the reason I’m mentioning it here is because unfortunately that meant that on Sunday, Saturday’s late pooing incident meant that he didn’t poo for me on Sunday morning. So I was restricted to the house until about 5pm when he finally relieved himself. He is very stubborn. I knew he needed to go so walking outside the house wasn’t an option. The stimulus of walking would have triggered a poo while we were about half way down the road so it was important I didn’t help him set a habit. So I was quite frustrated on Sunday. I was here on my own so not being able to get out even for a quick walk made me feel very restricted.

Although I was working on Thursday and Friday during normal office hours, I wasn’t as pressured so I regularly took the chief out for quick bouts of very active play time. I also began doing more structured obedience sessions. I have a standard method of ramping up the difficulty level of obedience sessions. I used it for Ike, then again with Nama so I’m using it with the chief this time as well. I start in a quiet room with no distractions. I spent some time there and make sure he listens to every command. I treat regularly and give plenty of praise. Then I move to somewhere like the kitchen. More smells and sounds here so without fail, the first few times we go in there, the obedience levels dip slightly. Each time he doesn’t do something, I walk away. Then I go back again and I try it a second time. If it doesn’t work, I completely change what I’m asking him to do. When he’s as consistent in the kitchen as he was in the first room, I bring him outside to the back garden. This ramps up the difficulty level even more. There are many more things to distract him but he starts to get the idea by now. Rewards become more interesting as well. A tiny bit of cheese, some play time and grooming out here all serve to show him that obedience is a really nice thing to do. Finally I bring him to the front garden. I use an extra long flexy lead and try commands like come, stay, heal, sit, down etc. I do this when he’s right beside me, a metre away then several metres away. Each time I reward well when he has done something right but I ignore him if he does something bad. Then I complicate things further. I wait for people passing the house or cars moving by and I ask him to comply with another command. When he does this, I go way over board with praise and a treat. Finally, I take him off the flexy lead and I do some obedience in the front garden with no lead at all. This is risky and once, it went quite badly for me but it’s in controlled environments where risks like this can begin to be taken.

On Friday 17th of July, I finished work for four entire weeks! I’m delighted! I have been storing up leave since the beginning of the year. I really need a break and this time training with a new guide dog just couldn’t come fast enough.

The instructor arrived on Monday. Since then the chief has really settled in. We walked 8km on Monday and a massive 13km today! Currently the chief is under my feet fast a sleep.

Work is such a pleasure. His curb approaches are fantastic, finding traffic light poles is a breeze to him and his right shoulder work shows that he has top class awareness. I feel so comfortable walking with him. He feels so confident and so sure of himself that I don’t feel that I need any hesitation when following him. We actually had a meeting to attend tonight. So I worked him to it. It was a route we had done earlier today with the instructor. It was so nice to arrive to that meeting as confident, assured and independent as I was back when I had Nama up until the beginning of 2020.

We have an issue with spending in the afternoon to sort out. I’ve already spoken about spending in this post and it has been quite long so I’ll explain that in more detail in the next post.

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