Kace can you edit smart labels ip address range.
I am wondering if there is a way to edit smart labels. When we first created our labels we were using the ip address range of 192.168.11. We now have set up ip address ranges of 192.168.9/10 as well. Anyway to add this to the smart labels like so 192.168.9-11 or do we need to create new smart lables? I am pasting an example smart label we have created.
select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS
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 (((( CHASSIS_TYPE like '%Desktop%') OR CHASSIS_TYPE like '%Laptop%') AND (1 in (select 1 from ORG1.MACHINE M2 where M2.ID = MACHINE.ID and M2.IP like '%192.168.11%' union select 1 from ORG1.MACHINE_NICS where MACHINE.ID = MACHINE_NICS.ID and MACHINE_NICS.IP like '%192.168.11%')) ))