Tag: Microsoft

sql2016

SCCM – Hardware and Client Version SQL Query

If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together. SELECT S.Name0 as Name, S.Client_Version0 as [Cient Version], OS.Caption0 as [Operating System], CS.Manufacturer0 as Manufacturer, CS.Model0 as Model, PB.SMBIOSBIOSVersion0 as BIOS, PR.Name0 as CPU,
Continue reading
Promotional graphic for a Windows Updates Stuck on Shut Down or Reboot Fix, featuring a computer screen with a rocket graphic and relevant symbols.

Video Demo – Windows Updates Stuck on Shut Down or Reboot Fix

We also have written guides for the different versions of Windows available here: Windows 10 Windows 7 Windows 7 Alternative Method Feedback We would love to hear your feedback on whether any of these methods helped you at all. If they have, please feel free to go ahead and leave us a message below using
Continue reading
microsoft black logo

SCCM – Differences between Add Remove Programs Database Tables

We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought we would post a quick reference here to confirm which table of data means what. There are five different tables of data available to you
Continue reading
microsoft power bi 600x315

Power BI – Refresh data every working hour

If you are using Power BI and a personal gateway, you may want to ensure that your report data is updated regularly during working hours. Power BI is an excellent tool that can be utilised in many ways including the power bi jira combination as an effective solution for specialists dealing with numerous administrative tasks. To learn
Continue reading
sccm logo 600x400

SCCM Deployment Time Bug

Some time ago there was a bug within SCCM where when you deployed an application, you had to change the deployment date back a day to make it work. This seemed to have been fixed when moving over to current branch but this issue has raised it’s head again. This will cause clients trying to
Continue reading
3 2

Windows 10 1709 – RSAT Missing DNS Fix

If you have recently upgraded to Windows 10 Fall Creators Update and you use Remote Server Administration Tools (RSAT), then you may have noticed that the DNS console is missing from the list of available consoles. This seems to be a fault on Microsoft‘s side and I’m sure that they will release an update soon,
Continue reading