Computer hardware and software change report

[PoWen_Cheng]

HI Everyone,

Can lansweeper use the report output to check whether the computer has hardware or software installed or changed?

For example, add 8G of memory today or replace the hard disk, or install PDF Reader software

thank you~

[PoWen_Cheng]

Hi,

Thanks for the info, I think I need you to share the report "Software: Changes in last 24 hours", thanks

[Ian_Prentice · Accepted solution]

No Problem.

Select Top (1000000) tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
Case tblSoftwareHist.Action
When '1' Then '+'
When '2' Then '-'
End As [+/-],
tblSoftwareUni.softwareName As Software,
tblSoftwareHist.softwareVersion As Version,
(Select Case tblSoftware.MsStore
When 0 Then 'Desktop app'
Else 'Microsoft Store app'
End) As 'Type',
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftwareHist.Installdate,
tblSoftwareHist.Lastchanged,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan]
From tblAssets
Inner Join tblSoftwareHist On tblAssets.AssetID = tblSoftwareHist.AssetID
Inner Join tblSoftwareUni On tblSoftwareHist.softid = tblSoftwareUni.SoftID
Inner Join tblSoftware On tblSoftwareHist.softid = tblSoftware.SoftID And
tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Where tblSoftwareHist.Lastchanged > GetDate() - 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblSoftwareHist.Lastchanged Desc,
Software

To change the time frame, just  change the GetDate() - 1 to -2 or 3 etc.....

[PoWen_Cheng]

hi Ian_Prentice, 

Thanks for your report, very helpful!

[Ian_Prentice]

There is a built in report called "Computer: Memory changes".

I also have a report named "Software: Changes in the last 24 hours", but I am not sure if that is built in or if it was created here.  If you dont have that one, I can share the SQL.