
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2014 12:50 PM
Old name: Computer: System configuration overview (Built-in)
The report below provides an overview of the system configuration (OS, memory, c: disk size, number and type of processors, manufacturer, model, serial no) of Windows based assets
The report will only list assets that meet all of the following criteria:
The report below provides an overview of the system configuration (OS, memory, c: disk size, number and type of processors, manufacturer, model, serial no) of Windows based assets
The report will only list assets that meet all of the following criteria:
- The asset state is set to "active".
- The asset has been successfully scanned at least once.
- The asset is a Windows computer.
- The asset has a C: drive.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As nvarchar) As DiskSizeGB,
tblAssets.Lasttried,
tblAssets.Memory,
tblAssets.NrProcessors As #CPU,
tblAssets.Processor,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber As Serial,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblDiskdrives.Caption = 'c:' And tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName
Labels:
- Labels:
-
Built-In Reports
-
Report Center
0 REPLIES 0
