→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Tomas
Engaged Sweeper III
Is it possible to have a report show the total windows asset count per month?
4 REPLIES 4
Esben_D
Lansweeper Employee
Lansweeper Employee
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
Engaged Sweeper III
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
Engaged Sweeper III
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
Lansweeper Employee
Lansweeper Employee
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