Re: Default Queries

From: David James [MSFT] (djam_at_online.microsoft.com)
Date: 12/08/04

  • Next message: David James [MSFT]: "Re: PC name apears several times in collection after upgrade to SP1" 
    Date: Tue, 7 Dec 2004 23:29:21 -0800

    The default "All Systems Collection" and "All Systems Query" return the
    exact same results. Both are capable of returning records with duplicate
    machine names. But they both would return the exact same results. Is it
    possible that someone changed your default collection / queries?

    Below are the defaults. (Notice, they both return everything from
    sms_r_system)

    Default "All Systems Collection"
        select * from sms_r_system

    Default "All Systems Query"
        select Name, SMSAssignedSites, IPAddresses, IPSubnets,
    OperatingSystemNameandVersion, ResourceDomainORWorkgroup,
    LastLogonUserDomain, LastLogonUserName, SMSUniqueIdentifier, ResourceId,
    ResourceType, NetbiosName from sms_r_system 

    -- 
Thanks,
David James [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"steiners" <steiners@discussions.microsoft.com> wrote in message 
news:439020EC-68D8-4A15-BE71-15F780BD8151@microsoft.com...
> Can anyone shed some light on the built in Queries? When my support staff
> runs a querie on all systems. The querie pulls mahines several times. I 
> guess
> what I'm trying to say is it lists duplicate computer names when running
> queries.
> Now if you look at the collections and run update on all systems in the
> collection it doesn't list duplicates.
>
> Can anyone make sense of this for me? Learning as I go.
>
> Thanks!
  • Next message: David James [MSFT]: "Re: PC name apears several times in collection after upgrade to SP1"

    Relevant Pages

    • Re: Default Queries
      ... If you have reimaged some of your machines, you could be seeing duplicate ... > Can anyone shed some light on the built in Queries? ... > what I'm trying to say is it lists duplicate computer names when running ...
      (microsoft.public.sms.misc)
    • Re: OGL in an alternate reality (was Re: GSL)
      ... exact same thing, thereby drawing their customers away from them. ... apparently be able to duplicate all the 4e ideas as long as you didn't ... Create a round board game with the same number of squares as ... are protected from copyright laws. ...
      (rec.games.frp.dnd)
    • Re: Bulk Update To Db Tables
      ... above that have lots of duplicate entries. ... I guess the Update Query would do the trick? ... As to whether to use append or update queries, ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Bulk Update To Db Tables
      ... above that have lots of duplicate entries. ... I guess the Update Query would do the trick? ... As to whether to use append or update queries, ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Bulk Update To Db Tables
      ... above that have lots of duplicate entries. ... I guess the Update Query would do the trick? ... As to whether to use append or update queries, it depends on whether you are ...
      (microsoft.public.access.tablesdbdesign)