Asset count history

[Tomas]

Is it possible to have a report show the total windows asset count per month?

[Esben_D]

Unfortunately, assets deleted by the database cleanup options are not logged in the database.

In general, user configuration changes can be found in the built-in report: "Users: Changes made to Lansweeper configuration".

If you manually delete the assets then the action is logged and you can use the report below:

Select Top 1000000 Count(tblConfigLog.LogID) As AssetDeleteCount,
  DatePart(mm, tblConfigLog.Date) As Month,
  DatePart(yyyy, tblConfigLog.Date) As Year
From tblConfigLog
Where tblConfigLog.Description Like 'Deleted asset with name%'
Group By DatePart(mm, tblConfigLog.Date),
  DatePart(yyyy, tblConfigLog.Date),
  tblConfigLog.Description
Order By Year Desc,
  Month Desc

[Tomas]

Unfortunately, indeed. Purchasing needs a "List" of active Assets per Month for controlling our client partner. Since there are +4k clients at any given time, this hasn’t been easy.
I had setup an email report to send every 1st of the month. But these have apparently not been sent. although manually triggering the mail report worked.

Will logging deleted devices ever be implemented? I'm guessing this is not a seldom requirement.

[Tomas]

Thx, you're right, it is a start. But is it possible to get the amount of windows assets that have been removed aswell? Like a log that that dokuments the assets that have been deleted from lansweeper for inactivity?

[Esben_D]

This report should get you started. There are ways to do cumulative counts in SQL, however they are quite complex.

The report below gives you a count of the amount of new Windows assets scanned per month. The counts are based on the First Seen date in Lansweeper.

Select Top 1000000 Count(tblAssets.AssetID) As AssetCount,
  DatePart(mm, tblAssets.Firstseen) As Month,
  DatePart(yyyy, tblAssets.Firstseen) As Year
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'Windows'
Group By DatePart(mm, tblAssets.Firstseen),
  DatePart(yyyy, tblAssets.Firstseen),
  tsysAssetTypes.AssetTypename
Order By Year Desc,
  Month Desc