I know that I can use the performance tile with sparklines set in order to have a line graph with the current value to the right – but is there any way to just have the current value displayed as a scalar value in a tile?
So far as I can see there isn’t an alternative way to do it.
you could create a task in SCOM and call that task from Squared Up.
With custom labeling you could use if / else and then print the arrows via Unicode:
Are you looking for a specific perf counter? Let me know if you need 🙂
I would use the SQL Scalar tile and try a query to pull the most recent entry from the DB
Here is a query I’ve edited from Kevin Holmans source: https://kevinholman.com/2016/11/11/scom-sql-queries/
select top 1 SampleValue
from PerformanceDataAllView pdv with (NOLOCK)
inner join PerformanceCounterView pcv on pdv.performancesourceinternalid = pcv.performancesourceinternalid
inner join BaseManagedEntity bme on pcv.ManagedEntityId = bme.BaseManagedEntityId
where path = ‘server’ AND
objectname = ‘LogicalDisk’ AND
countername = ‘Free Megabytes’
order by timesampled DESC
Depending on how you want to use it, you could add it to a perspective.