3 Replies Latest reply on Oct 18, 2010 12:21 PM by pmod

    Physical memory bytes total reporting *MANY* different values

    Rookie

      Hi there —

       

      I'm running a query for a simple hw inventory. I am using the field Computer.Memory.Physical.BytesTotal

       

      The results seem to be all over the place.

       

      For just ~600 PCs, I get back 75+ different values. This obviously makes it difficult to report and visualize our hw without doing a lot of manual work.

       

      I can imagine a few reasons why the totals might be so different — video memory, OS quirks etc — but why are there so many?

       

      Is it possible to get better data?

       

      I've included a copy of the pivoted data below for reference — thanks a million!

       

       

      IntelliStation M Pro10
      10465644
      20950321
      20951403
      26198881
      31437161
      IntelliStation Z Pro2
      20960922
      Latitude E43003
      36207043
      Latitude E43104
      35940601
      35940843
      Latitude E65002
      20478401
      36207041
      Latitude E65102
      33974522
      OptiPlex 9601
      34053521
      Precision M45001
      33974521
      ThinkCentre M551
      10385641
      ThinkCentre M55p1
      31357161
      ThinkCentre M571
      20789521
      ThinkCentre M57p5
      10211601
      20697362
      20789521
      20953361
      ThinkPad R501
      10474721
      ThinkPad R521
      10387041
      ThinkPad T40080
      19885561
      19905921
      20397446
      20397601
      20745601
      25804362
      31047045
      31395204
      31395241
      31395361
      313954057
      ThinkPad T41025
      201891621
      30674921
      31330283
      ThinkPad T42p1
      10474721
      ThinkPad T439
      5144801
      10387041
      10387686
      10469601
      ThinkPad T60201
      5144121
      5226047
      10387004
      10468881
      104689251
      10469568
      15629882
      157118048
      15712442
      20872763
      209546844
      20955161
      20955324
      26197561
      31358521
      314404422
      31441081
      ThinkPad T60p1
      10468921
      ThinkPad T6179
      103037236
      15546601
      206256431
      31275245
      31439086
      ThinkPad T61p2
      10303722
      ThinkPad X20066
      19905921
      199060824
      19906121
      20233761
      203976020
      30391842
      310472017
      ThinkPad X20117
      19533807
      19533961
      30019562
      30674927
      ThinkPad X3001
      20708201
      ThinkPad X3011
      31047201
      ThinkPad X311
      10474721
      ThinkPad X321
      10474721
      ThinkPad X6047
      5144121
      10387006
      10387643
      156298811
      15630522
      208727615
      20873405
      26115641
      26116281
      31358522
      ThinkPad X6132
      5142761
      102218012
      10385641
      205437215
      31193323
      ThinkPad X61 Tablet1
      31357161