All Computers Hardware report.

[saumil18]

i want to create a report which includes, Computer name,logged in User, processor, RAM, Hard Disk (total Size & free Size partition wise),IP Address,Serial number. How can i create this report.?

[nmjohns]

This report doesn't work for me. Is it possible it's outdated? Is there a working version of this?

Invalid SELECT statement. Unknown object name: "dbo.tblComputers".: Unexpected token "dbo.tblComputers" at line 0, column -1

[MikeMc]

nmjohns wrote:
This report doesn't work for me. Is it possible it's outdated? Is there a working version of this?

Invalid SELECT statement. Unknown object name: "dbo.tblComputers".: Unexpected token "dbo.tblComputers" at line 0, column -1

This report should be pretty close to the original:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblADusers.Displayname,
  tblAssets.Processor,
  tblAssets.Memory,
  tblAssets.IPAddress,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Left Join tblADusers On tblADusers.Userdomain = tblAssets.Userdomain
    And tblADusers.Username = tblAssets.Username
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName

[nmjohns]

MikeMc wrote:

nmjohns wrote:
This report doesn't work for me. Is it possible it's outdated? Is there a working version of this?

Invalid SELECT statement. Unknown object name: "dbo.tblComputers".: Unexpected token "dbo.tblComputers" at line 0, column -1

This report should be pretty close to the original:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblADusers.Displayname,
  tblAssets.Processor,
  tblAssets.Memory,
  tblAssets.IPAddress,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Left Join tblADusers On tblADusers.Userdomain = tblAssets.Userdomain
    And tblADusers.Username = tblAssets.Username
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName

Thank ya kindly!

[faccount]

Hi,

i need a report that will display the number of computer models per department so like


Marketing -> HP 7100 (26)
HP 7600 (43)

Finance -> Hp 7100 (12)
HP 7600 (17)



Etc.


maybe even better if possible break it down by like

Marketing -> HP (69) then when you click on the hp it breaks down the individual models and number of those models.


Thanks for any help

[saumil18]

Thanks, this fulfills my requirement. If we can't add the HDD size and Partition info into this report, will it be possible to add total Hard Drive Capacity of computer to include in this report?

[Hemoco]

This includes everything except Hard disk because this would create multiple rows:

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, Web40OSName.Compimage As icon,
  dbo.tblComputers.Domain, tblADusers.Displayname,
  dbo.web40ProcessorCapacity.Name As Processor, web40CorrectMemory.Memory As
  Memory, dbo.tblComputers.LastknownIP As [IP Address],
  tblComputerSystemProduct.IdentifyingNumber As [Serial number]
From dbo.tblComputers Inner Join
  dbo.tblComputersystem On dbo.tblComputers.Computername =
    dbo.tblComputersystem.Computername Inner Join
  dbo.tblOperatingsystem On dbo.tblComputers.Computername =
    dbo.tblOperatingsystem.Computername Left Outer Join
  dbo.web40ProcessorCapacity On dbo.tblComputers.Computername =
    dbo.web40ProcessorCapacity.Computername Inner Join
  dbo.web40ActiveComputers On dbo.tblComputers.Computername =
    dbo.web40ActiveComputers.Computername Inner Join
  web40CorrectMemory On web40CorrectMemory.Computername =
    dbo.tblComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
  Left Join
  tblADusers On tblADusers.Username = dbo.tblComputers.Username And
    tblADusers.Userdomain = dbo.tblComputers.Userdomain Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername
Order By dbo.tblComputers.Computername