Configuration Management - report to find the values of a picklist additional field

Configuration Management - report to find the values of a picklist additional field

This report helps to find the pick-list values in the additional fields.

First you need to find the name of the table name and the column name that holds the data by executing the following report:


SELECT Tablename,
       Columnname FROM ColumnAliases
WHERE Aliasname='Services'


Then you can retrieve the pick list values. For example: 

SELECT Value FROM UDF_PickListValues
WHERE Tablename='WorkOrder_Fields'
  AND Columnname='UDF_CHAR36'

Replace WorkOrder_Fields and UDF_CHAR36 with the values returned by the first query.


Click this link to navigate to the next report.​


        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial


                          Related Products