cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Server Vendor Count Report

Jump to solution

Hi,

I need to produce a report which tells me numerically how many Windows and Linux servers I have and how many of anything that is not one of those two choices.

Is there a way to get this count using the existing web based reporting or are we talking about using something more advanced like SQL reporting to achieve this?

Any help or advice would be appreciated.

Thanks,

James

Labels (1)
0 Kudos
1 Solution

OK, just do this:

  • Go back to your report and rename your Vendor column to "COUNT" (Display Name)
  • Remove Display settings: Vendor Icon (Watermark)
  • Add new [Vendor] column with all default settings
  • Now change the order of these two columns by drag-and-drop so that your [Vendor] comes first and [Count] second
  • PREVIEW > HAPPY > NEXT > NEXT > DONE > LAUGH

Alex

View solution in original post

3 Replies
  • Create simple web-based report based on Nodes ("I want to report on Node")
  • Do not specify any conditions
  • ADD TO LAYOUT
  • Go to EDIT TABLE and add Vendor column from the Node tree
  • Expand Advnaced section and select Data Agregation: "Count"
  • PREVIEW > HAPPY > SUBMIT > NEXT > NEXT > NEXT > DONE > CELEBRATE

By the way, you can see all this info even better  if you go to your "MANAGE NODES" page (/Orion/Nodes/Default.aspx) and group by "Vendor"

Hi Alex,

Thanks for that, really helpful, if only I could get the report to show the vendor name instead of the Icon I will be laughing 🙂

Cheers,

James

0 Kudos

OK, just do this:

  • Go back to your report and rename your Vendor column to "COUNT" (Display Name)
  • Remove Display settings: Vendor Icon (Watermark)
  • Add new [Vendor] column with all default settings
  • Now change the order of these two columns by drag-and-drop so that your [Vendor] comes first and [Count] second
  • PREVIEW > HAPPY > NEXT > NEXT > DONE > LAUGH

Alex

View solution in original post