(imported topic written by SystemAdmin)
Hello,
We are working on doing some data mining in the BES db. My dba had the following inquiry. Any guidence on this? Thanks so much - Mike
“I am working in the questionresults table. I figured out that the analysisid links to the local_objects_def to give me the type of value in the resultstext field. For example, computer name is ID 16. But, I see that sometimes the analysisID is repeated, but with a different propertyID. I can’t find where that is. It would be really helpful for me to get the name of the propertyID to go with my analysisID.”