# Logship documentation > Self-hosted analytics for business events and operational data. Kusto-style queries, dashboards, alerts, and incidents. Start with getting-started/single-node, then push-your-first-event and query. The backend ingestion URL differs from the frontend URL. Verify supported syntax in the references; do not assume full KQL compatibility. ## Markdown references - [Agent Configuration](https://docs.logship.io/markdown/agent/v0.0.1/config.md) - [Getting Started with the Logship Agent](https://docs.logship.io/markdown/agent/v0.0.1/getting-started.md) - [Install](https://docs.logship.io/markdown/agent/v0.0.1/install.md) - [Logship Agent](https://docs.logship.io/markdown/agent/v0.0.1/overview.md) - [Installing Logship Agent on OpenWRT](https://docs.logship.io/markdown/agent/v0.0.1/targets/openwrt.md) - [Wireless activity collection](https://docs.logship.io/markdown/agent/v0.0.1/wireless.md) - [Blob storage durability](https://docs.logship.io/markdown/database/v0.0.1/blob-storage.md) - [Database Configuration](https://docs.logship.io/markdown/database/v0.0.1/config.md) - [Identity providers and SSO](https://docs.logship.io/markdown/database/v0.0.1/identity-providers.md) - [Indexed file V5 encodings](https://docs.logship.io/markdown/database/v0.0.1/indexed-file-format.md) - [Install logship-backend](https://docs.logship.io/markdown/database/v0.0.1/install.md) - [Logship Database](https://docs.logship.io/markdown/database/v0.0.1/overview.md) - [Table declarations and blob references](https://docs.logship.io/markdown/database/v0.0.1/tables.md) - [Account Settings](https://docs.logship.io/markdown/frontend/v0.0.1/account-settings.md) - [Frontend Configuration](https://docs.logship.io/markdown/frontend/v0.0.1/config.md) - [Dashboards](https://docs.logship.io/markdown/frontend/v0.0.1/dashboards.md) - [Grafana Data Source Plugin](https://docs.logship.io/markdown/frontend/v0.0.1/grafana-datasource-plugin.md) - [Install logship-frontend](https://docs.logship.io/markdown/frontend/v0.0.1/install.md) - [OpenID Connect sign-in](https://docs.logship.io/markdown/frontend/v0.0.1/oidc.md) - [Logship Frontend](https://docs.logship.io/markdown/frontend/v0.0.1/overview.md) - [Public query embeds](https://docs.logship.io/markdown/frontend/v0.0.1/query-embeds.md) - [System Settings](https://docs.logship.io/markdown/frontend/v0.0.1/system-settings.md) - [Advanced Snippets](https://docs.logship.io/markdown/getting-started/advanced.md) - [Next Steps](https://docs.logship.io/markdown/getting-started/next-steps.md) - [Prerequisites](https://docs.logship.io/markdown/getting-started/prerequisites.md) - [Push Your First Event](https://docs.logship.io/markdown/getting-started/push-your-first-event.md) - [Basic Querying](https://docs.logship.io/markdown/getting-started/query.md) - [Single Node Deployment](https://docs.logship.io/markdown/getting-started/single-node.md) - [Welcome](https://docs.logship.io/markdown/intro.md) - [Install logsh](https://docs.logship.io/markdown/logsh/install.md) - [logsh](https://docs.logship.io/markdown/logsh/overview.md) - [logsht — Terminal UI](https://docs.logship.io/markdown/logsh/tui.md) - [Administration Account](https://docs.logship.io/markdown/operations/v0.0.1/administration-account.md) - [Group Management](https://docs.logship.io/markdown/operations/v0.0.1/group-management.md) - [Set up and test a group](https://docs.logship.io/markdown/operations/v0.0.1/group-tutorial.md) - [Incident Management](https://docs.logship.io/markdown/operations/v0.0.1/incident-management.md) - [Work through a test incident](https://docs.logship.io/markdown/operations/v0.0.1/incident-tutorial.md) - [Logship Operations](https://docs.logship.io/markdown/operations/v0.0.1/overview.md) - [Firewall & Network Hardening](https://docs.logship.io/markdown/operations/v0.0.1/security/firewall.md) - [Token revocation](https://docs.logship.io/markdown/operations/v0.0.1/security/tokens.md) - [query/basics.md](https://docs.logship.io/markdown/query/basics.md) - [.create-merge table](https://docs.logship.io/markdown/query/language/commands/create-merge-table.md) - [.create table](https://docs.logship.io/markdown/query/language/commands/create-table.md) - [.drop column](https://docs.logship.io/markdown/query/language/commands/drop-column.md) - [.drop table](https://docs.logship.io/markdown/query/language/commands/drop-table.md) - [Table retention policy](https://docs.logship.io/markdown/query/language/commands/retention-policy.md) - [.show table](https://docs.logship.io/markdown/query/language/commands/show-table.md) - [.show tables](https://docs.logship.io/markdown/query/language/commands/show-tables.md) - [.truncate table](https://docs.logship.io/markdown/query/language/commands/truncate-table.md) - [Expressions and Variables](https://docs.logship.io/markdown/query/language/expressions.md) - [agg_avg](https://docs.logship.io/markdown/query/language/functions/aggregate/agg_avg.md) - [agg_expavg](https://docs.logship.io/markdown/query/language/functions/aggregate/agg_expavg.md) - [agg_max](https://docs.logship.io/markdown/query/language/functions/aggregate/agg_max.md) - [agg_min](https://docs.logship.io/markdown/query/language/functions/aggregate/agg_min.md) - [argmax](https://docs.logship.io/markdown/query/language/functions/aggregate/argmax.md) - [arg_min](https://docs.logship.io/markdown/query/language/functions/aggregate/argmin.md) - [avg](https://docs.logship.io/markdown/query/language/functions/aggregate/avg.md) - [count](https://docs.logship.io/markdown/query/language/functions/aggregate/count.md) - [dcount](https://docs.logship.io/markdown/query/language/functions/aggregate/dcount.md) - [first](https://docs.logship.io/markdown/query/language/functions/aggregate/first.md) - [join](https://docs.logship.io/markdown/query/language/functions/aggregate/join.md) - [make_list](https://docs.logship.io/markdown/query/language/functions/aggregate/make_list.md) - [make_set](https://docs.logship.io/markdown/query/language/functions/aggregate/make_set.md) - [percentile](https://docs.logship.io/markdown/query/language/functions/aggregate/percentile.md) - [percentiles](https://docs.logship.io/markdown/query/language/functions/aggregate/percentiles.md) - [stdev](https://docs.logship.io/markdown/query/language/functions/aggregate/stdev.md) - [sum](https://docs.logship.io/markdown/query/language/functions/aggregate/sum.md) - [variance](https://docs.logship.io/markdown/query/language/functions/aggregate/variance.md) - [abs](https://docs.logship.io/markdown/query/language/functions/scalar/abs.md) - [acos](https://docs.logship.io/markdown/query/language/functions/scalar/acos.md) - [acos2](https://docs.logship.io/markdown/query/language/functions/scalar/acos2.md) - [ago](https://docs.logship.io/markdown/query/language/functions/scalar/ago.md) - [asin](https://docs.logship.io/markdown/query/language/functions/scalar/asin.md) - [asin2](https://docs.logship.io/markdown/query/language/functions/scalar/asin2.md) - [atan](https://docs.logship.io/markdown/query/language/functions/scalar/atan.md) - [atan2](https://docs.logship.io/markdown/query/language/functions/scalar/atan2.md) - [bin](https://docs.logship.io/markdown/query/language/functions/scalar/bin.md) - [blob_url](https://docs.logship.io/markdown/query/language/functions/scalar/blob_url.md) - [case](https://docs.logship.io/markdown/query/language/functions/scalar/case.md) - [ceil](https://docs.logship.io/markdown/query/language/functions/scalar/ceil.md) - [coalesce](https://docs.logship.io/markdown/query/language/functions/scalar/coalesce.md) - [concat](https://docs.logship.io/markdown/query/language/functions/scalar/concat.md) - [cos](https://docs.logship.io/markdown/query/language/functions/scalar/cos.md) - [countof](https://docs.logship.io/markdown/query/language/functions/scalar/countof.md) - [datetime_add](https://docs.logship.io/markdown/query/language/functions/scalar/datetime_add.md) - [datetime_diff](https://docs.logship.io/markdown/query/language/functions/scalar/datetime_diff.md) - [datetime_part](https://docs.logship.io/markdown/query/language/functions/scalar/datetime_part.md) - [datetime_utc_to_local](https://docs.logship.io/markdown/query/language/functions/scalar/datetime_utc_to_local.md) - [degrees](https://docs.logship.io/markdown/query/language/functions/scalar/degrees.md) - [exp](https://docs.logship.io/markdown/query/language/functions/scalar/exp.md) - [extract](https://docs.logship.io/markdown/query/language/functions/scalar/extract.md) - [floor](https://docs.logship.io/markdown/query/language/functions/scalar/floor.md) - [format_datetime](https://docs.logship.io/markdown/query/language/functions/scalar/format_datetime.md) - [geo_linestring](https://docs.logship.io/markdown/query/language/functions/scalar/geo_linestring.md) - [geo_point](https://docs.logship.io/markdown/query/language/functions/scalar/geo_point.md) - [geo_polygon](https://docs.logship.io/markdown/query/language/functions/scalar/geo_polygon.md) - [hash functions](https://docs.logship.io/markdown/query/language/functions/scalar/hash.md) - [iff](https://docs.logship.io/markdown/query/language/functions/scalar/iff.md) - [indexof](https://docs.logship.io/markdown/query/language/functions/scalar/indexof.md) - [isempty](https://docs.logship.io/markdown/query/language/functions/scalar/isempty.md) - [isnotempty](https://docs.logship.io/markdown/query/language/functions/scalar/isnotempty.md) - [isnull](https://docs.logship.io/markdown/query/language/functions/scalar/isnull.md) - [json](https://docs.logship.io/markdown/query/language/functions/scalar/json.md) - [log](https://docs.logship.io/markdown/query/language/functions/scalar/log.md) - [log10](https://docs.logship.io/markdown/query/language/functions/scalar/log10.md) - [log2](https://docs.logship.io/markdown/query/language/functions/scalar/log2.md) - [math functions](https://docs.logship.io/markdown/query/language/functions/scalar/math.md) - [max](https://docs.logship.io/markdown/query/language/functions/scalar/max.md) - [min](https://docs.logship.io/markdown/query/language/functions/scalar/min.md) - [newid](https://docs.logship.io/markdown/query/language/functions/scalar/newid.md) - [now](https://docs.logship.io/markdown/query/language/functions/scalar/now.md) - [pack_array](https://docs.logship.io/markdown/query/language/functions/scalar/pack_array.md) - [parse_json](https://docs.logship.io/markdown/query/language/functions/scalar/parse_json.md) - [pi](https://docs.logship.io/markdown/query/language/functions/scalar/pi.md) - [pow](https://docs.logship.io/markdown/query/language/functions/scalar/pow.md) - [prev](https://docs.logship.io/markdown/query/language/functions/scalar/prev.md) - [radians](https://docs.logship.io/markdown/query/language/functions/scalar/radians.md) - [rand](https://docs.logship.io/markdown/query/language/functions/scalar/rand.md) - [round](https://docs.logship.io/markdown/query/language/functions/scalar/round.md) - [sign](https://docs.logship.io/markdown/query/language/functions/scalar/sign.md) - [sin](https://docs.logship.io/markdown/query/language/functions/scalar/sin.md) - [split](https://docs.logship.io/markdown/query/language/functions/scalar/split.md) - [sqrt](https://docs.logship.io/markdown/query/language/functions/scalar/sqrt.md) - [str](https://docs.logship.io/markdown/query/language/functions/scalar/str.md) - [string transform functions](https://docs.logship.io/markdown/query/language/functions/scalar/string_transform.md) - [strlen](https://docs.logship.io/markdown/query/language/functions/scalar/strlen.md) - [substring](https://docs.logship.io/markdown/query/language/functions/scalar/substring.md) - [tan](https://docs.logship.io/markdown/query/language/functions/scalar/tan.md) - [todouble](https://docs.logship.io/markdown/query/language/functions/scalar/todouble.md) - [toguid](https://docs.logship.io/markdown/query/language/functions/scalar/toguid.md) - [toint](https://docs.logship.io/markdown/query/language/functions/scalar/toint.md) - [toreal](https://docs.logship.io/markdown/query/language/functions/scalar/toreal.md) - [tostring](https://docs.logship.io/markdown/query/language/functions/scalar/tostring.md) - [trim](https://docs.logship.io/markdown/query/language/functions/scalar/trim.md) - [trim_end](https://docs.logship.io/markdown/query/language/functions/scalar/trim_end.md) - [trim_start](https://docs.logship.io/markdown/query/language/functions/scalar/trim_start.md) - [type conversion functions](https://docs.logship.io/markdown/query/language/functions/scalar/type_conversion.md) - [Chart settings reference](https://docs.logship.io/markdown/query/language/render-settings.md) - [count](https://docs.logship.io/markdown/query/language/tabular/count.md) - [datatable](https://docs.logship.io/markdown/query/language/tabular/datatable.md) - [distinct](https://docs.logship.io/markdown/query/language/tabular/distinct.md) - [extend](https://docs.logship.io/markdown/query/language/tabular/extend.md) - [join](https://docs.logship.io/markdown/query/language/tabular/join.md) - [limit / take](https://docs.logship.io/markdown/query/language/tabular/limit.md) - [make-streams](https://docs.logship.io/markdown/query/language/tabular/make-streams.md) - [multi-project](https://docs.logship.io/markdown/query/language/tabular/multi-project.md) - [parse](https://docs.logship.io/markdown/query/language/tabular/parse.md) - [project](https://docs.logship.io/markdown/query/language/tabular/project.md) - [range](https://docs.logship.io/markdown/query/language/tabular/range.md) - [render](https://docs.logship.io/markdown/query/language/tabular/render.md) - [sort / order](https://docs.logship.io/markdown/query/language/tabular/sort.md) - [summarize](https://docs.logship.io/markdown/query/language/tabular/summarize.md) - [table](https://docs.logship.io/markdown/query/language/tabular/table.md) - [take](https://docs.logship.io/markdown/query/language/tabular/take.md) - [time-bound](https://docs.logship.io/markdown/query/language/tabular/time-bound.md) - [union](https://docs.logship.io/markdown/query/language/tabular/union.md) - [where](https://docs.logship.io/markdown/query/language/tabular/where.md) - [types](https://docs.logship.io/markdown/query/language/types.md) - [Multiple query results](https://docs.logship.io/markdown/query/multiple-results.md) - [Query](https://docs.logship.io/markdown/query/query.md)