( unique values of ( itas string ) of values of keys "message"of values of keys whose ( ( name ofitas lowercase contains"extname" ) or ( name ofitas lowercase ends with"extnname" ) ) of jsons of files "messages.json"of folders whose ( name ofitas lowercase contains"en" ) of folders "_locales"ofit ) of folders of folders of folders "Extensions"of folders "Default"of ( folders "AppData\Local\Google\Chrome\User Data"of folders of folders ( "C:\Users" ) )
( unique values of ( itas string ) of values of keys "message"of values of keys whose ( ( name ofitas lowercase contains"extname" ) or ( name ofitas lowercase ends with"extnname" ) ) of jsons of files "messages.json"of folders whose ( name ofitas lowercase contains"en" ) of folders "_locales"ofit ) of folders of folders of folders "Extensions"of folders "Default"of ( folders "AppData\Local\Google\Chrome\User Data"of folders of folders ( "C:\Users" ) )
unique values of ( itas string ) of ( name of it, ( values whose ( itas string does not contain "__MSG"anditas string is not contained by set of ( "Docs";"Sheets";"Slides";"Gmail";"Google Drive";"YouTube" ) ) of keys "name"of jsons of files "manifest.json"of folders of folders of folders ( "\AppData\Local\Google\Chrome\User Data\Default\Extensions\";"/Library/Application Support/Google/Chrome/Default/Extensions/" ) of it;values whose ( itas string is not contained by set of ( "Docs";"Sheets";"Slides";"Gmail";"Google Drive";"YouTube" ) ) of keys "message"of values of keys "appName"of jsons whose ( exists keys "appName"ofit ) of files "messages.json"of folders whose ( name ofitas lowercase contains"en" ) of folders "_locales"of folders of folders of folders ( "\AppData\Local\Google\Chrome\User Data\Default\Extensions\";"/Library/Application Support/Google/Chrome/Default/Extensions/" ) ofit ) ) of folders of folders ( "/Users/" )
unique values of (itas string) of (name of it, (values whose (itas string does not contain "__MSG"anditas string is not contained by set of ("Docs";"Sheets";"Slides";"Gmail";"Google Drive";"YouTube")) of keys "name"of jsons of files "manifest.json"of folders of folders of folders ("\AppData\Local\Google\Chrome\User Data\Default\Extensions\";"/Library/Application Support/Google/Chrome/Default/Extensions/") of it;values whose (itas string is not contained by set of ("Docs";"Sheets";"Slides";"Gmail";"Google Drive";"YouTube")) of keys "message"of values of keys "appName"of jsons whose (exists keys "appName"ofit) of files "messages.json"of folders whose (name ofitas lowercase contains"en") of folders "_locales"of folders of folders of folders ("\AppData\Local\Google\Chrome\User Data\Default\Extensions\";"/Library/Application Support/Google/Chrome/Default/Extensions/") ofit)) of folders of folders ("/Users/")
unique values of ( itas string ) of ( name of it, ( preceding texts of firsts "%22"of following texts of firsts "%22:%22"of substrings separated by ","whose ( itcontains"%22name%22:" ) of it,preceding texts of firsts "%22"of following texts of firsts "%22:%22"of substrings separated by ","whose ( itcontains"user_name" ) ofit ) of substrings separated by "avatar_icon"of lines whose ( itcontains"user_name"anditcontains"%22name%22:" ) of files "Local State"of folders ( "AppData\Local\Google\Chrome\User Data\";"/Library/Application Support/Google/Chrome/" ) ofit ) of folders of folder "/Users/"
unique values of (itas string) of (name of it, (preceding texts of firsts "%22"of following texts of firsts "%22:%22"of substrings separated by ","whose (itcontains"%22name%22:") of it,preceding texts of firsts "%22"of following texts of firsts "%22:%22"of substrings separated by ","whose (itcontains"user_name") ofit) of substrings separated by "avatar_icon"of lines whose (itcontains"user_name"anditcontains"%22name%22:") of files "Local State"of folders ("AppData\Local\Google\Chrome\User Data\";"/Library/Application Support/Google/Chrome/")ofit) of folders of folder "/Users/"
if ( exists values "CurrentVersion"of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion"of native registry as string as version ) then ( item 1of item 1of ( it, ( "8","SQL SERVER 2000";"9","SQL SERVER 2005";"10.0","SQL Server 2008";"10.50","SQL Server 2008 R2";"11","SQL Server 2012";"12","SQL Server 2014";"13","SQL Server 2016";"14","SQL Server 2017";"15","SQL Server 2019";"16","SQL Server 2022" ) ) whose ( item 0ofitas version = item 0of item 1ofitas version ) | ( "Unknown Version - " & itas string ) ) of ( value "CurrentVersion"of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion"of native registry as string as version ) else"<Not Installed>"
if (exists values "CurrentVersion"of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion"of native registry as string as version) then (item 1of item 1of (it,("8","SQL SERVER 2000";"9","SQL SERVER 2005";"10.0","SQL Server 2008";"10.50","SQL Server 2008 R2";"11","SQL Server 2012";"12","SQL Server 2014";"13","SQL Server 2016";"14","SQL Server 2017";"15","SQL Server 2019";"16","SQL Server 2022")) whose (item 0ofitas version = item 0of item 1ofitas version) | ("Unknown Version - " & itas string)) of (value "CurrentVersion"of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion"of native registry as string as version) else"<Not Installed>"
if ( existstruewhose ( iftruethen ( exists relay service ) elsefalse ) ) then ( if ( version of client >= "8.0" ) then ( version of relay service as string ) else ( version of file ( ( if ( character 0ofit="%22" ) then ( substring between "%22"ofit ) elseit ) of image path of relay service ) as string ) ) else"Not Installed"
if (existstruewhose(iftruethen(exists relay service)elsefalse)) then (if (version of client >= "8.0") then (version of relay service as string) else (version of file ((if (character 0ofit="%22") then (substring between "%22"ofit) elseit) of image path of relay service) as string)) else"Not Installed"
if ( existstruewhose ( iftruethen ( name of operating system startswith"Win"ANDexists regapp "BESConsole.exe" ) elsefalse ) ) then version of regapp "BESConsole.exe"as string else"Not Installed"
if (existstruewhose(iftruethen(name of operating system startswith"Win"ANDexists regapp "BESConsole.exe")elsefalse)) then version of regapp "BESConsole.exe"as string else"Not Installed"
if ( existstruewhose ( iftruethen ( exists main gather service ) elsefalse ) ) then ( if ( version of client >= "8.0" ) then ( version of main gather service as string ) else ( version of file ( ( if ( character 0ofit="%22" ) then ( substring between "%22"ofit ) elseit ) of image path of main gather service ) as string ) ) else"Not Installed"
if (existstruewhose(iftruethen(exists main gather service)elsefalse)) then (if (version of client >= "8.0") then (version of main gather service as string) else (version of file ((if (character 0ofit="%22") then (substring between "%22"ofit) elseit) of image path of main gather service) as string)) else"Not Installed"
if ( existstruewhose ( iftruethen ( exists key "HKLM\SOFTWARE\BigFix\BESAPI\Paths"of registry ) elsefalse ) ) then version of file ( value "base"of key "HKLM\SOFTWARE\BigFix\BESAPI\Paths"of registry as string & "BESAPI.dll" ) as string else"Not Installed"
if (existstruewhose(iftruethen(exists key "HKLM\SOFTWARE\BigFix\BESAPI\Paths"of registry)elsefalse)) then version of file (value "base"of key "HKLM\SOFTWARE\BigFix\BESAPI\Paths"of registry as string & "BESAPI.dll") as string else"Not Installed"
if ( existstruewhose ( iftruethen ( exists service "BESWebReportsServer" ) elsefalse ) ) then ( if ( version of client >= "8.0" ) then ( version of service "BESWebReportsServer"as string ) else ( version of file ( ( if ( character 0ofit="%22" ) then ( substring between "%22"ofit ) elseit ) of image path of service "BESWebReportsServer" ) as string ) ) else"Not Installed"
if (existstruewhose(iftruethen(exists service "BESWebReportsServer")elsefalse)) then (if (version of client >= "8.0") then (version of service "BESWebReportsServer"as string) else (version of file ((if (character 0ofit="%22") then (substring between "%22"ofit) elseit) of image path of service "BESWebReportsServer") as string)) else"Not Installed"
if ( ( itstartswith"127."ORitstartswith"::" ) of ( name of registration server as string ) ) then ( if ( ( exists setting"_BESRelay_PostResults_ParentRelayURL"ofitANDexists value of setting"_BESRelay_PostResults_ParentRelayURL" ofit ) of client ) then"n/a (BES Relay Installed)"else"n/a (BES Server Installed)" ) else ( name of registration server as string )
if ((itstartswith"127."ORitstartswith"::") of (name of registration server as string)) then (if ((exists setting"_BESRelay_PostResults_ParentRelayURL"ofitANDexists value of setting"_BESRelay_PostResults_ParentRelayURL" ofit) of client) then"n/a (BES Relay Installed)"else"n/a (BES Server Installed)") else (name of registration server as string)
if ( ( itstartswith"127."ORitstartswith"::" ) of ( name of registration server as string ) ) then ( if ( ( exists setting"_BESRelay_PostResults_ParentRelayURL"ofitANDexists value of setting"_BESRelay_PostResults_ParentRelayURL" ofit ) of client ) then ( preceding text of first "/"of ( following text of first "//"of ( value of setting "_BESRelay_PostResults_ParentRelayURL"of client as string ) ) ) else"n/a (BES Server Installed)" ) else"n/a (BES Relay Not Installed)"
if ((itstartswith"127."ORitstartswith"::") of (name of registration server as string)) then (if ((exists setting"_BESRelay_PostResults_ParentRelayURL"ofitANDexists value of setting"_BESRelay_PostResults_ParentRelayURL" ofit) of client) then (preceding text of first "/"of (following text of first "//"of (value of setting "_BESRelay_PostResults_ParentRelayURL"of client as string))) else"n/a (BES Server Installed)") else"n/a (BES Relay Not Installed)"
if ( exists service "BESRelay" ) then ( if ( exists setting "_BESGather_Download_LimitBytesPerSecond"whose ( exists value ofit ) of client ) then value of setting "_BESGather_Download_LimitBytesPerSecond"of client else"not set" ) else"BES Relay Not Installed"
if (exists service "BESRelay") then (if (exists setting "_BESGather_Download_LimitBytesPerSecond"whose (exists value ofit) of client) then value of setting "_BESGather_Download_LimitBytesPerSecond"of client else"not set") else"BES Relay Not Installed"