Notification

Icon
Error

Unique Custom Fields

Posted: Thursday, July 18, 2019 10:09:23 PM(UTC)
anpatterson03

anpatterson03

Member Original PosterPosts: 25
0
Like
Is there any way; even in SQL which in turn flags in Lansweeper if necessary, to mark a custom field to require unique entries? We use one of the fields to enter our asset tag numbers and I'd like to know if for some reason someone is entering a duplicate asset tag.
Esben.D
#1Esben.D Member Administration Posts: 1,966  
posted: 7/19/2019 10:53:59 AM(UTC)
If it is not an option in the interface, you won't be able to do it within the database either. At least not with a simple change.


Theoretically, you could add a check, but that requires more than just your basic data manipulation or query.
Hendrik.VE
#2Hendrik.VE Member Posts: 29  
posted: 7/19/2019 11:52:35 AM(UTC)
I think it will be easier to create a report/dashboard alert that warns you when a duplicate asset tag has been entered.

Active Discussions

Lansweeper Report for Microsoft Win 7 Extended Support
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 6:46:53 PM(UTC)
Lansweeper How to make a colour coded report
by  B.Rutherford  
Go to last post Go to first unread
Last post: Yesterday at 4:27:06 PM(UTC)
Report Center All switches and the assets connected to them
by  NWSF   Go to last post Go to first unread
Last post: 12/12/2019 5:23:34 PM(UTC)
Lansweeper Report showing single asset type
by  RC62N  
Go to last post Go to first unread
Last post: 12/11/2019 10:02:41 PM(UTC)
Report Center .Net 4.5 through 4.8 report - Reg Key scanning based
by  Martin Schulz   Go to last post Go to first unread
Last post: 12/11/2019 11:55:24 AM(UTC)
Lansweeper Assets and Owner listing help
by  ssmarr5  
Go to last post Go to first unread
Last post: 12/10/2019 9:23:09 PM(UTC)
Lansweeper HPE SAS Solid State Drives failure report
by  Tommy75   Go to last post Go to first unread
Last post: 12/10/2019 8:04:05 AM(UTC)
Lansweeper Adding Owner/User information to Assets:All column report
by  ssmarr5  
Go to last post Go to first unread
Last post: 12/10/2019 12:15:01 AM(UTC)