RE: How to find clients assigned but not assigned

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Henrik Zawischa (HenrikZawischa_at_discussions.microsoft.com)
Date: 08/31/04

  • Next message: SMS Newbie in the Block: "Modifying MOF file to include IE browser info such as its version," 
    Date: Tue, 31 Aug 2004 02:45:08 -0700

    How do you like this?
    select distinct Name, SMSAssignedSites, IPAddresses, IPSubnets, ADSiteName,
    OperatingSystemNameandVersion, ResourceDomainORWorkgroup,
    LastLogonUserDomain, LastLogonUserName, SMSUniqueIdentifier, ResourceId,
    ResourceType, NetbiosName from SMS_R_System where Client is NULL and
    SMSAssignedSites is not NULL

    "Dennis Fleron" wrote:

    > Hi,
    > I need to find out which clients are assiged but not installed. There is a
    > table in the SQL Collection_Members, but the ressource is not available in
    > SMS. I know how to get which client is assigened/not assigned, but I need to
    > know how to combine this with the IsClient in the Collection_Members SQL
    > tables.

  • Next message: SMS Newbie in the Block: "Modifying MOF file to include IE browser info such as its version,"

    Relevant Pages

    • Re: Dont understand what version of SQL to install
      ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
      (microsoft.public.sqlserver.setup)
    • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
      ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Oracle 10g2 LIKE operator and case-insensitive issues
      ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
      (comp.databases.oracle.server)
    • Re: Oracle 10g2 LIKE operator and case-insensitive issues
      ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
      (comp.databases.oracle.server)
    • Re: Oracle 10g2 LIKE operator and case-insensitive issues
      ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
      (comp.databases.oracle.server)