Converting Trends to proper value

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: Server (S)
    • None
    • Environment:
      Production

      I have a large amount of trend data from a discovery item that i changed.the multiplier from that i would like to fix.

      The new multiplier is correct as "8192" but the past data is incorrect.

      disc_prototypes.php?form=update&itemid=56610&parent_discoveryid=56609&sid=d82de8d456683ba4

      here are the items that need to be adjusted.

      itemdiscoveryid itemid parent_itemid key_ lastcheck ts_delete
      8684 56996 56977 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450955 0
      8685 56997 56977 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450955 0
      8686 56998 56977 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450955 0
      8687 56999 56977 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450955 0
      8688 57000 56977 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450955 0
      8689 57001 56977 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450955 0
      8702 57014 56981 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450959 0
      8703 57015 56981 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450959 0
      8704 57016 56981 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450959 0
      8705 57017 56981 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450959 0
      8706 57018 56981 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450959 0
      8707 57019 56981 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450959 0
      8728 57044 57027 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450945 0
      8729 57045 57027 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450945 0
      8730 57046 57027 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450945 0
      8731 57047 57027 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450945 0
      8732 57048 57027 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450945 0
      8733 57049 57027 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450945 0
      8746 57062 57031 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450949 0
      8747 57063 57031 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450949 0
      8748 57064 57031 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450949 0
      8749 57065 57031 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450949 0
      8750 57066 57031 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450949 0
      8751 57067 57031 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450949 0
      8752 57068 57031 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450949 0
      8753 57069 57031 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450949 0
      9024 57923 57567 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450959 0
      9025 57924 57567 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450959 0
      9026 57925 57567 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450959 0
      9027 57926 57567 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450959 0
      9028 57927 57567 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450959 0
      9029 57928 57567 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450959 0
      9066 57965 57654 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450968 0
      9067 57966 57654 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450968 0
      9068 57967 57654 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450968 0
      9069 57968 57654 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450968 0
      9070 57969 57654 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450968 0
      9071 57970 57654 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450968 0
      9072 57971 57654 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450968 0
      9073 57972 57654 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450968 0
      9164 58216 58104 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450937 0
      9165 58217 58104 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450937 0
      9166 58218 58104 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450937 0
      9167 58219 58104 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450937 0
      9168 58220 58104 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450937 0
      9169 58221 58104 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450937 0
      9170 58222 58104 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450937 0
      9171 58223 58104 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450937 0
      9184 58236 58020 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450914 0
      9185 58237 58020 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450914 0
      9186 58238 58020 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450914 0
      9187 58239 58020 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450914 0
      9188 58240 58020 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450914 0
      9189 58241 58020 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450914 0
      9202 58254 57493 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450927 0
      9203 58255 57493 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450927 0
      9204 58256 57493 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450927 0
      9205 58257 57493 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450927 0
      9206 58258 57493 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450927 0
      9207 58259 57493 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450927 0
      9232 58284 57754 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450948 0
      9233 58285 57754 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450948 0
      9234 58286 57754 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450948 0
      9235 58287 57754 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450948 0
      9236 58288 57754 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450948 0
      9237 58289 57754 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450948 0
      9238 58290 57754 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450948 0
      9239 58291 57754 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450948 0
      9261 58382 58299 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450953 0
      9262 58383 58299 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450953 0
      9263 58384 58299 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450953 0
      9264 58385 58299 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450953 0
      9265 58386 58299 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450953 0
      9266 58387 58299 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450953 0
      9267 58388 58299 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450953 0
      9268 58389 58299 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450953 0
      9314 58524 58395 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450933 0
      9315 58525 58395 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450933 0
      9316 58526 58395 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450933 0
      9317 58527 58395 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450933 0
      9318 58528 58395 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450933 0
      9319 58529 58395 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450933 0
      9928 59431 58999 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450933 0
      9929 59432 58999 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450933 0
      9930 59433 58999 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450933 0
      9931 59434 58999 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450933 0
      9932 59435 58999 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450933 0
      9933 59436 58999 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450933 0
      9946 59449 59121 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450935 0
      9947 59450 59121 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450935 0
      9948 59451 59121 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450935 0
      9949 59452 59121 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450935 0
      9950 59453 59121 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450935 0
      9951 59454 59121 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450935 0
      9952 59455 59121 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450935 0
      9953 59456 59121 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450935 0
      9986 59489 59333 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450928 0
      9987 59490 59333 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450928 0
      9988 59491 59333 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450928 0
      9989 59492 59333 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450928 0
      9990 59493 59333 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450928 0
      9991 59494 59333 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450928 0
      9992 59495 59333 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450928 0
      9993 59496 59333 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450928 0
      10026 59529 59196 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450932 0
      10027 59530 59196 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450932 0
      10028 59531 59196 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450932 0
      10029 59532 59196 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450932 0
      10030 59533 59196 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450932 0
      10031 59534 59196 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450932 0
      10032 59535 59196 sdr[nicrec.raw,

      {#SDR_NIC},20,30,asc] 1408450932 0
      10033 59536 59196 sdr[nicrec.raw,{#SDR_NIC}

      ,20,30,asc] 1408450932 0

            Assignee:
            Unassigned
            Reporter:
            Robert Hau
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: