Does anyone use LPS 2.2 and create your own queries? I'm trying to create a query to select substrings from cs-useragent. I started with their query ActiveSync: Apple Device/iOS Version Report. Instead of adding a kazillion lines to it I thought it would be easier to pull just the version numbers - ie: 1206.70 = 8.3
"CASE EXTRACT_TOKEN(cs(user-agent),0,'/') This works to get "Apple-iPhone7C2" Out of: 'Apple-iPhone7C1/1202.440' I'm trying to get the second part "1202.440" I tried CASE EXTRACT_TOKEN(cs(user-agent,'/',0) but get an error that the second part has to be an integer Any help appreciated. Thanks all. Candee
