Top Equipments




Popular searches

SCCM - Query/Collection by MSI Installed - Vertigion

22-02-2012· SCCM – Query/Collection by MSI Installed VertigoRay / February 22, 2012 / Uncategorized / 0 comments Most of the time, when adding an SCCM Collection based on installed software, I’ll simply use the Add/Remove Programs Attribute Class However, in a recent case, the installed software doesn’t show up in Add/Remove Programs, but it is an MSI installer...

Know More

Venu Singireddy's blog: SCCM collection query computer name

27-03-2014· SCCM collection query computer name The following WQL query will add the machines to a collection based on their naming conventions This query is useful if we want to add only some machines to a collection using WQL query based on the computer starting names (ABC-XXXX) or machines named using business unit (HR-XXXXXX)...

Know More

Collection query to find Machines--based on GUID Criteria

05-06-2013· You can use the below SQL query to create a new collection based on GUID select SMS_R_SYSTEMResourceID,SMS_R_SYSTEMResourceType,SMS_R_SYSTEMName,SMS_R_SYSTEMSMSUniqueIdentifier,SMS_R_SYSTEMResourceDomainORWorkgroup,SMS_R_SYSTEMClient from SMS_R_System where SMS_R_SystemSMBIOSGUID = "18764D56-C91F-83A5-51FB-4AD4B6699D04 "Replace the GUID with the one that you intend to delete...

Know More

SOLVED - Find user name and computer name in SCCM | SCCM ,

10-02-2021· Hi, one of colleague working with me installed the right click tools on sccm server When right click on the user name I can get the computer name used by the user So this is sufficient for me You can use powershell scirpt on sccm , so you can view user nae and computer at a same time....

Know More

SCCM - get all User Name with Machine Name : SCCM

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 ,...

Know More

Solved: How do I build an SCCM collection based on a ,

24-02-2009· I am trying to create collections based on the machine nam 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 Any help will be greatly appreciated...

Know More

SQL Query to find machine information in SCCM

24-04-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...

Know More

SCCM and WMI Query to Find All Laptops and Desktops ,

24-03-2016· SCCM and WMI Query to Find All Laptops and Desktops To install special software on all portable devices of the company it was necessary to build an SCCM collection, which would include all laptops (an other portable mobile systems) in a corporate network...

Know More

CREATE COLLECTION BASED ON NAME OF DEVICE

11-03-2016· CREATE COLLECTION BASED ON NAME OF DEVICE To create a collection by computer name first go to Assets and compliance then device collection and right click create new collection Give the collections and name and limited it to the machine type If you want to copy the query statement just change the highlighted red text...

Know More

SCCM SQL query to get the Machine Name and IP address ,

24-02-2014· Any one can helpt me to get the SCCM SQL query for getting the Machine Name and IP address based on collection Monday, February 24, 2014 3:27 PM Answers text/html 2/24/2014 3:43:24 PM Prabha G 0 0 Sign in to vote Check these Pls You will get the solution...

Know More

Venu Singireddy's blog: SCCM collection query computer name

27-03-2014· SCCM collection query computer name The following WQL query will add the machines to a collection based on their naming conventions This query is useful if we want to add only some machines to a collection using WQL query based on the computer starting names (ABC-XXXX) or machines named using business unit (HR-XXXXXX)...

Know More

Solved: SCCM Query for systems with a specific File Name ,

15-01-2010· I need to build a query that will show me systems that have a specific file of a specific version The query below gets me all systems with that specific file select SMS_G_System_COMPUTER_SYST EMName, SMS_G_System_SoftwareFile FilePath, SMS_G_System_SoftwareFile CreationDa te, SMS_G_System_SoftwareFile...

Know More

SCCM and WMI Query to Find All Laptops and Desktops ,

24-03-2016· SCCM and WMI Query to Find All Laptops and Desktops To install special software on all portable devices of the company it was necessary to build an SCCM collection, which would include all laptops (an other portable mobile systems) in a corporate network...

Know More

Solved: How do I build an SCCM collection based on a ,

24-02-2009· I am trying to create collections based on the machine nam 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 Any help will be greatly appreciated...

Know More

SCCM SQL query to get machines with user id, name, email ,

SCCM SQL query to get machines with user id, name, email, last logon Hello Friends, Good evening and how are you? Today someone asked me to create one SQL query to get the machine details like hostname, IP Address, RAM, total HDD size, Free Space, Manufacturer, Model, Last Heartbeat, Users name, email ID, Last logged on user name...

Know More

SCCM Query – All Computers with a specific program install

21-08-2010· SCCM Query – All Computers with a specific program install Saturday, 21 August 2010 by Adrian Gordon Last updated: , (select distinct SMS_G_System_COMPUTER_SYSTEMName from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEMResourceID = SMS_R_SystemResourceId...

Know More

SCCM SQL query to get machines with user id, name, email ,

SCCM SQL query to get machines with user id, name, email, last logon Hello Friends, Good evening and how are you? Today someone asked me to create one SQL query to get the machine details like hostname, IP Address, RAM, total HDD size, Free Space, Manufacturer, Model, Last Heartbeat, Users name, email ID, Last logged on user name...

Know More

Queries for Boundary,Boundary Groups and Devices info ,

24-05-2017· Query Devices,IP Address and IP Subnet per Device select distinct AName0 as 'PC Name',cIPAddress0 as 'IP Address',DIP_Subnets0 as 'IP Subnet' from v_R_System A inner join v_FullCollectionMembership B on AResourceID=BResourceID Inner join v_GS_NETWORK_ADAPTER_CONFIGUR C ON AResourceID=CResourceID Inner Join ,...

Know More

Query computers to find a specific file - SMS/SCCM, Beyond ,

07-08-2007· Query computers to find a specific file First you will need to make sure that turn on the file inventory, not File collection (we don't want to copy all those files into SMS) A sample is shown to the left Be sure to exclude the Windows directory at the least Once a SW inventory has run you will be able to pull this informaiton...

Know More

Configuration Manager – Find virtual machines – CTGlobal

Configuration Manager – Find virtual machin Keeping track of the the virtual machines can be a little pain Here is a query and a report that hopefully will make it a bit easier to keep track of those virtual machines and their corresponding physical hosts...

Know More

Queries for Boundary,Boundary Groups and Devices info ,

24-05-2017· Query Devices,IP Address and IP Subnet per Device select distinct AName0 as 'PC Name',cIPAddress0 as 'IP Address',DIP_Subnets0 as 'IP Subnet' from v_R_System A inner join v_FullCollectionMembership B on AResourceID=BResourceID Inner join v_GS_NETWORK_ADAPTER_CONFIGUR C ON AResourceID=CResourceID Inner Join ,...

Know More

SCCM collection/Report Duplicate computer names with ,

17-10-2012· add these computer names to collection (you will find many ways to add these computers to collection ) and do a delete special so all these duplicate and original machines will be removed from SCCM DB but not worrithe computers that are online /Live will send DDR soon to SCCM DB ...

Know More

SCCM and WMI Query to Find All Laptops and Desktops ,

24-03-2016· SCCM and WMI Query to Find All Laptops and Desktops To install special software on all portable devices of the company it was necessary to build an SCCM collection, which would include all laptops (an other portable mobile systems) in a corporate network...

Know More

Venu Singireddy's blog: SCCM collection query computer name

27-03-2014· SCCM collection query computer name The following WQL query will add the machines to a collection based on their naming conventions This query is useful if we want to add only some machines to a collection using WQL query based on the computer starting names (ABC-XXXX) or machines named using business unit (HR-XXXXXX)...

Know More

Solved: SCCM Query for systems with a specific File Name ,

15-01-2010· I need to build a query that will show me systems that have a specific file of a specific version The query below gets me all systems with that specific file select SMS_G_System_COMPUTER_SYST EMName, SMS_G_System_SoftwareFile FilePath, SMS_G_System_SoftwareFile CreationDa te, SMS_G_System_SoftwareFile...

Know More

SCCM Query – All Computers with a specific program install

21-08-2010· SCCM Query – All Computers with a specific program install Saturday, 21 August 2010 by Adrian Gordon Last updated: , (select distinct SMS_G_System_COMPUTER_SYSTEMName from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEMResourceID = SMS_R_SystemResourceId...

Know More

System Center Configuration Manager 2012 R2: SCCM Query ,

03-06-2017· Explore the world of system administration with System Center Configuration Manager 2012, Active Directory, Group policy, SCCM Report, SCCM collection and system security management...

Know More

Venu Singireddy's blog: SCCM Report for Machine Name MAC ,

25-09-2013· SCCM Report for Machine Name MAC Address IP Address The following SQL query provides Machine name, MAC address and IP Address ***** SELECT v_RA_System_ResourceNamResource_Names0 AS , This post provides various SQL queries to generate custom SCCM reports (07/12) for reporting purpos...

Know More

Collection query based on a machine being a member of ,

23-05-2013· Earlier today I was trying to create a collection that showed all machines that were in another collection This has to be done using a sub select query and the first one I used brought back all machines that were in a collection, based on that collection ID: select SMS_R_SYSTEMResourceID, SMS_R_SYSTEMResourceType, SMS_R_SYSTEMName, SMS_R_SYSTEMSMSUniqueIdentifier, ,...

Know More

Solved: SCCM Query for systems with a specific File Name ,

15-01-2010· I need to build a query that will show me systems that have a specific file of a specific version The query below gets me all systems with that specific file select SMS_G_System_COMPUTER_SYST EMName, SMS_G_System_SoftwareFile FilePath, SMS_G_System_SoftwareFile CreationDa te, SMS_G_System_SoftwareFile...

Know More