Making IT Happen
Are you fed up of restarting or shutting down you computer and it then comes up with the dreaded “Configuring Windows Updates – Do Not Power Off Your Computer”? Well, there is a quick fix to get around this and allow your machine to shut down immediately. All you have to do is to open […]
If you want to use the Microsoft Updates Catalog, then you may find that you come across an error with the add-on refusing to load like this: So to fix this you sure first of all make sure that you are using Internet Explorer and not Firefox, Chrome or even Edge. Then, if it still […]
With Microsoft phasing out Windows Live Mail, to access your email you will need to use either an Internet browser via outlook.com or configure your Microsoft Outlook program. To set up your email in Outlook you will need to use the Exchange ActiveSync/Outlook.com online protocol and also know the details that you will need to […]
If you are looking for a complete archive of Firefox downloadable installers, there is an FTP site that has all of these available. Available on the site are the full executables and date back to original releases. You can view the FTP site by clicking the button below: Firefox FTP Site
Are you fed up of having to login to your Windows 10 computer everytime you boot up or restart? Well there is a simple way of turning this feature off allowing your machine to boot straight into Windows. All you have to do is follow the simple steps as per below and your machine should […]
If you are using Windows and you are receiving this error message: a required privilege is not held by client Then you can follow the guide below to fix this problem. Instructions This guide assumes that you are using Windows 10 although the process should be very similar if you are using Windows 8.1 or […]
If you have a load of stuff on your Twitter and you fancy a clear out, there is a great utility available that you can use to connect to your Twitter account and then use to delete Tweets based on selected months (or just delete all), delete all DM’s and also Favourites. All you have […]
If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query below: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like “%Microsoft Windows NT Workstation 10%” You can change the “%Microsoft Windows NT Workstation 10%” to create collections […]
If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in your organisation, you can use this SQL query below using SSRS to create a custom report: More Queries Our full range of SQL and WQL Collection queries are available here. […]
If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this WQL query: More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or […]
If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL query below: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ClientVersion != “5.00.8412.1007” Where “5.00.8412.1007” is the latest version number that you are […]
If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to “1” to create a collection of active devices.