> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: OsFullName

> Extract the full operating system name and version from a user agent string using ua_parser. Use for OS analytics in Integrate.io ETL pipelines.

## Description

Extract operating system family and version from user agent string, based on [ua\_parser](https://github.com/tobie/ua-parser).

## Syntax

`OsFullName(user_agent_string)`

## Examples

`OsFullName('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.93 Safari/537.36')` returns 'Mac OS X 10.6.8'

## Return value datatype

string

## Notes

Returns "Other" if OS family and version can't be extracted from string.

## Impact of null value

If input is null, returns null.