Sep 20, 2011· One of my customers asked me to build this example query and I figured I would share with everyone, not just one company. it can be handy when you are doing OS Deployment testing and you need to look up a machine based on its MAC address to delete it so it becomes an "unknown computer" again.
Dec 04, 2017· SCCM - get all User Name with Machine Name . submitted 1 year ago by maxcoder88. Hi There, I am using SCCM 2012 R2. My question is : is it possible to get all username logged in or last logged in with their Machine name, if possible as well as Mac Address, ip Address etc. ? ... This is my query that grabs machine name, last login, mac address ...
Apr 29, 2015· Summary: Using SCCM to query the ConfigMgr database to find which clients a particular user had logged in to. Issue: A customer wanted to know a history of which clients on their estate a particular user had logged into in the last couple of days and cross reference their results from Active Directory against the…
Aug 07, 2007· SMS/SCCM, Beyond Application Deployment is a blog by Matthew Hudson covering SMS 2003, SCCM 2007, 2012 and beyond package deployment. Here you will find hints, tips, and tricks to help with managing your infrastructure. It will focus mainly on Reg files, Batch, VbScript, WMI, and possibly other methods.
Related Posts. Clean up your WSUS database for better performance and SCCM software update compliance; SCCM Configmgr collection SQL identify duplicate computer records with different GUID
Aug 11, 2017· Check if Specific Hotfix installed on a Collection – SCCM Posted by Shashi Bhushan on Aug 11, 2017 in SCCM, SQL Recently we got a request from our Platform Team whether we can fetch any report from System Center Configuration Manager to check if specific Hotfixes installed on all the servers managed by them.
Creating collection to get computers that starts and end with particular string is used mostly using % .If this percentile used at the end of the variable name, you get all computer names that starts from particular string and if you use this in the beginning, gets all computers that ends with particular string.
Feb 10, 2012· SQL Query To Retrieve Advanced Clients Assigned Site Code And Client Version This SQL Query will allow you to list the assigned site code and client version numbers for your advanced client resources. SQL Query: Select SD.Name0 'Machine Name', SC.SMS_Assigned_Sites0 'Assigned Site', SD.Client_Version0 Version From v_R_System SD Join v_RA_System_SmsAssignedSites SC …
I am often asked for primary users of some collection. But the people asking want full User's Names and not the username. I have this query but it is getting me all computers and I need to limit it to certain collections. Any tips on how to modify this or modify the Hardware 03A to give me Full User Name and Device? Here is my query
All SCCM client computers with greater than 50 GB free disk space on C: SELECT ... Return machine name, serial, and AD container. SELECT a.Name0 AS[Name], b.SerialNumber0 AS[Serial], c.System_Container_Name0 ... Use this query to create collections for your various computer models. SELECT DISTINCT a.Name0, b.Manufacturer0,
May 16, 2018· This configuration manager report is considered one of the top reports as it helps remove duplicate records, and filter orphan records based on last time seen online. Provided also the SQL query powering this report, along with some tips to help you add more information.
SCCM 2012 – List of SQL queries Posted on May 23, 2015 by Karthick J in SQL Queries // 5 Comments I have included a list of sql queries that we frequently use in SCCM 2012.
SCCM Query Per Computer Name. TheMessican. 04/23/2013 36548 views. Systems Management Microsoft System Center Configuration Manager ... MACHINE.NAME AS SYSTEM_NAME FROM MACHINE WHERE (MACHINE.NAME like 'sys-bsc%') ORDER BY SYSTEM_NAME. Answered 04/23/2013 by: SMal.tmcc. All Answers.
Jan 26, 2015· The second but the bigger problem is it will not display the name as "SQL server 2008" rather it will give the output something like "10.0.1600.22" The work around for the above issue is to run the below query in the database. The below query can be used to find the number of machines with the specific application.
Aug 21, 2010· SCCM Query – All Computers with a specific program install. SCCM Query – All Computers with a specific program install. Saturday, 21 August 2010; Server Side Tips; The following SCCM collection query can be used to list all computers with a particular application and version installed. ... (select distinct SMS_G_System_COMPUTER_SYSTEM.Name
You can use the below SQL query to create a new collection based on GUID. 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.SMBIOSGUID = "18764D56-C91F-83A5-51FB-4AD4B6699D04 "Replace the GUID with the one that you intend to delete.
Sep 20, 2011· One of my customers asked me to build this example query and I figured I would share with everyone, not just one company. it can be handy when you are doing OS Deployment testing and you need to look up a machine based on its MAC address to delete it so it becomes an "unknown computer" again.
Oct 03, 2018· Hi all, I just want to know sccm 2012 device collection query for Computer name with first two or three letter. I tried below, it is not working with computer name start with SRD
Apr 24, 2013· SQL Query to find machine information in SCCM April 24, 2013 The below query provides the hostname,AD SITE Name,Username,Client version,creation date,Operating System of a SCCM client installed machine. select Name0 AS 'HostName', AD_Site_Name0 AS 'AD Site Name', User_Name0 as 'User Name', Client_Version0 as
How do I build an SCCM collection based on a letter in the computer name? Lets say the the names are PROSERVD01, PROSERVP01, PROSERVS01 I would like the query to check the letter at the third position from the right (D,P,S) and display only machines that match a certain letter.