Modify DBCC SQLPERF (LOGSPACE) to display certain fields

[pho01]

Running DBCC SQLPERF (LOGSPACE) returns something like

Database Name Log Size (MB) Log Space Used (%) Status ----------------------- ------------------------ ------------------------ ----------- Northwind 0.9921875 41.338581 0 msdb 0.7421875 42.763157 0 pubs 0.7421875 51.907894 0 tempdb 0.4921875 47.281124 0 model 0.7421875 35.065788 0 master 1.2421875 40.841194 0

How can I modify this query to only display Database Name and Log Space Used (%) fields? SQL server is running on windows so the format of the results are not lined up correctly, so i need to cut it down to display only two fields.

Database Name Log Space Used (%)
----------------------------------
Northwind 41.338581
pubs 51.907894
tempdb 47.281124
model 35.065788
master 40.841194

Thanks!

 

[xlbo]

How exactly is this connected to MS Reporting Services ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question