/build/static/layout/Breadcrumb_cap_w.png
09/26/2013 2066 views

I am trying to make a dynamic label in the computer inventory list. All client computers have names in the format xxxx-Exxx.

I have tried to make dynamic labels that search for computer names containing "%%%%-E%%%%". This search also displays computer names with a name-standard different than the one explained above.

Any suggestions?

3 Comments   [ + ] Show comments

Comments

  • Have you tried using only one % before and after -E?
  • Pretty sure that would return any "E"s in the computer name. Submit a support ticket and see if you can get any closer to an answer.
  • Timi: I imagined I had to use one % per letter but I could give it a try with only one % before and after -E.

All Answers

2

You should be able to turn this into a label. This will check for the 5th character a "-" and the 6th as "E".

SELECT NAME

FROM MACHINE M

WHERE M.NAME RLIKE '^....[-][E]'
Answered 09/27/2013 by: dugullett
Red Belt

  • LABEL:

    select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME,
    UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS
    from ORG1.MACHINE
    LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID
    AND KUID_ORGANIZATION.ORGANIZATION_ID = 1
    where (MACHINE.NAME RLIKE '^....[-][E]')
    • This content is currently hidden from public view.
      Reason: Removed by member request
      For more information, visit our FAQ's.
    • Thanks. this did what I was looking for.

      This query lists machines with lots of info. Is it possible to limit this to (machine) name, username, OS name and, IP?
      • The comment above is what's needed if you wanted to create a label. If you're wanting a report use this.

        SELECT NAME, IP, OS_NAME, USER_LOGGED
        FROM MACHINE M
        WHERE M.NAME RLIKE '^....[-][E]'
        ORDER BY M.NAME