Sorry for the vague title - hopefully this will make it more clear. I am currently implementing a custom table on a dashboard. Columns currently are listed below, with a sample output.
| Node Name | Status | CPU Load | % MEM | Volume Name | Avail. Space | % Used |
|---|
| NodeA | Up | % | % | NodeA - Physical Memory | XX | % |
| NodeA | Up | % | % | NodeA - Virtual Memory | XX | % |
| NodeA | Up | % | % | NodeA - C:\ | XX | % |
| NodeA | Up | % | % | NodeA - \ et cetera | XX | % |
| NodeB | | | | NodeB - Physical Memory... | | |
I am currently using the Dynamic Query Builder in Datasource instead of a SWQL or SQL query - I have no real experience with that. My intended goal is to list all Fixed Disks, not the Physical or Virtual Memory rows. Is there a way to filter the Volume Name column contents without writing a custom SQL query?
I'm trying to setup something similar to "I LIKE EGGS" Custom Volume Report implemented as a table, but I was unable to get the SQL code working after copying it over.