12-20-2023
09:39 AM
- last edited on
04-01-2024
12:33 PM
by
Mercedes_O
Hey,
We have a few Lenovo clients with only a warrentydate but no purchasedate.
I have seen some topics here that Lenovo only provide the warrentydate and no purchasedate.
I created a Lansweeper report with a calculated purchsedate for Lenovo like that:
...
Case
When tblassetcustom.Manufacturer Like '%lenovo%' Then DateAdd(YEAR, -3,
tblassetcustom.Warrantydate)
Else tblassetcustom.PurchaseDate
End As [Purchase Date calculated],
tblassetcustom.Warrantydate,
...
It helps a bit.
My question is, is it possible to do a bulk change by import direct to Lansweeper to get all Purchasedates per asset? e.g. based on a CSV file exported from excel or something like that?
Thank you and best regards
Julien
Solved! Go to Solution.
12-21-2023 08:42 AM
Hi There,
This should be possible but would require advanced SQL code for which Lansweeper does not provide support.
You can first import the CSV file in a temporary table. Then build your update query with values of the temp table. When the update is done, delete the temp table.
Final note; I would like to mention that running custom scripts to update the Lansweeper database tables is done at your own risk. As it can break your Lansweeper installation, Lansweeper cannot provide support when things go wrong.
Always make a backup of your database before making any changes.
12-21-2023 08:42 AM
Hi There,
This should be possible but would require advanced SQL code for which Lansweeper does not provide support.
You can first import the CSV file in a temporary table. Then build your update query with values of the temp table. When the update is done, delete the temp table.
Final note; I would like to mention that running custom scripts to update the Lansweeper database tables is done at your own risk. As it can break your Lansweeper installation, Lansweeper cannot provide support when things go wrong.
Always make a backup of your database before making any changes.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now