General query datatypes You must store data in ePolicy Orchestrator databases with specific types in remote queries. General query datatypes Type Description Int An integer string_lookup A lookup string field Enum An enumerated value, stored in the database as an integer Mac A MAC address Long A long value Float A float value Timespan An SQL timespan boolean A Boolean value string_enum An enumerated value stored as a string instead of an integer ipv4 An IPv4 address ipv6 An IPv6 address Parent topic: Ad-hoc query reference
General query datatypes You must store data in ePolicy Orchestrator databases with specific types in remote queries. General query datatypes Type Description Int An integer string_lookup A lookup string field Enum An enumerated value, stored in the database as an integer Mac A MAC address Long A long value Float A float value Timespan An SQL timespan boolean A Boolean value string_enum An enumerated value stored as a string instead of an integer ipv4 An IPv4 address ipv6 An IPv6 address Parent topic: Ad-hoc query reference