theQuery571 => select * from ( select piddl_content.*, piddl_contentgroups.piddlcontentgroup_id, piddl_contentgroups.piddlcontentgroup_publication, piddl_contentgroups.piddlcontentgroup_name, piddl_contentgroups.piddlcontentgroup_maxcontentcount, doc_id, doc_headline, doc_byline, doc_location, doc_pool, doc_published, doc_modified, doc_expires, doc_url, doc_section, doc_sort, doc_summary_short, doc_summary_med, doc_summary_long, doc_address, doc_image, doc_text, section_id, section_publication, section_type, section_url, section_name, section_site, section_language, doc_editor_name, webinar_master.*, case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published when piddlcontent_type = 'webinar' then webinar_date_begin else piddlcontent_createDate end as piddlcontent_pubdate, sub_listpublications.listpub_list from informationweek.dbo.piddl_content piddl_content left join informationweek.dbo.piddl_contentgroups piddl_contentgroups on piddlcontent_contentgroupid = piddlcontentgroup_id left join informationweek.dbo.msg_messages msg_messages on piddlcontent_keyid = msg_id and piddlcontent_type = 'message' left join informationweek.dbo.msg_threads msg_threads on msg_thread = thread_id left join doc_documents with (nolock, index(IX_doc_documents_3)) on piddlcontent_keyid = doc_id and piddlcontent_type = 'document' left join doc_sections on doc_section = section_id left join lightreading.doc_editors doc_editors on doc_documents.doc_author = doc_editors.doc_editor left join informationweek.lightreading.webinar_master webinar_master on piddlcontent_keyid = webinar_id and piddlcontent_type = 'webinar' left join informationweek.lightreading.sub_listpublications sub_listpublications on piddlcontent_keyid = listpub_id and piddlcontent_type = 'mailinglist' where piddlcontent_publication in ('darkreading') and 1=1 and piddlcontent_isActive = 1 and (piddlcontent_type <> 'document' or (piddlcontent_type = 'document' and doc_id <> '' and doc_id is not null and section_id <> '' and section_id is not null and section_visible = 1 and doc_pool in ('Public') and doc_published is not null and doc_published <= getdate() and section_language is null )) and 1=1 and piddlcontent_type in ('document') and doc_section in (311,312,314,316,317,331,335,367,443,452,478,479,480,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,513,514,515,516,517,518,519,544,609,610,611,613,617,618,649,651,654,695,702,704,706,715,716,734,741,751,753,755,757,758,759,760,764,765,766,769,771) and piddlcontent_id in (select distinct piddlcontenttag_piddlcontentid from informationweek.dbo.piddl_contenttags where piddlcontenttag_tagid in (649)) and year(case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published else piddlcontent_createDate end) = 2017 and month(case when piddlcontent_type = 'document' and section_type in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show') then doc_modified when piddlcontent_type = 'document' and (section_type is null or section_type not in ('Radio Show','Lecture','Live Chat','Crowd Source Session','Video Show')) then doc_published else piddlcontent_createDate end) = 9 ) as this_recordset order by piddlcontent_pubdate desc Business Technology News and Commentary - Dark Reading

Dark Reading is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

News & Commentary

Content tagged with Authentication posted in September 2017
SecureAuth to Merge with Core Security
News  |  9/20/2017  | 
K1 Investment Management, which owns Core Security, plans to acquire the identity management and authentication company for more than $200 million.
How Apple's New Facial Recognition Technology Will Change Enterprise Security
Commentary  |  9/19/2017  | 
Expect a trickle-down effect, as tech similar to Face ID becomes offered outside of Apple.
Workplace IoT Puts Companies on Notice for Smarter Security
Commentary  |  9/6/2017  | 
Blacklisting every "thing" in sight and banning connections to the corporate network may sound tempting, but it's not a realistic strategy.


COVID-19: Latest Security News & Commentary
Dark Reading Staff 7/1/2020
Ripple20 Threatens Increasingly Connected Medical Devices
Kelly Sheridan, Staff Editor, Dark Reading,  6/30/2020
DDoS Attacks Jump 542% from Q4 2019 to Q1 2020
Dark Reading Staff 6/30/2020
Register for Dark Reading Newsletters
White Papers
Video
Cartoon
Current Issue
The Threat from the Internet--and What Your Organization Can Do About It
This report describes some of the latest attacks and threats emanating from the Internet, as well as advice and tips on how your organization can mitigate those threats before they affect your business. Download it today!
Flash Poll
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2020-15478
PUBLISHED: 2020-07-01
The Journal theme before 3.1.0 for OpenCart allows exposure of sensitive data via SQL errors.
CVE-2020-6261
PUBLISHED: 2020-07-01
SAP Solution Manager (Trace Analysis), version 7.20, allows an attacker to perform a log injection into the trace file, due to Incomplete XML Validation. The readability of the trace file is impaired.
CVE-2020-15471
PUBLISHED: 2020-07-01
In nDPI through 3.2, the packet parsing code is vulnerable to a heap-based buffer over-read in ndpi_parse_packet_line_info in lib/ndpi_main.c.
CVE-2020-15472
PUBLISHED: 2020-07-01
In nDPI through 3.2, the H.323 dissector is vulnerable to a heap-based buffer over-read in ndpi_search_h323 in lib/protocols/h323.c, as demonstrated by a payload packet length that is too short.
CVE-2020-15473
PUBLISHED: 2020-07-01
In nDPI through 3.2, the OpenVPN dissector is vulnerable to a heap-based buffer over-read in ndpi_search_openvpn in lib/protocols/openvpn.c.