SQL Reports of Memory Total Capacity

Comments

4 comments

  • Luke Nichols

    Matthew,

    Is there a particular need for this to be a SQL report instead of a basic report? You can easily pull this info from a basic report with the "Computer Memory" field.

    1
    Comment actions Permalink
  • matthew.knight

    When I use the basic report, I get multiple systems that show as having 0KB of memory. Obviously this doesn't give me what I'm looking for so I looked to the SQL report.

    1
    Comment actions Permalink
  • Noniver Anonymous

    To avoid complicating this too much, I'd agree with Luke that a basic report is the best way to accomplish this. Just add a greater than filter as well to avoid pulling in results that don't yet have any data in that column and subsequently show 0KB.

    1
    Comment actions Permalink
  • matthew.knight

    So I didn't realize that the 0KB were telling me that those systems didn't have any information for the field. I guess I assumed that that field would appear blank if it didn't have the info yet. Thanks for your help.

    1
    Comment actions Permalink

Please sign in to leave a comment.