Asset Full History Report

[dmoraes]

Hi,
I am looking for a report that shows the full History of an Asset.

I need to make sure the proper software is being removed and installed and be able to show my customer a concrete report that specific items were removed/deployed.

I created the following Union between Software History and Quick Fix Engineering, but I am still missing some data.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tsysOS.OSname,
  tsysAssetTypes.AssetTypename,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblQuickFixEngineeringHist.Lastchanged As Lastchanged,
  tblQuickFixEngineeringHist.Action As Action,
  tblQuickFixEngineeringUni.Description as Desciption,
  tblQuickFixEngineeringUni.HotFixID as ID_or_Version,
  tblQuickFixEngineeringHist.InstalledOn as InstalledDate
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblQuickFixEngineeringHist On tblQuickFixEngineeringHist.AssetID =
    tblAssets.AssetID
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
    tblQuickFixEngineeringHist.QFEID
Where tblAssets.AssetID In ([ENTER LIST OF ASSET IDs HERE]) And tblQuickFixEngineeringHist.InstalledOn >
  GetDate() - 100 And tblAssetCustom.State = 1
Union
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tsysOS.OSname,
  tsysAssetTypes.AssetTypename,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareHist.Lastchanged as Lastchanged,
  tblSoftwareHist.Action as Action,
  tblSoftwareUni.softwareName as Description,
  tblSoftwareHist.softwareVersion as ID_or_Version,
  tblSoftwareHist.Installdate as InstalledDate
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblSoftwareHist On tblAssets.AssetID = tblSoftwareHist.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftwareHist.softid
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID In ([ENTER LIST OF ASSET IDs HERE]) And tblSoftwareHist.Installdate > GetDate() -
  100 And tblAssetCustom.State = 1
Order by Lastchanged desc, Action desc

Do I need to add any other History tables to the union to have a full report?

Would Lansweeper team be able provide the SQL used for the History TAB report?