I had a SQL table resource on a classic dashboard working in earlier versions, that would get the database sizes from the master table. Since the upgrade this no longer works however works fine in Orion Database Manager (ODBM) as well as SQL Studio. I also tried to see if t would work when put into a report - no go.
I imagine SolarWinds put some security patch in place to block this but wanted to see if anyone has found a work around for this.
The query looks like this (and works in ODBM or SQLStudio)
SELECT
database_name = DB_NAME(database_id)
, log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))
FROM sys.master_files WITH(NOWAIT)
WHERE DB_NAME(database_id) like 'solar%'
GROUP BY database_id
