Making IT Happen
If you are looking for a query that will display all machines and their last logged on user, the below will do this for you without any prompts. This allows you to search on the data to find what you would like across the information provided by the query. The query below is the full code to bring back all …
SCCM – Last logged on user query – All Systems Read MoreWe have been asked on a number of occasions how to create Configuration Manager Collections for machines on x86 or x64 Windows Operating Systems. To do this, you should use the two collection queries as below: Instructions Query to create collection for x86 machines Query to create collection for x64 machines More Queries Our full range of SQL and WQL …
SCCM Query to create collection for x86 & x64 machines Read MoreIn previous blog posts I’ve put together a guide to automatically create the computer name in your OSD task sequences using MDT (see the link below..): Automatically generate computer name during SCCM OSD However, there is also a slightly more manual way of inputting your computer name during an OSD TS using a pop-up prompt. To do this, complete the …
Prompt for Computer Name during SCCM OSD Read MoreThis guide details how to add Products into the General Licence Statement to match up licence usages using Asset Intelligence. What this means is that you can then use Asset Intelligence reports to see what your corporate software licence usages are against what you actually have purchased. Instructions Open the Configuration Manager console. Go into the Asset and Compliance Workspace …
SCCM Asset Intelligence & Software Licensing Usage Read MoreUPDATE Although the below does help, the issue I had was actually with the WCF 3.0 Windows Update. It was this that messed up our MPs, having applied the MS “fix” (or reg hack quick fix as it really is) we have not had an issue since. I’ve had an issue for the last few days where my clients were …
SCCM Management Points not working – SMS Agent Host Service Read MoreIf you would like to create a report to show you the number of different Operating System’s you have, you can use this script below which should provide you with the information for Servers and the various Windows OS’s. Query SELECT CASE WHEN Caption0 LIKE ‘%XP%’ THEN ‘XP’ WHEN Caption0 LIKE ‘%Windows 7%’ THEN ‘Windows 7’ WHEN Caption0 LIKE ‘%Server …
SCCM – SQL Query for showing number of different Operating Systems Read MoreYou may have noticed when setting up task sequence deployments for your OSD‘s or when setting up packages for the Software Catalog that you cannot run the task or program directly from the distribution point as the only option is to download the files and run from the local cache. Well, there is a setting that you can change to …
Run Packages and Task Sequences directly from Distribution Point in SCCM Read MoreIf you would like to view our blog and keep up to date with all the posts, you can now use our RSS feed using the link below:TechyGeeksBlog RSS Feed
RSS Feed Read MoreWe have been building a number of collections within SCCM lately so we thought we would start to build up a reference here of various collections, some simple, some more complex. We will be adding to this when we can so make sure you come back and check for updates. Computers with certain prefixes – % being a wildcard select …
SCCM Collection Queries Read MoreOne of the perils of working in IT is that I am constantly asked by friends and family the age old question; What is the best free anti-virus software? Well, there’s plenty of free anti-virus software out there and there is not really an answer to this question – there is no “best” anti-virus software, only personal opinion! Myself, at home …
Free Anti-Virus Software Read MoreIf you are using an Exchange system and have self signed certificates, every year you will have to renew the certificate. An expired certificate may cause problems such as connectivity to web services, SMTP transport and Outlook prompting certificate security warnings which is extremely annoying for users and also can cause problems with Out of Office settings. To do this is very simple and can be done …
Renew a Self Signed Certificate on an Exchange Server 2007 Read MoreIf you have a requirement to add any Office 2010 language packs to your SCCM 2012 Software Catalog then you may find that it is not the simplest of tasks. I’ve spent some time working on different methods of doing this and although creating the packs as an application and pushing them out is fairly simple, to offer them through …
Office 2010 Language Pack Deployment in the Software Catalog for SCCM 2012 Read More
