Notification

Icon
Error

Asset Value Report - Need a report to sum asset values

Posted: Thursday, September 19, 2019 6:28:26 PM(UTC)
Terry1337

Terry1337

Member Original PosterPosts: 10
0
Like
Is there a report to sum the asset values in Lansweeper? We are looking to get a total value of IT assets for insurance purposes.
StevoCamaro
#1StevoCamaro Member Posts: 12  
posted: 9/20/2019 5:24:32 AM(UTC)
I don't know of anything like in the report section, nor are there leasing cost/term/vendor fields for a report.

Purchase date is great, but without a capital cost value, how can you calculate the annual CCA on assets???

You could edit a custom field name on the asset page, enter the purchase value, then report on the custom field.
Terry1337
#2Terry1337 Member Original PosterPosts: 10  
posted: 9/20/2019 2:53:41 PM(UTC)
Originally Posted by: StevoCamaro Go to Quoted Post
I don't know of anything like in the report section, nor are there leasing cost/term/vendor fields for a report.

Purchase date is great, but without a capital cost value, how can you calculate the annual CCA on assets???

You could edit a custom field name on the asset page, enter the purchase value, then report on the custom field.


I have been filling in the field for cost. I thought there might be a way to simply sum the cost values even though it would not be a current value of the assets. I am just looking for a value of assets in the case they would need to be replaces in a total destruction of our location.
RC62N
#3RC62N Member Posts: 433  
posted: 9/20/2019 5:31:04 PM(UTC)
I'm with StevoCamaro: I don't see a cost field on the assets. You'll need to be more specific. Did you designate one of the custom fields for cost? If not, if there definitely is a cost field, can you identify the table it's in and, hopefully, the field name? Failing that, describe the page you're filling the value in on and where it sits relative to others, or possibly include a screen-capture.
Terry1337
#4Terry1337 Member Original PosterPosts: 10  
posted: 9/20/2019 6:24:28 PM(UTC)
Originally Posted by: RC62N Go to Quoted Post
I'm with StevoCamaro: I don't see a cost field on the assets. You'll need to be more specific. Did you designate one of the custom fields for cost? If not, if there definitely is a cost field, can you identify the table it's in and, hopefully, the field name? Failing that, describe the page you're filling the value in on and where it sits relative to others, or possibly include a screen-capture.


I stand corrected. I am using the top field which probably was custom 1 under the assets right hand column. I should have noted the changes I made to the field. That said is there a way to sum the asset field field 1 or my field name cost?
RC62N
#5RC62N Member Posts: 433  
posted: 9/20/2019 7:12:29 PM(UTC)
Since the custom fields are all text (varchar), you'll need to convert to a numeric data type in order to do any math.

Normally, you aggregate things across groupings of some sort. You don't have to, of course, but for illustration purposes I'm going to do it across make and model.
Code:
Select Top 1000000
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  Count(*) AS count,
  Sum(Cast(tblAssetCustom.Custom1 As float)) As cost
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where
  tblAssetCustom.State = 1
  And IsNumeric(tblAssetCustom.Custom1) = 1
Group By
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model
The magic is in the type conversion. Instead of adding tblAssetCustom.Custom1 to your report, add Cast(tblAssetCustom.Custom1 As float). Once you've got that, you can apply the aggregate functions to it.

Active Discussions

Lansweeper Edit Work Time Enhancements
by  pipapo   Go to last post Go to first unread
Last post: Yesterday at 3:41:25 PM(UTC)
Lansweeper software authorization based on "name" AND "version"
by  deejay3670  
Go to last post Go to first unread
Last post: Yesterday at 2:53:28 PM(UTC)
Lansweeper HP Warranty scan - broken for some products
by  JérômeS   Go to last post Go to first unread
Last post: Yesterday at 2:34:13 PM(UTC)
Lansweeper Helpdesk Report for unresolved tickets
by  Walter  
Go to last post Go to first unread
Last post: Yesterday at 2:08:39 PM(UTC)
Lansweeper Certificate status & end dates
by  Antoine EVRARD   Go to last post Go to first unread
Last post: Yesterday at 1:01:37 PM(UTC)
Lansweeper Assign switch port to location map
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 5:21:54 PM(UTC)
Lansweeper Email Link back to ticket
by  TruckDriverTurnedIT   Go to last post Go to first unread
Last post: 5/26/2020 5:20:08 PM(UTC)
Lansweeper LSAgent not Scanning or Reporting all Software
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 4:15:05 PM(UTC)