RE: Duplicate entries on reports

From: Morne (Morne_at_discussions.microsoft.com)
Date: 07/05/04

  • Next message: Jose Manuel García: "Re: Site Sever seems died.... Urgent" 
    Date: Mon, 5 Jul 2004 00:03:02 -0700

    Hi. The script took care of most of the duplication but have a look below and you will see that there is still duplication. I have noticed however that the ip address are different. Could this be something to do with the heartbeat setting?

    AdeleK 172.16.81.0 255.255.255.0 172.16.81.38 172.16.81.1
      Adelle 172.16.81.0 255.255.255.0 172.16.81.60 172.16.81.1
      africa-apps-01 172.16.81.0 255.255.255.0 172.16.81.3 172.16.81.1
      africa-mail-01 172.16.81.0 255.255.255.0 172.16.81.2 172.16.81.1
      africa-ts-01 172.16.81.0 255.255.255.0 172.16.81.11 172.16.81.1
      africa-ts-01 172.16.81.0 255.255.255.0 172.16.81.12 172.16.81.1
      AndrewW 172.16.81.0 255.255.255.0 172.16.81.89 172.16.81.1
      D1JYNF0JQ 172.16.81.0 255.255.255.0 172.16.81.77 172.16.81.1
      INT-PC-449 172.16.81.0 255.255.255.0 172.16.81.39 172.16.81.1
      INT-PC-476 172.16.81.0 255.255.255.0 172.16.81.64 172.16.81.1
      Nedbank 172.16.81.0 255.255.255.0 172.16.81.109 172.16.81.1
      ntb-170-509 172.16.81.0 255.255.255.0 172.16.81.32 172.16.81.1
      pc-170-pc577 172.16.81.0 255.255.255.0 172.16.81.4 172.16.81.1
      pc-170-pc577 172.16.81.0 255.255.255.0 172.16.81.52 172.16.81.1
      pc-170-pc577 172.16.81.0 255.255.255.0 172.16.81.61 172.16.81.1
      pc-170-pc577 172.16.81.0 255.255.255.0 172.16.81.87 172.16.81.1
      pc-170-pc577 172.16.81.0 255.255.255.0 172.16.81.88 172.16.81.1
      pc-170-pc577 172.16.81.0 255.255.255.0 172.16.81.92 172.16.81.1
      pc-170-pc577 172.16.81.0 255.255.255.0 172.16.81.95 172.16.81.1
      Reception4 172.16.81.0 255.255.255.0 172.16.81.34 172.16.81.1
      securico-7eb976 172.16.81.0 255.255.255.0 172.16.81.23 172.16.81.1
      securico-paauhw 172.16.81.0 255.255.255.0 172.16.81.20 172.16.81.1
      securico-qs2nvu 172.16.81.0 255.255.255.0 172.16.81.83 172.16.81.1
      securico-ygsf1k 172.16.81.0 255.255.255.0 172.16.81.24 172.16.81.1
      Sylvana 172.16.81.0 255.255.255.0 172.16.81.68 172.16.81.1
      TMOROPA 172.16.81.0 255.255.255.0 172.16.50.102 172.16.81.1
      TMOROPA 172.16.81.0 255.255.255.0 172.16.81.86 172.16.81.1
      TMOROPA 172.16.81.0 255.255.255.0 172.16.81.94 172.16.81.1

    "Mick" wrote:

    > Yep, I'm getting duplicate entries as well. Here is the SQL statement for that report,
    >
    > SELECT Distinct SYS.Name0, IPSUB.IP_Subnets0, NETW.IPSubnet0,
    > IP.IP_Addresses0, NETW.DefaultIPGateway0
    > FROM v_RA_System_IPSubnets IPSUB, v_R_System SYS, v_GS_NETWORK_ADAPTER_CONFIGUR NETW, v_RA_System_IPAddresses IP
    > WHERE SYS.ResourceID = IPSUB.ResourceID AND NETW.ResourceID = SYS.ResourceID AND
    > IP.ResourceID = IPSUB.ResourceID AND IP_Subnets0 LIKE @variable
    > Order by SYS.Name0
    >
    > The problem is created by the DISTINCT statement in addition to NULLs being present. I'm not sure why NULLs are present, or more accurately, being populated, in the v_GS_NETWORK_ADAPTER_CONFIGUR table, but here is a way to get around the problem. Add "and netw.defaultipgateway0 is not null" anywhere in the WHERE clause. I have changed that report on my site to use the following query:
    >
    > SELECT Distinct SYS.Name0, IPSUB.IP_Subnets0, NETW.IPSubnet0,
    > IP.IP_Addresses0, NETW.DefaultIPGateway0
    > FROM v_RA_System_IPSubnets IPSUB, v_R_System SYS, v_GS_NETWORK_ADAPTER_CONFIGUR NETW, v_RA_System_IPAddresses IP
    > WHERE SYS.ResourceID = IPSUB.ResourceID AND NETW.ResourceID = SYS.ResourceID AND
    > IP.ResourceID = IPSUB.ResourceID and netw.defaultipgateway0 is not null AND IP_Subnets0 LIKE @variable
    > Order by SYS.Name
    >
    > HTH
    >
    > "Morne" wrote:
    >
    > > Hi. Thanks for the reply. The report is the standard report for "all machines in a specific subnet" which is installed by default when rolling out sms 2003.
    > >
    > > "Mick" wrote:
    > >
    > > > Need a little more information. Are these custom or canned reports? What report types are you referring to? Some reports should/could produce duplicate entries.
    > > >
    > > > "Morne" wrote:
    > > >
    > > > > Hi. Any idea why I would have duplicate entries for machines on the reports and how I can get rid of them.
    > > > >
    > > > > Thanks,
    > > > >
    > > > > Morne

  • Next message: Jose Manuel García: "Re: Site Sever seems died.... Urgent"

    Relevant Pages

    • Re: Efficiency/runtime trouble - may not be Ruby-specific
      ... I'm still very much a novice - could you explain to me in simple terms ... is there a way this technique can improve this script? ... Like #1 and #5, I think - Can I really avoid floats, since I need to ... avoiding duplication is inherent. ...
      (comp.lang.ruby)
    • [HPADM] RE : [SUMMARY] duplication of standard output
      ... The general answer is to use "tee". ... duplication of standard output ... i need to duplicate standard output in a script. ... this work fine for redirection, ...
      (HP-UX-Admin)
    • Re: Is there a script I can launch to ensure computer restarts into Safe Mode?
      ... every respondent in every group can ... This prevents duplication ... which does not have the switch. ... code or with a small number of script lines. ...
      (microsoft.public.windows.server.scripting)
    • Re: RC runs stuff twice?
      ... Warren Block wrote: ... mergebase.sh script adds this line to /etc/rc.conf to prevent the ... and guess what I found at the head of my /etc/rc.conf? ...
      (comp.unix.bsd.freebsd.misc)
    • Re: Feys Haydn Returns!
      ... tomdeacon wrote: ... course - would care? ... There is needless duplication out there, but I hope there's room for Fey's Haydn, which is anything but ordinary. ...
      (rec.music.classical.recordings)