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,765  
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: 18  
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 Email attachments
by  krejar   Go to last post Go to first unread
Last post: 8/15/2019 10:15:07 PM(UTC)
Lansweeper HP Printer not showing correctly
by  Fathom  
Go to last post Go to first unread
Last post: 8/15/2019 4:14:55 PM(UTC)
Lansweeper Install LsAgent on Mac
by  Jonnym   Go to last post Go to first unread
Last post: 8/14/2019 10:14:08 AM(UTC)
Lansweeper Asset State Question
by  rtaylor  
Go to last post Go to first unread
Last post: 8/13/2019 5:53:24 PM(UTC)
Lansweeper LSAgent Version
by  roberto.m  
Go to last post Go to first unread
Last post: 8/13/2019 3:33:50 PM(UTC)
Lansweeper Lansweeper and snmp v3
by  Justin5135   Go to last post Go to first unread
Last post: 8/12/2019 7:07:22 PM(UTC)
Lansweeper Hikvision CCTV Cameras SNMP scan
by  thejduk  
Go to last post Go to first unread
Last post: 8/12/2019 2:34:05 PM(UTC)