Making IT Happen
I’ve been asked a lot of questions about the various ways of using queries and there are almost no limits to what you can do with a query and of course, you can then go on and use these queries for creating collections or just to supply you with the information you require. I have created some very basic queries …
Find last logged on user by NetBIOS name – SCCM Query Read MoreIf 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 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 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 MoreIf you need to find a machine for a particular user in your business using SCCM, one way you can do it is to use a custom query to find the machine that relates to the last logged on user. This means that you can run this query, it’ll prompt for a username, enter the username and it’ll then bring …
SCCM – Find system by Last Logged on User Query Read More
