Assets that have Changed State in the past 24 hours

[ahedden]

I am trying to create a report that will show an asset that has had a state change within the past 24 hours. This report will be used to auto email the asset manager that an asset has changed, for example: we take an asset out of service to be recycled. The state would change from Active to Recycled. I tried to reference the tblAssts.LastChanged field, but it does not seem to update when there is a state change. Please see the code below:

Select Top 1000000 tblSystemEnclosure.SMBIOSAssetTag As [Asset Tag],
tblSystemEnclosure.SerialNumber As [Serial Number],
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblState.Statename As Status,
tblAssetCustom.Location,
tblAssets.LastChanged As [Date Changed]
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join tblState On tblAssetCustom.State = tblState.State
Where tblAssets.LastChanged >= GetDate() - 1 And tblAssets.AssetUnique
Like '%\D___-%' And tblAssetCustom.State <> 1 And
tblDiskdrives.Caption = 'c:'

[ahedden]

Has there been any talks if or when this functionality will be available? Even the old and New values being placed in the ConfigLog would be really helpful.

[Tom_P]

Although you can use the tblConfigLog table to receive a global overview of the changes to an asset, do note that the fields 'oldValue' and 'newValue' (old state, new state) are currently not filled in. As such, it is currently not possible to filter this table to specifically track the state changes of an asset.

[ahedden]

I am adding this comment for the benefit of others. I asked the Date and Time stamp question in a support ticket and this is what they responded with:

You can see what, when and who changed the asset in the table tblConfigLog. Please note that the oldValue and newValue are not always filled in.

The report below will list up all the manual changes made in your installation, once you added the report to your installation you can filter on the asset name (column Description) to see all the changes for that asset and the Date column will show you the updated timestamp. Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:
• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

select * from tblConfigLog

[ahedden]

So to clarify. When you make a state change, there is not date/time stamp change anywhere that a change was made?

[Tom_P]

Hi,

Unfortunately, Lansweeper doesn't currently keep a history of the state changes from assets. As such no report can be build to list these changes.