- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Re: FNMS Custom Attribute -Validate against User table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
FNMS Custom Attribute -Validate against User table
Anyone have an approach/solution for validating that a person name (or ID) entered in a custom attribute is an active user in the User table?
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi K_Ritter,
For your custom field, have you thought about using a drop-down list that is populated by values from the 'Login' column in the [FNMSCompliance].[ComplianceOperator] table?
Creating an additional custom field as a Drop-Down List (UIFieldTypeID=8) is documented in the FNMS "System Reference" document. The more interesting part is updating the options to be displayed when data in the [ComplianceOperator] table change.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
It's a possibility. The problem is the dropdown list would need to be populated with thousands of names. Keeping it up to date as people come and go will be a bit if a challenge as well. I've got an idea which I was going to try for another attribute. If that works out, I could use it here. It would simplify things if FNMS had a lookup attribute that would pull from an existing table - such as the User table.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
I think that attempting to create a Custom Field and maintaining it with a list of every UserID is not something that can realistically be maintained and would not be scalable.
I think that at present, the best you can do is to create a custom 'Audit Report' that lists all of the current values entered into this Custom Field and then compare this to the list of active Users. For FNMS On-Premises, this would be possible in SQL, and for FNMS Cloud would be a bit more of a manual process.
