How to find back end SQL tables for Inherited Properties

Top Replies

• 

  KMSigma.SWI over 1 year ago +4 verified
  If you have a working query from the API (SWQL Studio), then you can add "WITH QUERYSTATS" to get the SQL behind the scenes. That should give you the info you need. I'd still recommend NOT doing this…
• 

  KMSigma.SWI over 1 year ago in reply to BaldFeegle +1
  Sounds like you'd need to pull the parent node and then concatenate the error messages. I don't think it's impossible to do, but it would be a little complex - in either SQL or SWQL.
• 

  BaldFeegle over 1 year ago in reply to KMSigma.SWI +1
  For my purposes I need to concatenate multiple rows into a single string. Using FOR XML ('') achieves that neatly in SQL. I've used it before to do exactly that. My problem this time is that I want to…