I have a mysql query that produces a number that constantly grows.
| mysqlquery spec=Casper_Splunk query="select cg.computer_group_name, count(c.computer_id)
from computer_groups cg
inner join computer_group_memberships cgm
on cg.computer_group_id = cgm.computer_group_id
inner join computers c
on cgm.computer_id = c.computer_id
where cg.is_smart_group = 1
and computer_group_name = 'Encrypted Computers';"
How would I create a radial gauge report that grows along with it? Thanks
well I kind of figured this out by adding | gauge count(c.computer_id) 1 5 10
well I kind of figured this out by adding | gauge count(c.computer_id) 1 5 10