→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Johanas
Engaged Sweeper
Hi
We are renting pc's from a company and do get a file from them. What is the possibility to have a import function in lansweeper to get the warranties in the database.
Thanx
1 REPLY 1
Hemoco
Lansweeper Alumni
There is currently no built-in import tool. This feature is on our customer wish list, but we do not yet have a release date for it.
You will have to either manually submit the warranty info or write a script to insert it into the database. An example script can be seen below. It updates the purchase date of computer "LAN-001" to January 1st, 2012.

UPDATE tblCompCustom
SET PurchaseDate = '01/01/2012'
FROM tblCompCustom INNER JOIN
tblComputers ON tblCompCustom.Computername = tblComputers.Computername
WHERE (tblComputers.Computer = 'LAN-001')

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now