TrueNAS API v25.10.0
  1. TrueNAS API v25.10.0 documentation
  2. API Events
  3. user
« tunable.query user.query »

Table Of Contents

  • JSON-RPC 2.0 over WebSocket API
    • Overview
    • JSON-RPC 2.0 Protocol
      • Communication Mechanism
    • Request and Response Format
      • JSON-RPC Request Structure
        • Example Request:
      • JSON-RPC Response Structure
        • Example Response:
      • Error Response
        • Custom Error Codes
    • Event Notifications
      • JSON-RPC Notification Structure
        • Example Notification:
      • Important Notes on Notifications
    • Limitations
  • API Methods
    • acme.dns.authenticator
      • acme.dns.authenticator.authenticator_schemas
      • acme.dns.authenticator.create
      • acme.dns.authenticator.delete
      • acme.dns.authenticator.get_instance
      • acme.dns.authenticator.query
      • acme.dns.authenticator.update
    • alert
      • alert.dismiss
      • alert.list
      • alert.list_categories
      • alert.list_policies
      • alert.restore
    • alertclasses
      • alertclasses.config
      • alertclasses.update
    • alertservice
      • alertservice.create
      • alertservice.delete
      • alertservice.get_instance
      • alertservice.query
      • alertservice.test
      • alertservice.update
    • api_key
      • api_key.create
      • api_key.delete
      • api_key.get_instance
      • api_key.my_keys
      • api_key.query
      • api_key.update
    • app
      • app.available
      • app.available_space
      • app.categories
      • app.certificate_choices
      • app.config
      • app.container_console_choices
      • app.container_ids
      • app.convert_to_custom
      • app.create
      • app.delete
      • app.get_instance
      • app.gpu_choices
      • app.ip_choices
      • app.latest
      • app.outdated_docker_images
      • app.pull_images
      • app.query
      • app.redeploy
      • app.rollback
      • app.rollback_versions
      • app.similar
      • app.start
      • app.stop
      • app.update
      • app.upgrade
      • app.upgrade_summary
      • app.used_ports
    • app.image
      • app.image.delete
      • app.image.dockerhub_rate_limit
      • app.image.get_instance
      • app.image.pull
      • app.image.query
    • app.ix_volume
      • app.ix_volume.exists
      • app.ix_volume.query
    • app.registry
      • app.registry.create
      • app.registry.delete
      • app.registry.get_instance
      • app.registry.query
      • app.registry.update
    • audit
      • audit.config
      • audit.download_report
      • audit.export
      • audit.query
      • audit.update
    • auth
      • auth.generate_onetime_password
      • auth.generate_token
      • auth.login
      • auth.login_ex
      • auth.login_ex_continue
      • auth.login_with_api_key
      • auth.login_with_token
      • auth.logout
      • auth.me
      • auth.mechanism_choices
      • auth.sessions
      • auth.set_attribute
      • auth.terminate_other_sessions
      • auth.terminate_session
    • auth.twofactor
      • auth.twofactor.config
      • auth.twofactor.update
    • boot
      • boot.attach
      • boot.detach
      • boot.get_disks
      • boot.get_state
      • boot.replace
      • boot.scrub
      • boot.set_scrub_interval
    • boot.environment
      • boot.environment.activate
      • boot.environment.clone
      • boot.environment.destroy
      • boot.environment.keep
      • boot.environment.query
    • catalog
      • catalog.apps
      • catalog.config
      • catalog.get_app_details
      • catalog.sync
      • catalog.trains
      • catalog.update
    • certificate
      • certificate.acme_server_choices
      • certificate.country_choices
      • certificate.create
      • certificate.delete
      • certificate.ec_curve_choices
      • certificate.extended_key_usage_choices
      • certificate.get_instance
      • certificate.query
      • certificate.update
    • cloud_backup
      • cloud_backup.abort
      • cloud_backup.create
      • cloud_backup.delete
      • cloud_backup.delete_snapshot
      • cloud_backup.get_instance
      • cloud_backup.list_snapshot_directory
      • cloud_backup.list_snapshots
      • cloud_backup.query
      • cloud_backup.restore
      • cloud_backup.sync
      • cloud_backup.transfer_setting_choices
      • cloud_backup.update
    • cloudsync
      • cloudsync.abort
      • cloudsync.create
      • cloudsync.create_bucket
      • cloudsync.delete
      • cloudsync.get_instance
      • cloudsync.list_buckets
      • cloudsync.list_directory
      • cloudsync.onedrive_list_drives
      • cloudsync.providers
      • cloudsync.query
      • cloudsync.restore
      • cloudsync.sync
      • cloudsync.sync_onetime
      • cloudsync.update
    • cloudsync.credentials
      • cloudsync.credentials.create
      • cloudsync.credentials.delete
      • cloudsync.credentials.get_instance
      • cloudsync.credentials.query
      • cloudsync.credentials.update
      • cloudsync.credentials.verify
    • config
      • config.reset
      • config.save
      • config.upload
    • core
      • core.arp
      • core.bulk
      • core.debug
      • core.download
      • core.get_jobs
      • core.get_methods
      • core.get_services
      • core.job_abort
      • core.job_download_logs
      • core.job_wait
      • core.ping
      • core.ping_remote
      • core.resize_shell
      • core.set_options
      • core.subscribe
      • core.unsubscribe
    • cronjob
      • cronjob.create
      • cronjob.delete
      • cronjob.get_instance
      • cronjob.query
      • cronjob.run
      • cronjob.update
    • device
      • device.get_info
    • disk
      • disk.details
      • disk.get_instance
      • disk.get_used
      • disk.query
      • disk.temperature_agg
      • disk.temperature_alerts
      • disk.temperatures
      • disk.update
      • disk.wipe
    • dns
      • dns.query
    • docker
      • docker.backup
      • docker.config
      • docker.delete_backup
      • docker.list_backups
      • docker.nvidia_present
      • docker.restore_backup
      • docker.status
      • docker.update
    • docker.network
      • docker.network.get_instance
      • docker.network.query
    • enclosure.label
      • enclosure.label.set
    • failover.disabled
      • failover.disabled.reasons
    • failover.reboot
      • failover.reboot.info
      • failover.reboot.other_node
    • filesystem
      • filesystem.chown
      • filesystem.get
      • filesystem.get_zfs_attributes
      • filesystem.getacl
      • filesystem.listdir
      • filesystem.mkdir
      • filesystem.put
      • filesystem.set_zfs_attributes
      • filesystem.setacl
      • filesystem.setperm
      • filesystem.stat
      • filesystem.statfs
    • filesystem.acltemplate
      • filesystem.acltemplate.by_path
      • filesystem.acltemplate.create
      • filesystem.acltemplate.delete
      • filesystem.acltemplate.get_instance
      • filesystem.acltemplate.query
      • filesystem.acltemplate.update
    • ftp
      • ftp.config
      • ftp.update
    • group
      • group.create
      • group.delete
      • group.get_group_obj
      • group.get_instance
      • group.get_next_gid
      • group.has_password_enabled_user
      • group.query
      • group.update
    • initshutdownscript
      • initshutdownscript.create
      • initshutdownscript.delete
      • initshutdownscript.get_instance
      • initshutdownscript.query
      • initshutdownscript.update
    • interface
      • interface.bridge_members_choices
      • interface.cancel_rollback
      • interface.checkin
      • interface.checkin_waiting
      • interface.choices
      • interface.commit
      • interface.create
      • interface.default_route_will_be_removed
      • interface.delete
      • interface.get_instance
      • interface.has_pending_changes
      • interface.ip_in_use
      • interface.lacpdu_rate_choices
      • interface.lag_ports_choices
      • interface.query
      • interface.rollback
      • interface.save_default_route
      • interface.services_restarted_on_sync
      • interface.update
      • interface.vlan_parent_interface_choices
      • interface.websocket_interface
      • interface.websocket_local_ip
      • interface.xmit_hash_policy_choices
    • ipmi
      • ipmi.is_loaded
    • ipmi.chassis
      • ipmi.chassis.identify
      • ipmi.chassis.info
    • ipmi.lan
      • ipmi.lan.channels
      • ipmi.lan.query
      • ipmi.lan.update
    • ipmi.sel
      • ipmi.sel.clear
      • ipmi.sel.elist
      • ipmi.sel.info
    • iscsi.auth
      • iscsi.auth.create
      • iscsi.auth.delete
      • iscsi.auth.get_instance
      • iscsi.auth.query
      • iscsi.auth.update
    • iscsi.extent
      • iscsi.extent.create
      • iscsi.extent.delete
      • iscsi.extent.disk_choices
      • iscsi.extent.get_instance
      • iscsi.extent.query
      • iscsi.extent.update
    • iscsi.global
      • iscsi.global.alua_enabled
      • iscsi.global.client_count
      • iscsi.global.config
      • iscsi.global.iser_enabled
      • iscsi.global.sessions
      • iscsi.global.update
    • iscsi.initiator
      • iscsi.initiator.create
      • iscsi.initiator.delete
      • iscsi.initiator.get_instance
      • iscsi.initiator.query
      • iscsi.initiator.update
    • iscsi.portal
      • iscsi.portal.create
      • iscsi.portal.delete
      • iscsi.portal.get_instance
      • iscsi.portal.listen_ip_choices
      • iscsi.portal.query
      • iscsi.portal.update
    • iscsi.target
      • iscsi.target.create
      • iscsi.target.delete
      • iscsi.target.get_instance
      • iscsi.target.query
      • iscsi.target.update
      • iscsi.target.validate_name
    • iscsi.targetextent
      • iscsi.targetextent.create
      • iscsi.targetextent.delete
      • iscsi.targetextent.get_instance
      • iscsi.targetextent.query
      • iscsi.targetextent.update
    • jbof
      • jbof.create
      • jbof.delete
      • jbof.get_instance
      • jbof.licensed
      • jbof.query
      • jbof.reapply_config
      • jbof.update
    • k8s_to_docker
      • k8s_to_docker.list_backups
      • k8s_to_docker.migrate
    • kerberos
      • kerberos.config
      • kerberos.update
    • kerberos.keytab
      • kerberos.keytab.create
      • kerberos.keytab.delete
      • kerberos.keytab.get_instance
      • kerberos.keytab.query
      • kerberos.keytab.update
    • kerberos.realm
      • kerberos.realm.create
      • kerberos.realm.delete
      • kerberos.realm.get_instance
      • kerberos.realm.query
      • kerberos.realm.update
    • keychaincredential
      • keychaincredential.create
      • keychaincredential.delete
      • keychaincredential.generate_ssh_key_pair
      • keychaincredential.get_instance
      • keychaincredential.query
      • keychaincredential.remote_ssh_host_key_scan
      • keychaincredential.remote_ssh_semiautomatic_setup
      • keychaincredential.setup_ssh_connection
      • keychaincredential.update
      • keychaincredential.used_by
    • kmip
      • kmip.clear_sync_pending_keys
      • kmip.config
      • kmip.kmip_sync_pending
      • kmip.sync_keys
      • kmip.update
    • mail
      • mail.config
      • mail.local_administrator_email
      • mail.send
      • mail.update
    • network.configuration
      • network.configuration.activity_choices
      • network.configuration.config
      • network.configuration.update
    • network.general
      • network.general.summary
    • nfs
      • nfs.bindip_choices
      • nfs.client_count
      • nfs.config
      • nfs.get_nfs3_clients
      • nfs.get_nfs4_clients
      • nfs.update
    • nvmet.global
      • nvmet.global.ana_enabled
      • nvmet.global.config
      • nvmet.global.rdma_enabled
      • nvmet.global.sessions
      • nvmet.global.update
    • nvmet.host
      • nvmet.host.create
      • nvmet.host.delete
      • nvmet.host.dhchap_dhgroup_choices
      • nvmet.host.dhchap_hash_choices
      • nvmet.host.generate_key
      • nvmet.host.get_instance
      • nvmet.host.query
      • nvmet.host.update
    • nvmet.host_subsys
      • nvmet.host_subsys.create
      • nvmet.host_subsys.delete
      • nvmet.host_subsys.get_instance
      • nvmet.host_subsys.query
      • nvmet.host_subsys.update
    • nvmet.namespace
      • nvmet.namespace.create
      • nvmet.namespace.delete
      • nvmet.namespace.get_instance
      • nvmet.namespace.query
      • nvmet.namespace.update
    • nvmet.port
      • nvmet.port.create
      • nvmet.port.delete
      • nvmet.port.get_instance
      • nvmet.port.query
      • nvmet.port.transport_address_choices
      • nvmet.port.update
    • nvmet.port_subsys
      • nvmet.port_subsys.create
      • nvmet.port_subsys.delete
      • nvmet.port_subsys.get_instance
      • nvmet.port_subsys.query
      • nvmet.port_subsys.update
    • nvmet.subsys
      • nvmet.subsys.create
      • nvmet.subsys.delete
      • nvmet.subsys.get_instance
      • nvmet.subsys.query
      • nvmet.subsys.update
    • pool
      • pool.attach
      • pool.attachments
      • pool.create
      • pool.ddt_prefetch
      • pool.ddt_prune
      • pool.detach
      • pool.expand
      • pool.export
      • pool.filesystem_choices
      • pool.get_disks
      • pool.get_instance
      • pool.import_find
      • pool.import_pool
      • pool.is_upgraded
      • pool.offline
      • pool.online
      • pool.processes
      • pool.query
      • pool.remove
      • pool.replace
      • pool.scrub
        • pool.scrub.create
        • pool.scrub.delete
        • pool.scrub.get_instance
        • pool.scrub.query
        • pool.scrub.run
        • pool.scrub.scrub
        • pool.scrub.update
      • pool.update
      • pool.upgrade
      • pool.validate_name
    • pool.dataset
      • pool.dataset.attachments
      • pool.dataset.change_key
      • pool.dataset.checksum_choices
      • pool.dataset.compression_choices
      • pool.dataset.create
      • pool.dataset.delete
      • pool.dataset.destroy_snapshots
      • pool.dataset.details
      • pool.dataset.encryption_algorithm_choices
      • pool.dataset.encryption_summary
      • pool.dataset.export_key
      • pool.dataset.export_keys
      • pool.dataset.export_keys_for_replication
      • pool.dataset.get_instance
      • pool.dataset.get_quota
      • pool.dataset.inherit_parent_encryption_properties
      • pool.dataset.lock
      • pool.dataset.processes
      • pool.dataset.promote
      • pool.dataset.query
      • pool.dataset.recommended_zvol_blocksize
      • pool.dataset.recordsize_choices
      • pool.dataset.set_quota
      • pool.dataset.snapshot_count
      • pool.dataset.unlock
      • pool.dataset.update
    • pool.resilver
      • pool.resilver.config
      • pool.resilver.update
    • pool.scrub
      • pool.scrub.create
      • pool.scrub.delete
      • pool.scrub.get_instance
      • pool.scrub.query
      • pool.scrub.run
      • pool.scrub.scrub
      • pool.scrub.update
    • pool.snapshot
      • pool.snapshot.clone
      • pool.snapshot.create
      • pool.snapshot.delete
      • pool.snapshot.get_instance
      • pool.snapshot.hold
      • pool.snapshot.query
      • pool.snapshot.release
      • pool.snapshot.rollback
      • pool.snapshot.update
    • pool.snapshottask
      • pool.snapshottask.create
      • pool.snapshottask.delete
      • pool.snapshottask.delete_will_change_retention_for
      • pool.snapshottask.get_instance
      • pool.snapshottask.max_count
      • pool.snapshottask.max_total_count
      • pool.snapshottask.query
      • pool.snapshottask.run
      • pool.snapshottask.update
      • pool.snapshottask.update_will_change_retention_for
    • privilege
      • privilege.create
      • privilege.delete
      • privilege.get_instance
      • privilege.query
      • privilege.roles
      • privilege.update
    • replication
      • replication.count_eligible_manual_snapshots
      • replication.create
      • replication.create_dataset
      • replication.delete
      • replication.get_instance
      • replication.list_datasets
      • replication.list_naming_schemas
      • replication.query
      • replication.restore
      • replication.run
      • replication.run_onetime
      • replication.target_unmatched_snapshots
      • replication.update
    • replication.config
      • replication.config.config
      • replication.config.update
    • reporting
      • reporting.config
      • reporting.get_data
      • reporting.graph
      • reporting.graphs
      • reporting.netdata_get_data
      • reporting.netdata_graph
      • reporting.netdata_graphs
      • reporting.update
    • reporting.exporters
      • reporting.exporters.create
      • reporting.exporters.delete
      • reporting.exporters.exporter_schemas
      • reporting.exporters.get_instance
      • reporting.exporters.query
      • reporting.exporters.update
    • route
      • route.ipv4gw_reachable
      • route.system_routes
    • rsynctask
      • rsynctask.create
      • rsynctask.delete
      • rsynctask.get_instance
      • rsynctask.query
      • rsynctask.run
      • rsynctask.update
    • service
      • service.control
      • service.get_instance
      • service.query
      • service.reload
      • service.restart
      • service.start
      • service.started
      • service.started_or_enabled
      • service.stop
      • service.update
    • sharing.nfs
      • sharing.nfs.create
      • sharing.nfs.delete
      • sharing.nfs.get_instance
      • sharing.nfs.query
      • sharing.nfs.update
    • sharing.smb
      • sharing.smb.getacl
      • sharing.smb.presets
      • sharing.smb.setacl
      • sharing.smb.share_precheck
    • smb
      • smb.bindip_choices
      • smb.config
      • smb.unixcharset_choices
      • smb.update
    • snmp
      • snmp.config
      • snmp.update
    • ssh
      • ssh.bindiface_choices
      • ssh.config
      • ssh.update
    • staticroute
      • staticroute.create
      • staticroute.delete
      • staticroute.get_instance
      • staticroute.query
      • staticroute.update
    • support
      • support.attach_ticket
      • support.attach_ticket_max_size
      • support.config
      • support.fields
      • support.is_available
      • support.is_available_and_enabled
      • support.new_ticket
      • support.similar_issues
      • support.update
    • system
      • system.boot_id
      • system.debug
      • system.feature_enabled
      • system.host_id
      • system.info
      • system.license_update
      • system.product_type
      • system.ready
      • system.reboot
        • system.reboot.info
      • system.release_notes_url
      • system.shutdown
      • system.state
      • system.version
      • system.version_short
    • system.advanced
      • system.advanced.config
      • system.advanced.get_gpu_pci_choices
      • system.advanced.login_banner
      • system.advanced.sed_global_password
      • system.advanced.sed_global_password_is_set
      • system.advanced.serial_port_choices
      • system.advanced.syslog_certificate_authority_choices
      • system.advanced.syslog_certificate_choices
      • system.advanced.update
      • system.advanced.update_gpu_pci_ids
    • system.general
      • system.general.checkin
      • system.general.checkin_waiting
      • system.general.config
      • system.general.country_choices
      • system.general.kbdmap_choices
      • system.general.local_url
      • system.general.timezone_choices
      • system.general.ui_address_choices
      • system.general.ui_certificate_choices
      • system.general.ui_httpsprotocols_choices
      • system.general.ui_restart
      • system.general.ui_v6address_choices
      • system.general.update
    • system.global
      • system.global.id
    • system.ntpserver
      • system.ntpserver.create
      • system.ntpserver.delete
      • system.ntpserver.get_instance
      • system.ntpserver.query
      • system.ntpserver.update
    • system.reboot
      • system.reboot.info
    • system.security
      • system.security.config
      • system.security.update
    • system.security.info
      • system.security.info.fips_available
      • system.security.info.fips_enabled
    • systemdataset
      • systemdataset.config
      • systemdataset.pool_choices
      • systemdataset.update
    • tn_connect
      • tn_connect.config
      • tn_connect.generate_claim_token
      • tn_connect.get_registration_uri
      • tn_connect.ip_choices
      • tn_connect.update
    • truecommand
      • truecommand.config
      • truecommand.update
    • truenas
      • truenas.accept_eula
      • truenas.get_chassis_hardware
      • truenas.get_eula
      • truenas.is_eula_accepted
      • truenas.is_ix_hardware
      • truenas.is_production
      • truenas.managed_by_truecommand
      • truenas.set_production
    • tunable
      • tunable.create
      • tunable.delete
      • tunable.get_instance
      • tunable.query
      • tunable.tunable_type_choices
      • tunable.update
    • update
      • update.check_available
      • update.download
      • update.file
      • update.get_auto_download
      • update.get_pending
      • update.get_trains
      • update.manual
      • update.set_auto_download
      • update.set_train
      • update.update
    • ups
      • ups.config
      • ups.driver_choices
      • ups.port_choices
      • ups.update
    • user
      • user.create
      • user.delete
      • user.get_instance
      • user.get_next_uid
      • user.get_user_obj
      • user.has_local_administrator_set_up
      • user.query
      • user.renew_2fa_secret
      • user.set_password
      • user.setup_local_administrator
      • user.shell_choices
      • user.unset_2fa_secret
      • user.update
    • virt.device
      • virt.device.disk_choices
      • virt.device.export_disk_image
      • virt.device.gpu_choices
      • virt.device.import_disk_image
      • virt.device.nic_choices
      • virt.device.pci_choices
      • virt.device.usb_choices
    • virt.global
      • virt.global.bridge_choices
      • virt.global.config
      • virt.global.get_network
      • virt.global.pool_choices
      • virt.global.update
    • virt.instance
      • virt.instance.create
      • virt.instance.delete
      • virt.instance.device_add
      • virt.instance.device_delete
      • virt.instance.device_list
      • virt.instance.device_update
      • virt.instance.get_instance
      • virt.instance.image_choices
      • virt.instance.query
      • virt.instance.restart
      • virt.instance.set_bootable_disk
      • virt.instance.start
      • virt.instance.stop
      • virt.instance.update
    • virt.volume
      • virt.volume.create
      • virt.volume.delete
      • virt.volume.get_instance
      • virt.volume.import_iso
      • virt.volume.import_zvol
      • virt.volume.query
      • virt.volume.update
    • vmware
      • vmware.create
      • vmware.dataset_has_vms
      • vmware.delete
      • vmware.get_datastores
      • vmware.get_instance
      • vmware.match_datastores_with_datasets
      • vmware.query
      • vmware.update
  • API Events
    • acme.dns.authenticator
      • acme.dns.authenticator.query
    • alert
      • alert.list
    • alertservice
      • alertservice.query
    • api_key
      • api_key.query
    • app
      • app.query
    • app.image
      • app.image.query
    • app.registry
      • app.registry.query
    • certificate
      • certificate.query
    • cloud_backup
      • cloud_backup.query
    • cloudsync
      • cloudsync.query
    • cloudsync.credentials
      • cloudsync.credentials.query
    • core
      • core.get_jobs
    • cronjob
      • cronjob.query
    • docker.network
      • docker.network.query
    • filesystem.acltemplate
      • filesystem.acltemplate.query
    • group
      • group.query
    • initshutdownscript
      • initshutdownscript.query
    • interface
      • interface.query
    • iscsi.auth
      • iscsi.auth.query
    • iscsi.extent
      • iscsi.extent.query
    • iscsi.initiator
      • iscsi.initiator.query
    • iscsi.portal
      • iscsi.portal.query
    • iscsi.target
      • iscsi.target.query
    • iscsi.targetextent
      • iscsi.targetextent.query
    • jbof
      • jbof.query
    • kerberos.keytab
      • kerberos.keytab.query
    • kerberos.realm
      • kerberos.realm.query
    • keychaincredential
      • keychaincredential.query
    • nvmet.host
      • nvmet.host.query
    • nvmet.host_subsys
      • nvmet.host_subsys.query
    • nvmet.namespace
      • nvmet.namespace.query
    • nvmet.port
      • nvmet.port.query
    • nvmet.port_subsys
      • nvmet.port_subsys.query
    • nvmet.subsys
      • nvmet.subsys.query
    • pool
      • pool.query
    • pool.dataset
      • pool.dataset.query
    • pool.scrub
      • pool.scrub.query
    • pool.snapshot
      • pool.snapshot.query
    • pool.snapshottask
      • pool.snapshottask.query
    • privilege
      • privilege.query
    • replication
      • replication.query
    • reporting.exporters
      • reporting.exporters.query
    • rsynctask
      • rsynctask.query
    • service
      • service.query
    • sharing.nfs
      • sharing.nfs.query
    • staticroute
      • staticroute.query
    • system.ntpserver
      • system.ntpserver.query
    • tunable
      • tunable.query
    • user
      • user.query
    • virt.instance
      • virt.instance.query
    • virt.volume
      • virt.volume.query
    • vmware
      • vmware.query
  • Jobs
    • Example of Calling a Job Method
    • Query Job Status
    • Uploading / Downloading Files
      • Downloading a File
      • Uploading a File
  • Query Methods
    • Query Filters
      • Basic Usage
      • Supported Operators
      • Multiple Filters
      • Connectives
      • Datetime information
    • Query Options
      • Count
      • Limit
      • Offset
      • Select
      • Order By
      • Sample SQL statements translated into Query Filters and Query Options
        • “SELECT * FROM table;”
        • “SELECT username,uid FROM table WHERE builtin=FALSE ORDER BY -uid;”
        • “SELECT username AS locked_user,uid FROM table WHERE builtin=FALSE AND locked=TRUE;”
        • “SELECT username FROM table WHERE builtin=False OR (locked=FALSE AND ssh=TRUE);”

Previous topic

tunable.query

Next topic

user.query

  • Show Source

user¶

  • user.query
© Copyright 2025, iXsystems, Inc. dba TrueNAS.
Back to top