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 Launch PowerShell remote PSSession
by  Ian   Go to last post Go to first unread
Last post: 8/9/2019 12:07:41 PM(UTC)
Lansweeper lspush smtp direct send
by  Danilo Ferrari  
Go to last post Go to first unread
Last post: 8/1/2019 1:39:26 PM(UTC)
Action Delete old user profiles
by  DaveDischord   Go to last post Go to first unread
Last post: 7/30/2019 6:18:28 PM(UTC)
Lansweeper Best way to delete multiple registries
by  Corcos  
Go to last post Go to first unread
Last post: 7/25/2019 8:18:23 PM(UTC)
Lansweeper Infopath installer help
by  Dave Ward   Go to last post Go to first unread
Last post: 7/23/2019 3:11:38 PM(UTC)
Lansweeper Top 10 Ticket Types Year To Date
by  LGuth  
Go to last post Go to first unread
Last post: 7/10/2019 8:37:48 PM(UTC)
Lansweeper Fonts
by  Spectrum   Go to last post Go to first unread
Last post: 6/25/2019 11:24:19 AM(UTC)
Action Powershell script for WOL on VLAN
by  psmail  
Go to last post Go to first unread
Last post: 5/30/2019 12:00:43 AM(UTC)