SQL Analyses Properties

The relevance for each property is in the output that you included above, and can be extracted more simply from the BES_OBJECT_DEFS view (no join with the VERSIONS table), though the XML format will be the same.

The property result data is not available from the views. To clarify the _PROPERTIES views have the metadata associated with fixlets, analyses, and baselines like Category, Severity, Source, etc; they do not have anything to do with property data from endpoints. It is probably easier to get both of these things from session relevance, but if you want to use SQL, I would suggest using the PropertyIDMapper utility from here: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Endpoint%20Manager/page/Utilities

When you run that utility, you’ll get a new PROPERTYIDMAP table that contains the name of all the properties and the 3 ids you need to query for the results: SiteID, AnalysisID, and PropertyID. You use those id triples to query for the results of specific properties from the QUESTIONRESULTS and LONGQUESTIONRESULTS tables.

2 Likes