Making a K1000 dynamic label in computer inventory
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
-
Have you tried using only one % before and after -E? - Timi 11 years ago
-
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. - jknox 11 years ago
-
Timi: I imagined I had to use one % per letter but I could give it a try with only one % before and after -E. - MesaMe 11 years ago
Answers (1)
Please log in to answer
Posted by:
dugullett
11 years ago
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]'
Comments:
-
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]') - dugullett 11 years ago-
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? - MesaMe 11 years ago-
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 - dugullett 11 years ago
