K1000 SQL Smart Label notes

I just spent a whole bunch of time trying to get an SQL Smart Label to work, only to find that all it needed was a simple notation change to work, so I thought I'd share it, and maybe others who have encountered Smart Label quirks can add their knowledge in the comments as well.

In the report I was converting to a label, I had

and used the alias M in the rest of the query.  The report worked fine in KACE and in MySQL Workbench, but no computers were ever being added to that label.  Long story short, as soon as I removed the alias and used the actual table name instead, the Smart Label worked.

This doesn't appear to affect table aliases in JOIN clauses; only the FROM clause.

(K1000 6.4 SP3)


  • Correction:

    MACHINE cannot have an alias.

    Other tables can, even if they're in the FROM clause. - ondrar 7 years ago
This post is locked
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ