Splunk Dev

Mysql with radial gauge

solomonacquah
New Member

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

0 Karma

solomonacquah
New Member

well I kind of figured this out by adding | gauge count(c.computer_id) 1 5 10

0 Karma

solomonacquah
New Member

well I kind of figured this out by adding | gauge count(c.computer_id) 1 5 10

0 Karma
Get Updates on the Splunk Community!

Splunk APM: New Product Features + Community Office Hours Recap!

Howdy Splunk Community! Over the past few months, we’ve had a lot going on in the world of Splunk Application ...

Index This | Forward, I’m heavy; backward, I’m not. What am I?

April 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

A Guide To Cloud Migration Success

As enterprises’ rapid expansion to the cloud continues, IT leaders are continuously looking for ways to focus ...