Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Timbo
Engaged Sweeper

Hi.

I do hope someone here can help me, as we now need to get an email report on all new detected hardware on our moitored networks, but for some reason I get 2-3 emails with same data, and sometimes the "new" assets is old and known assets, but they simply just show up.

This makes the report useless, as monitoring team only need to act on new hardware/assets, and not already known hardware.

I've been looking around in the community, and found several articles stating issue from 7.1.x versions, but none from our current version 12.4.0.1. I am not sure how old the Lansweeper installation and database is, but some of the known assets I have seen, is no older than 12-18 months.

 The email report is launched every 15 minutes, and for some reason I now get the same newly discovered (old and known) item in 3 emails at 15 m, 30 m and 45 m, before it stops telling me this is a new device. The same goes for new devices that is correctly detected.

Then at some point, I get a "new" known asset indicated as new, even if also known for a couple of years.

So all in all, thje report is not giving the correct details.

In my email report I have requested that it uses the following - with a few other details, but all based on the Report: Device: New devices found in the last 24 hours.

Where tblAssets.Firstseen > GetDate() - 0.1249998 And tblAssetCustom.State = 1

Original line contained " GetDate () -1 " - somewhere I found that I should use "0.0416666" but then I had the data in 4 or 5 emails.

I would like to

1. Only get new devices/assets in 1 email sent everry 15 minutes, unless empty (last part is working)

2. Only get devices in 1 e-mail - not in 2 or 3 emails in a row.

2 REPLIES 2
Jacob_H
Lansweeper Employee
Lansweeper Employee

wow - i didn't know you could do GetDate in that format lol. Like David said, yeah put in the ticket and do the gatherlog thingie -  but...  i'm curious... in the report, put the assetID field in again but name it something else so it shows up on the actual email/report...   like this:   tblassets.assetid AS [blablabla]  -  i'm really curious as to if the asset is indeed the same asset with the same assetID or if its some other assetID.  Could you share the entire SQL report just to make sure something else isn't weird in it?

DavidPK
Lansweeper Tech Support
Lansweeper Tech Support

We would like to take a closer look at the issue you have documented.

 

Our tech support team should be able to assist you with this.  Please open a ticket in our support portal.

 

Make sure to add screenshots and the GatherLogs output file so our SME's can start investigating the issue straight away. 

 

Using the GatherLogs tool.