( ( names of authors of it, texts of it, timestamps ofit ) of item 0of it, item 1ofit ) of ( ( comment of it, name ofit ) of bes fixlets whose ( exists authors of comments ofit ) ; ( comment of it, name ofit ) of bes actions whose ( exists authors of comments ofit ) ; ( comment of it, name ofit ) of bes computers whose ( exists authors of comments ofit ) )
( (names of authors of it, texts of it, timestamps ofit) of item 0of it, item 1ofit) of ( (comment of it, name ofit) of bes fixlets whose(exists authors of comments ofit) ; (comment of it, name ofit) of bes actions whose(exists authors of comments ofit) ; (comment of it, name ofit) of bes computers whose(exists authors of comments ofit) )
IF ( ( ( ( name ofit="Win7" ) AND ( version ofit="6.1" ) ) of operating system ) ) THEN ( ( ( service pack major version ofit=0 ) of operating system ) OR ( IF ( ( service pack major version ofit=1 ) of operating system ) THEN ( date ( local time zone ) of ( now ) ) > date ( "Tue, 14 Jan 2020" ) ELSEfalse ) ) ELSEfalse
IF ((((name ofit="Win7") AND (version ofit="6.1")) of operating system)) THEN (((service pack major version ofit=0) of operating system) OR (IF ((service pack major version ofit=1) of operating system) THEN (date (local time zone) of (now)) > date ("Tue, 14 Jan 2020") ELSEfalse)) ELSEfalse
IF ( name of operating system contains"Win8" ) THEN ( ( ( ( service pack major version ofit=0 ) AND ( version ofit="6.2" ) ) of operating system ) OR ( IF ( version of operating system ="6.3" ) THEN ( IF ( version of operating system ="6.3.9600" ) THEN ( IF ( exists ( string values of selects "HotFixID from win32_quickfixengineering where Description = 'Hotfix'"of wmi ) whose ( itcontains"KB2919355" ) ) THEN ( ( date ( local time zone ) of ( now ) ) > date ( "Tue, 10 Jan 2023" ) ) ELSEfalse ) ELSEfalse ) ELSEfalse ) ) ELSEfalse
IF (name of operating system contains"Win8") THEN ((((service pack major version ofit=0) AND (version ofit="6.2")) of operating system) OR (IF (version of operating system ="6.3") THEN (IF (version of operating system ="6.3.9600") THEN (IF (exists (string values of selects "HotFixID from win32_quickfixengineering where Description = 'Hotfix'"of wmi) whose (itcontains"KB2919355")) THEN ((date (local time zone) of (now)) > date ("Tue, 10 Jan 2023")) ELSEfalse) ELSEfalse) ELSEfalse)) ELSEfalse
unique values of ( itas string ) of rows of statements "SELECT [URL] FROM 'INDEXED_DOWNLOADS' ORDER BY 'URL' ASC"of sqlite databases of files "DownloadState.db"of folders "config"of folders "Mirror Server"of ( folders "/var/opt/BESRelay"; folders "/var/opt/BESServer";
(
if
(
windows of operating system
)
then
(
(
parent folders of regapps "BESRelay.exe" ) ; ( ( folder it ) of ( itas string ) of values "StoragePath"of keys "HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\GlobalOptions"of ( x64 registries; x32 registries ) ) ) else NOTHINGS ) )
unique values of (itas string) of rows of statements "SELECT [URL] FROM 'INDEXED_DOWNLOADS' ORDER BY 'URL' ASC"of sqlite databases of files "DownloadState.db"of folders "config"of folders "Mirror Server"of ( folders "/var/opt/BESRelay"; folders "/var/opt/BESServer"; (if (windows of operating system) then ( (parent folders of regapps "BESRelay.exe") ; ( (folder it) of (itas string) of values "StoragePath"of keys "HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\GlobalOptions"of (x64 registries; x32 registries) ) ) else NOTHINGS) )
unique values of ( preceding text of firsts "/"ofit | it ) of ( following text of firsts "://"ofit | it ) of ( itas string ) of rows of statements "SELECT DISTINCT [URL] FROM [INDEXED_DOWNLOADS] ORDER BY [URL] ASC"of sqlite databases of files "DownloadState.db"of folders "config"of folders "Mirror Server"of ( folders "/var/opt/BESRelay"; folders "/var/opt/BESServer";
(
if
(
windows of operating system
)
then
(
(
parent folders of regapps "BESRelay.exe" ) ; ( ( folder it ) of ( itas string ) of values "StoragePath"of keys "HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\GlobalOptions"of ( x64 registries; x32 registries ) ) ) else NOTHINGS ) )
unique values of (preceding text of firsts "/"ofit | it) of (following text of firsts "://"ofit | it) of (itas string) of rows of statements "SELECT DISTINCT [URL] FROM [INDEXED_DOWNLOADS] ORDER BY [URL] ASC"of sqlite databases of files "DownloadState.db"of folders "config"of folders "Mirror Server"of ( folders "/var/opt/BESRelay"; folders "/var/opt/BESServer"; (if (windows of operating system) then ( (parent folders of regapps "BESRelay.exe") ; ( (folder it) of (itas string) of values "StoragePath"of keys "HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\GlobalOptions"of (x64 registries; x32 registries) ) ) else NOTHINGS) )
rows of statements "SELECT * FROM trans WHERE cmdline LIKE '%25update%25'"of sqlite databases of files "history.sqlite"of ( folders "dnf"of it; folders "yum"ofit ) of folders "/var/lib"
rows of statements "SELECT * FROM trans WHERE cmdline LIKE '%25update%25'"of sqlite databases of files "history.sqlite"of (folders "dnf"of it; folders "yum"ofit) of folders "/var/lib"
columns "newest_update_time"of rows of statements "SELECT datetime( max(dt_end), 'unixepoch', 'localtime') AS newest_update_time FROM trans WHERE cmdline LIKE '%25update%25'"of sqlite databases of files "history.sqlite"of ( folders "dnf"of it; folders "yum"ofit ) of folders "/var/lib"
columns "newest_update_time"of rows of statements "SELECT datetime( max(dt_end), 'unixepoch', 'localtime') AS newest_update_time FROM trans WHERE cmdline LIKE '%25update%25'"of sqlite databases of files "history.sqlite"of (folders "dnf"of it; folders "yum"ofit) of folders "/var/lib"
( it * second ) of ( itas string as integer ) of columns "newest_update_time"of rows of statements "SELECT strftime('%25s','now') - max(dt_end) AS newest_update_time FROM trans WHERE cmdline LIKE '%25update%25'"of sqlite databases of files "history.sqlite"of ( folders "dnf"of it; folders "yum"ofit ) of folders "/var/lib"
(it * second) of (itas string as integer) of columns "newest_update_time"of rows of statements "SELECT strftime('%25s','now') - max(dt_end) AS newest_update_time FROM trans WHERE cmdline LIKE '%25update%25'"of sqlite databases of files "history.sqlite"of (folders "dnf"of it; folders "yum"ofit) of folders "/var/lib"
( columns 0of it, ( itas string as integer ) whose ( it!=0 ) of columns 1ofit ) of rows of statements "SELECT SiteName, (Stats_TotalEvaluationTime / Stats_NumberOfEvaluations) AS AvgEvaluationTime FROM main.SITEDATA_INFO ORDER BY AvgEvaluationTime DESC"of sqlite databases of files "SiteData.db"of data folders of client
(columns 0of it, (itas string as integer) whose(it!=0) of columns 1ofit) of rows of statements "SELECT SiteName, (Stats_TotalEvaluationTime / Stats_NumberOfEvaluations) AS AvgEvaluationTime FROM main.SITEDATA_INFO ORDER BY AvgEvaluationTime DESC"of sqlite databases of files "SiteData.db"of data folders of client