Make new report from Systemconfigs

[tagenalum]

I need a report showing our current hardware inventory that I can export to Excel.

The System Configuration Overview has almost everything I need, but I wanted to add some fields (and create my own new report).

However, when I try to edit the report in Report Builder, the query shows as blank.

The other reports all show the tables and the SQL that is used.

How can I get to what query is being used here?

[Hemoco]

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblComputersystem.Manufacturer, 
                      dbo.tblComputersystem.Model, CAST(dbo.web30ProcessorCapacity.NrOfProcessors AS varchar) 
                      + ' * ' + CAST(dbo.web30ProcessorCapacity.MaxClockSpeed AS varchar) + ' Mhz' AS Processor, 
                      CAST(CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) AS varchar) + ' KB' AS Memory, 
                      CAST(CAST(CAST(dbo.tblDiskdrives.Size AS bigint) / 1024 / 1024 / 1024 AS numeric) AS varchar) + ' GB' AS HDDsize
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername INNER JOIN
                      dbo.tblDiskdrives ON dbo.tblComputers.Computername = dbo.tblDiskdrives.Computername INNER JOIN
                      dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername LEFT OUTER JOIN
                      dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.Computername
WHERE     (dbo.tblComputersystem.Domainrole = '1') AND (dbo.tblDiskdrives.Caption = 'c:')
ORDER BY dbo.tblComputers.Computername