K1000 Smart Label for Device Timezone isn't working properly
I'm trying to use Device Timezone to sort devices by location but it isn't working properly on all devices. For instance I have a label to list devices with timezone beginning with "Asia" but it also returns some that begin with "Europe" and "America" but it doesn't return all of the devices in the other zones. I've looked through device properties and can't find anything different in the ones that are excluded properly vs the ones that are not.
I've tried using "Device Timezone begins with Asia" and "Device Timezone does not begin with {other timezone}" and even used both of these together and it still returns devices that are clearly not in the Asia timezone.
Has anyone else seen this or similar? Any idea on why the timezones are reported correctly in the device information but are still showing up in the wrong labels?
Thanks.
Answers (1)
So a bit of investigation shows that the MACHINE.TZ_AGENT is the field that contains the data you are after.
I built a quick smart label using "Device Timezone" using the wizard and got back the following underlying SQL:
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE ((TZ_AGENT like 'europe%'))
This shows the smart label wizard is pulling data from that MACHINE.TZ_AGENT
I also checked the data values stored in the DB using my SQL editor and can confirm that the data in that field is "Zone/location"
So creating some basic SQL to add to the label, I used this:
SELECT MACHINE.TZ_AGENT, MACHINE.NAME
FROM MACHINE MACHINE
WHERE (MACHINE.TZ_AGENT LIKE 'Europe%')
and my machines all dropped into the label
Changing the SQL to
SELECT MACHINE.TZ_AGENT, MACHINE.NAME
FROM MACHINE MACHINE
WHERE (MACHINE.TZ_AGENT LIKE 'Asia%')
all machines were removed from the label suggesting correct functionality from the SQL.
I would suggest check the values stored in that MACHINE.TZ_AGENT field on your database and use simple SQL to power the smart label.
If that does not work..........go to support as something this simple should be working.
Comments:
-
Thanks for the information. What's crazy about it to me is that I have some labels using this that work as expected and others won't. Even when I create a totally new label. I'll keep poking around to see what I find. Thanks! - ScottAday 4 years ago
