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.
Please log in to comment

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
Please log in to comment
Answer this question or Comment on this question for clarity
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share