→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
saumil18
Engaged Sweeper
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.?
6 REPLIES 6
nmjohns
Engaged Sweeper II
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
Champion Sweeper II
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
Engaged Sweeper II
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
Engaged Sweeper
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
Engaged Sweeper
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
Lansweeper Alumni
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