Name: OceanLotus_dropped_file_1
OceanLotus dropped file (https://www.alienvault.com/blogs/labs-research/oceanlotus-for-os-x-an-application-bundle-pretending-to-be-an-adobe-flash-update): Artifact used by this malware

Query:

select * from file, ( \
        select '/Library/Logs/.Logs/corevideosd' ioc union \
        select '/Library/.SystemPreferences/.prev/.ver.txt' ioc union \
        select '/Library/Parallels/.cfg' ioc union \
        select '/Library/Preferences/.fDTYuRs' ioc union \
        select '/Library/Hash/.Hashtag/.hash' ioc union \
        select '/Library/Hash/.hash' ioc \
      ) iocs where \
        file.path LIKE '/Users/%/' || ioc OR \
        file.path = iocs.ioc OR \
        file.path LIKE '/tmp/crunzip.temp.%';

Additional Query Info:
Version: 1.4.5
Platform: darwin
Interval: 3600

JSON:

{
  "queries": {
    "OceanLotus_dropped_file_1": {
      "query" : "select * from file, ( \
        select '/Library/Logs/.Logs/corevideosd' ioc union \
        select '/Library/.SystemPreferences/.prev/.ver.txt' ioc union \
        select '/Library/Parallels/.cfg' ioc union \
        select '/Library/Preferences/.fDTYuRs' ioc union \
        select '/Library/Hash/.Hashtag/.hash' ioc union \
        select '/Library/Hash/.hash' ioc \
      ) iocs where \
        file.path LIKE '/Users/%/' || ioc OR \
        file.path = iocs.ioc OR \
        file.path LIKE '/tmp/crunzip.temp.%';",
      "interval" : "3600",
      "platform" : "darwin",
      "version": "1.4.5",
      "description" : "OceanLotus dropped file (https://www.alienvault.com/blogs/labs-research/oceanlotus-for-os-x-an-application-bundle-pretending-to-be-an-adobe-flash-update)",
      "value" : "Artifact used by this malware"
    }
  }
}