ingram59

Ran this by our consultant. He told me to use the 'netbios' instead of 'name' and it worked fine. What's puzzling is that I've ALWAYS used 'name' in the past and I've never had a problem.

I'm trying to build a collection of computers containing specific naming conventions using the 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.Name like "%osit" I use "All Systems" as the limiting collection (it has over 1,100 systems listed). When I build the collection, it returns 0 results. However when I run this query in WBEMTEST, it returns numerous entries. There are a small number of the OSIT named systems that have the client, but most don't I've tried variations on this, using: Is Like 'OSIT', Is Like '%OSIT%' Is Equal 'OSIT' The SCCM query returns 0 results in all cases. This is a NEW installation, We had a Microsoft consultant come out for a few days and all appears to be configured correctly. What am I missing? I've worked with SCCM 2003 and 2007 and have not run in to this issue with such a basic query. Thanks in advance for your assistance.

I'm needing some clarification and assistance here. I'm providing some background as well. This is my first foray in to this process, so the simpler and more thorough the explanations are, the better it will be. We're running Config. Mgr. 2007 in Mixed Mode (can't go Native at this point) in our corporate domain. We have a primary server with a SEPARATE SQL server housing the database, and no secondary servers. We also have 20 servers in our DMZ. Some are in workgroups. The rest are members of one of several AD Domains in the DMZ. There is no trusted relationship between the DMZ and our internal corporate domain, nor between the domains in the DMZ. I want to use SCCM to distribute a limited number of applications, 3 to 5, to all the DMZ servers, automating the process like we are currently doing, on our INTRANET. We will NOT need to manage mobile clients. It is strictly for automating app distribution to our DMZ servers. We want to continue using a single Configuration Manager server on our INTRANET and merely have CM Clients running on the servers in the DMZ, communicating to the INTRANET CM 2007 server. First, is there some comprehensive, yet understandable documentation that I can refer to that will assist me in this process. (required protocols, network configuration, configuration manager components needing to be installed, and WHERE the components need to reside, etc . . . ) Second, what suggestions or recommendations do you have for accomplishing this. Thanks in advance for your assistance and information

I've read prior solutions to find the "last logged in user". That's not what I need here. I'm needing to build a query in SCCM (if possible) that will show me all the computers that specific ID's have been logged in to, where I provide those user id's I DON'T simply need the Last Login information. I need to show all the machines that the users were logged in to. I don't need their login dates and times. I just need to return all the computer names for the user id's in question. Is there a way to do this using SCCM Queries? There are four id's that I'm targeting. Thanks in advance for your assistance

I've been tasked with creating a couple of queries and I'm not a SQL coder. If this can be done through the SCCM console, that would be great. I'm not sure how to build these. Query 1: List all computers where a specific user id has been logged on . Query 2: List all users who have logged in to a specific computer. Thanks is advance for the assistance.