Hello,
We are creating a user activity dashboard to monitor system activity by user. In the TaskActivity table, there is a column for Task Type (TaskActivity.TaskActivityType), but it stores a numerical value.
Does anyone know where the corresponding text description is stored to pull into a SQL dashboard data adapter?
Thank you,
Eric
You can use this code to use the numeric value returned by your SQL query to get the text value of the enum:
Dim TaskActivityTypeName As String = CType(taskActiveFromSqlNumeric, TaskActivityType).ToString()and here are all the values in a listing (I used the code above to generate this list):
Unknown = -1
RecycleApplicationServer = 10
GetDataCells = 100
GetDataCellsUsingScript = 101
GetExcelData = 102
CubeView = 110
CubeViewReport = 111
ExportCubeViewToExcel = 112
QuickView = 120
Book = 200
DataManagement = 1000
DataManagementScheduledTask = 1100
LoadAndTransformSourceData = 2000
BIBlendLoadAndTransformSourceData = 2100
DirectLoadAndTransformSourceData = 2200
RetransformSourceData = 3000
ClearStageData = 4000
PreserveStageData = 4100
RestoreStageData = 4200
ClearPreservedStageData = 4300
ValidateTransformation = 5000
ValidateIntersections = 6000
LoadCube = 7000
LoadAndProcessCube = 7001
LoadCubeBatch = 7002
ProcessCube = 8000
ClearCubeData = 8400
ClearCubeDataForWorkflow = 8500
Confirm = 8600
Certify = 8700
Calculate = 9000
Translate = 10000
Consolidate = 11000
Aggregate = 11001
WorkflowViewBatch = 12000
MultiWorkflowViewBatch = 12500
WorkflowFileBatch = 13000
LoadXml = 15000
AzureEDTUScaling = 16000
AzureServerScaling = 16100
LockFxRate = 17000
UnlockFxRate = 17100
AnalyticsApi = 20000
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.