EOL for assets

[enz1ey]

It would be great if we could add an EOL period in years/months for certain asset models that would coincide with the purchase date and receive notifications when those devices are getting close to the set EOL and need replaced.

[Esben_D]

The report was just an example, theoretically, you can do the same for anything within Lansweeper. The report itself uses the current date and compares it with a set date you enter.

For the surface 3 models you can create use a custom asset field and enter the purchase date and EOL date. By creating a report which checks if the current date is equal to the EOL date, and combining it with an alert, you would be notified when a device has reached it's EOL date. You can do similar things for getting notifications when EOL is a month away or so.

I know it's not as easy as you described, because it's not built-in. But with some basic SQL knowledge you can do it.

[enz1ey]

Sorry, I guess I should've specified hardware EOL, not software. There are many ways to track the Windows EOL, but I'm looking for a way to enter a custom EOL for hardware devices.

For instance, we've deployed several models of Surface tablets. The first deployment of Surface 3 models we would like to start phasing out next year, so I could enter "60 months" as an EOL for that particular model, then generate a report showing which ones are nearing that age.

[Esben_D]

You can already do this in a way. What you can do is create a report which only displays assets which are near EOL. Then create an alert which gives back the report results. Depending on how you configure your report you can be alerted when assets are near EOL or have reached EOL.

The report below gives you an EOL overview of Windows 10 based on MS article (End of service for Home, Pro, and Pro for Workstation editions): https://support.microsoft.com/en-us/help/13853/windows-lifecycle-fact-sheet

You can create something similar report which and put alerts on it.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.Version,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When tblAssets.Version In ('1507', '1511', '1607') Then 'red'
    When GetDate() > '09/10/2018' And tblAssets.Version = '1703' Then 'red'
    When GetDate() > '09/04/2019' And tblAssets.Version = '1709' Then 'red'
    When GetDate() > '12/11/2019' And tblAssets.Version = '1803' Then 'red'
    When GetDate() > '09/09/2018' And GetDate() < '09/10/2018' And
      tblAssets.Version = '1703' Then 'green'
    When GetDate() > '09/03/2019' And GetDate() < '09/04/2019' And
      tblAssets.Version = '1709' Then 'green'
    When GetDate() > '12/10/2019' And GetDate() < '12/11/2019' And
      tblAssets.Version = '1803' Then 'green'
    Else '#008000'
  End As foregroundcolor
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
Where tsysOS.OSname = 'Win 10' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName