
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2015 11:01 AM
Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName, tblAssets.Domain,
tsysOS.OSname As [OS Version],
tblAssets.IPAddress,
tblSqlServers.displayVersion As [MS-SQL Version],
tblSqlServers.skuName As [MS-SQL Edition],
tblSqlServers.spLevel As SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.Image As icon
From tblAssets
Inner Join tblSqlServers On tblSqlServers.AssetID = tblAssets.AssetID
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSqlServers.skuName Not Like 'Express%' And
tblSqlServers.skuName Not Like '%Internal%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.Domain
tblAssets.AssetName, tblAssets.Domain,
tsysOS.OSname As [OS Version],
tblAssets.IPAddress,
tblSqlServers.displayVersion As [MS-SQL Version],
tblSqlServers.skuName As [MS-SQL Edition],
tblSqlServers.spLevel As SP,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.Image As icon
From tblAssets
Inner Join tblSqlServers On tblSqlServers.AssetID = tblAssets.AssetID
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSqlServers.skuName Not Like 'Express%' And
tblSqlServers.skuName Not Like '%Internal%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblAssets.Domain
Thanks,
Jim Lovejoy
__________________________________________________________________________________________________
James W. Lovejoy | IBM - Cloud Managed Services Delivery | Infrastructure Architect (Windows Server ...
Labels:
- Labels:
-
Finished Reports
-
Report Center
0 REPLIES 0
