edit scan report pc windows

[gnesper]

Is it possible to add the column with the CPU information so that it is automatically reported to each Windows PC scan report, without having to go into the details of each asset?

Thank you

[Jacob_H]

Hey gnesper:  You can browse/search through our report library here:  https://www.lansweeper.com/resources/report/

Here's a hardware report from my personal stash: (i removed vmware VM's but edit that as appropriate)

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblProcessor.Name,
  tblProcessor.Caption,
  tblProcessor.NumberOfCores As [#Physical Cores],
  tblProcessor.NumberOfLogicalProcessors As [#Logical Cores],
  Cast(tblAssets.Memory / 1024 As int) As [Memory in GB],
  Stuff((Select ', ' + IsNull(tblFloppy.Model, ' ') + '(' +
      IsNull(Cast(Ceiling(tblFloppy.Size / 1024 / 1024 / 1024) As varchar(30)),
      '') + 'GB)' From tblFloppy
    Where tblAssets.AssetID = tblFloppy.AssetID And tblFloppy.Size > 0
    For Xml Path('')), 1, 2, '') HDDs,
  Stuff((Select ', ' + IsNull(tblNetworkAdapter.Name, ' ') + '(' +
      IsNull(Cast(tblNetworkAdapter.Speed As varchar(30)), ' ') + ')'
    From tblNetworkAdapter
    Where tblAssets.AssetID = tblNetworkAdapter.AssetID And
      tblNetworkAdapter.Name Not Like '%virtual%' And
      tblNetworkAdapter.Name Not Like '%VPN%' And tblNetworkAdapter.Speed Like
      '1000' For Xml Path('')), 1, 2, '') NetworkAdapters2,
  Stuff((Select ', ' + IsNull(it.Caption, ' ') + '/' +
      IsNull(it.VideoModeDescription, ' ') From tblVideoController As it
    Where it.Caption Not Like '%dameware%' And it.Caption Not Like '%ConfigMgr%'
      And it.Caption Not Like '%radmin%' And it.Caption Not Like '%Hyper-V%' And
      it.Caption Not Like '%LogMeIn%' And it.AssetID = tblAssets.AssetID
    Order By it.Caption For Xml Path('')), 1, 1, '') Videocards,
  Stuff((Select ', ' + IsNull(t1.MonitorManufacturer, ' ') + ' ' +
      IsNull(t1.MonitorModel, ' ') From tblMonitor t1
    Where t1.AssetID = tblAssets.AssetID For Xml Path('')), 1, 2, '') Monitors,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetCustom.PurchaseDate,
  Case
    When tblErrors.ErrorText Is Not Null Or
      tblErrors.ErrorText != '' Then
      'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
    Else ''
  End As ScanningErrors,
  Case
    When tblErrors.ErrorText Is Not Null Or
      tblErrors.ErrorText != '' Then '#ffadad'
    Else '#ffffff'
  End As backgroundcolor,
  tblAssets.Firstseen
From tblAssets
  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
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
  Left Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
  Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
      Max(tblErrors.Teller) As ErrorID
    From tblErrors
    Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
      ScanningError.ID
  Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
  Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
      tblErrors.ErrorType
Where tblAssets.AssetID Not In (Select Distinct tblAssets.AssetID
    From tblAssets Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
      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 Inner Join tblErrors On
          tblAssets.AssetID = tblErrors.AssetID Inner Join tsysasseterrortypes
        On tblErrors.ErrorType = tsysasseterrortypes.Errortype Left Join
      tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID Left Join
      tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
    Where tblErrors.Lastchanged < GetDate() - 7 And tblState.Statename =
      'Active' And tblErrors.ErrorText Not Like 'DNS redirected to%') And
  tblAssets.Lasttried > GetDate() - 60 And tblState.Statename = 'Active' And
  tblAssetCustom.manufacturer Not Like '%VMWare%'
Order By tblAssets.Domain,
  tblAssets.AssetName

[Mister_Nobody]

You have to create own report.