Notification

Icon
Error

What exactly is Software: Changes in the last 24 hours reporting on? - Confusion around blanket date change on all software installed on one endpoint

Posted: Friday, March 27, 2020 10:20:21 PM(UTC)
jg@tsr

jg@tsr

Member Original PosterPosts: 1
2
Like
I have an endpoint (W10pro) that popped up on our "Software: Changes is the last 24 hours" report. It listed all of the software installed on that workstation. The Installdate column is accurate, although LastChanged is showing 03/27/2020 @ 08:02:22am. At first glance, I figured this was due to MS updates, although 3rd party applications are also showing the same "LastChanged" time stamp.

Contacting that user and then remoting in to the workstation to verify, there was no history of updates for MS or 3rd party apps at that time. The only thing the user did was turn their workstation on around that time.

What exactly qualifies as LastChanged? No other workstation is reporting this behavior today, although Last 7 days shows similar behavior in other workstations. Does this somehow coincide with a user turning on or restarting their workstation? If so, what is the intended purpose/importance of this report?

At first glance, and not being well versed enough in SQL to dissect the report in the editor, I would think this report alerts to changes in software such as updates, installs, uninstalls; you know, things an admin would want to know in relation to what may trigger an investigation into a user not adhering to approved software guidelines and such.
anpatterson03
#1anpatterson03 Member Posts: 27  
posted: 4/2/2020 4:45:14 PM(UTC)
I am wondering the same thing. Something in the way that report pulls data in the last version or two has changed. I get that report emailed to me daily for review and it used to be a couple hundred changes from various updates and such. Now it's 10,000+ changes every day.
MCBowman
#2MCBowman Member Posts: 1  
posted: 6/11/2020 8:24:04 PM(UTC)
Has there been any solution to this issue? My "Software Changes in the last 24 hours" reports 94,000+ lines for a few hundred endpoints. There are many duplicates showing no difference in the software/version/install dates/change dates. Looking at my test system, it has 1536 lines, showing the same version of software being "removed" and "reinstalled" about two dozen or so times. Below is an example of just one application:

Quote:
Software: Changes in the last 24 hours(1-250/1536)Display:
AssetName Domain UserName UserDomain Type IPAddress IPLocation Manufacturer Model OS SP Lasttried Lastseen +/- Software Version Publisher Installdate LastChanged
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 11/12/2018 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 11/12/2018 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 05/28/2019 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 04/07/2020 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 11/12/2018 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 02/04/2020 06/11/2020 10:12:33
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/11/2020 06/11/2020 10:12:33
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 04/07/2020 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 05/28/2019 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 11/12/2018 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 11/12/2018 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 05/28/2019 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 - Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 05/28/2019 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21
SandboxLaptop MyDomain Marc.Bowman MyDomain Windows 192.168.1.18 MyOffice Lenovo ThinkPad T560 Win 10 0 06/11/2020 14:23:29 06/11/2020 14:23:29 + Windows Installer Clean Up 3.00.00.0000 Microsoft Corporation 06/10/2020 16:59:21


The software was not changed yesterday at all. I don't remember when this started happening, but I think it was late 2019 (I keep up-to-date on all new versions).

Any ideas?
Brandon
#3Brandon Member Posts: 15  
posted: 7/6/2020 7:43:01 PM(UTC)
I am seeing similar results in this report as well. I really wish someone would explain it.
Agert
#4Agert Member Posts: 3  
posted: 7/13/2020 4:19:40 PM(UTC)
I finally took some time to try and fix this myself. I had to create a relationship link from tblSoftware > tblSoftwareHist for field softID
This resolved issue as previously it was pulling all software from a machine on changes instead of just changed software
Brandon
#5Brandon Member Posts: 15  
posted: 7/13/2020 4:39:43 PM(UTC)
Could you please share how we can make the edit? I'm not to familiar with SQL, but I would like to make this report work correctly.
Agert
#6Agert Member Posts: 3  
posted: 7/13/2020 4:50:49 PM(UTC)
Originally Posted by: Brandon Go to Quoted Post
Could you please share how we can make the edit? I'm not to familiar with SQL, but I would like to make this report work correctly.


Pull up the
Software: Changes in the last 24 hours report.
Then on left menu select edit report.

Then in the report editor find the tblsoftware table and softid field uptop. Click field and drag to make link to tblsoftwarehis table softid field.

save an run

Brandon
#7Brandon Member Posts: 15  
posted: 7/13/2020 5:15:52 PM(UTC)
Originally Posted by: Agert Go to Quoted Post
Originally Posted by: Brandon Go to Quoted Post
Could you please share how we can make the edit? I'm not to familiar with SQL, but I would like to make this report work correctly.


Pull up the
Software: Changes in the last 24 hours report.
Then on left menu select edit report.

Then in the report editor find the tblsoftware table and softid field uptop. Click field and drag to make link to tblsoftwarehis table softid field.

save an run



Thanks! Now that report is actually useful. I'll have to make the same change in the 7 day report as well. have you let lansweeper know about this?
Agert
#8Agert Member Posts: 3  
posted: 7/13/2020 7:10:31 PM(UTC)
Yes I let support know.

They stated
Quote:
We adjusted the bulk of the built-in reports in v8.0 in order to have information displayed in a more uniform way. Unfortunately, there are indeed some issues (e.g. incorrect and/or missing joins) with some of these changed reports, including the 'Software: Changes in the last 24 hours' and 'Software: Changes in the last 7 days' reports. We will revert all these changes in an upcoming update and revise the reports again at a later stage


FrankSc
#9FrankSc Member Administration Posts: 43  
posted: 7/14/2020 6:51:19 PM(UTC)
Hello,

As an extra note to the last remark, you can also pick the report queries from the report library (https://www.lansweeper.com/report/). Copying the query from there and use that in your Lansweeper installation should give you also the correct report(s).
All built-in reports can be found on that link with the correct query.

Active Discussions

Lansweeper snmp trap HP 1910 switch
by  info   Go to last post Go to first unread
Last post: Today at 11:52:17 AM(UTC)
Lansweeper Lsagent cloud relay changes the scanserver value
by  ghelpdesk  
Go to last post Go to first unread
Last post: Today at 2:45:11 AM(UTC)
Lansweeper Is there a chance to get the firewall off via Lansweeper?
by  RedWood   Go to last post Go to first unread
Last post: Yesterday at 11:23:31 PM(UTC)
Lansweeper Not working Wake on Lan
by  RedWood  
Go to last post Go to first unread
Last post: Yesterday at 11:17:33 PM(UTC)
Lansweeper Wake on Lan Issues
by  RedWood   Go to last post Go to first unread
Last post: Yesterday at 11:06:12 PM(UTC)
Lansweeper New Web Interface
by  anpatterson03  
Go to last post Go to first unread
Last post: Yesterday at 10:05:19 PM(UTC)
Lansweeper LsAgent failing - Lansweeper SSL Expired
by  nlertn-PRE   Go to last post Go to first unread
Last post: Yesterday at 9:34:12 PM(UTC)
Lansweeper Outgoing help desk mail
by  KeithBecker  
Go to last post Go to first unread
Last post: Yesterday at 6:03:27 PM(UTC)