Is there a way to add a K1000 Label to a computer based on a ticket category?
For example, a technician can open a ticket with the category of New PC Install and it will add a Label of NewInstall to that computer in the Inventory.
1 Comment
[ + ] Show comment
Answers (0)
Please log in to answer
Be the first to answer this question
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.CREATED > DATE_SUB(CURRENT_DATE(),INTERVAL 1 DAY) - nshah 11 years ago