
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-28-2013 09:12 PM
I want to make a report showing the SQL Instances for all the assets with a SQL Server Role .
In V5 this information appear for each computer but I don“t know in which tables I can find the data to make a custom report.
Thank You
Ana Lia
In V5 this information appear for each computer but I don“t know in which tables I can find the data to make a custom report.
Thank You
Ana Lia
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-29-2013 08:09 PM
A sample report can be seen below.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSName,
tblAssets.SP,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblSqlServers.serviceName,
tblSqlServers.dataPath,
tblSqlServers.fileVersion,
tblSqlServers.installPath,
tblSqlServers.isWow64,
tblSqlServers.language,
tblSqlServers.skuName,
tblSqlServers.spLevel,
tblSqlServers.version,
tblSqlServers.displayVersion,
tblSqlDatabases.name,
tblSqlDatabases.dataFilesSizeKb,
tblSqlDatabases.logFilesSizeKb,
tblSqlDatabases.logFilesUsedSizeKb
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Inner Join tblSqlDatabases On tblSqlServers.sqlServerId =
tblSqlDatabases.sqlServerId
Order By tblAssets.AssetUnique,
tblSqlServers.serviceName,
tblSqlDatabases.name
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-29-2013 08:09 PM
A sample report can be seen below.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSName,
tblAssets.SP,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblSqlServers.serviceName,
tblSqlServers.dataPath,
tblSqlServers.fileVersion,
tblSqlServers.installPath,
tblSqlServers.isWow64,
tblSqlServers.language,
tblSqlServers.skuName,
tblSqlServers.spLevel,
tblSqlServers.version,
tblSqlServers.displayVersion,
tblSqlDatabases.name,
tblSqlDatabases.dataFilesSizeKb,
tblSqlDatabases.logFilesSizeKb,
tblSqlDatabases.logFilesUsedSizeKb
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSqlServers On tblAssets.AssetID = tblSqlServers.AssetID
Inner Join tblSqlDatabases On tblSqlServers.sqlServerId =
tblSqlDatabases.sqlServerId
Order By tblAssets.AssetUnique,
tblSqlServers.serviceName,
tblSqlDatabases.name
