Robot | Path | Permission |
GoogleBot | / | ✔ |
BingBot | / | ✔ |
BaiduSpider | / | ✔ |
YandexBot | / | ✔ |
Title | A Windows System Admin's Blog | Covering Server Administration, Endpoint Management, Scripting and Network Management |
Description | So just a quick one today. I was recently working on a SQL Server, running through some Database Mail setup and testing (see Microsoft Docs) with one of our applications. I needed a way to see what e-mails were being sent out as well as what wasn't. The below queries will give you the info I was after, the first one shows any items that have run through DB Mail and their details for the last day (you can customise the WHERE statement to your needs. You will want to run them against MSDB, do this by selecting it or issuing a USE MSDB statement. Bare in mind that I'm using Aliases to shorten the query a little (see this article). Now this next one simply shows failed items as well as error responses if any from a mail server. Hope that helps. |
Keywords | N/A |
WebSite | |
Host IP | 104.28.5.44 |
Location | United States |
Site | Rank |
anilgprabhu.blogspot.com | #4,606,665 |
davidmercer.co.uk | #7,137,625 |
360ict.nl | #4,000,112 |
mowasay.com | #983,618 |
wintergreen.coffee |
wisatamedansyariah.com |
wisenitsolutions.com |
worksafeinfo.com.au |
worldsendultra.com |
worldtop7.com |
wpblogr.com |
wpcells.com |
wsoft.ma |
xn--15-glce3az9a.xn--p1ai |
1data.co.kr |
1data.com.cn |
US$6,386
Last updated: Jan 29, 2020
Winsysadminblog.com has global traffic rank of 2,664,010. Winsysadminblog.com has an estimated worth of US$ 6,386, based on its estimated Ads revenue. Winsysadminblog.com receives approximately 1,166 unique visitors each day. Its web server is located in United States, with IP address 104.28.5.44. According to SiteAdvisor, winsysadminblog.com is safe to visit. |
Purchase/Sale Value | US$6,386 |
Daily Ads Revenue | US$3 |
Monthly Ads Revenue | US$104 |
Yearly Ads Revenue | US$1,277 |
Daily Unique Visitors | 1,166 |
Note: All traffic and earnings values are estimates. |
Global Rank | 2,664,010 |
Delta (90 Days) | 0 |
Most Popular In Country | N/A |
Country Rank | N/A |
Host | Type | TTL | Data |
winsysadminblog.com | A | 299 | IP: 104.28.4.44 |
winsysadminblog.com | A | 299 | IP: 104.28.5.44 |
winsysadminblog.com | AAAA | 299 | IPv6: 2606:4700:3034:0:0:0:681c:52c |
winsysadminblog.com | AAAA | 299 | IPv6: 2606:4700:3030:0:0:0:681c:42c |
winsysadminblog.com | NS | 21599 | Target: hank.ns.cloudflare.com. |
winsysadminblog.com | NS | 21599 | Target: gina.ns.cloudflare.com. |
winsysadminblog.com | TXT | 299 | TXT: ca3-3f7a02df8892418dbbda717d2350844d |
winsysadminblog.com | SOA | 3599 | MNAME: gina.ns.cloudflare.com. RNAME: dns.cloudflare.com. Serial: 2032845882 Refresh: 10000 Retry: 2400 Expire: 604800 Minimum TTL: 3600 |
HTTP/1.1 301 Moved Permanently Date: Wed, 29 Jan 2020 11:39:37 GMT Content-Type: text/html Transfer-Encoding: chunked Connection: keep-alive Set-Cookie: __cfduid=d8a804abcc742be0e531ff5a53d00c7de1580297977; expires=Fri, 28-Feb-20 11:39:37 GMT; path=/; domain=.winsysadminblog.com; HttpOnly; SameSite=Lax Location: https://winsysadminblog.com/ X-Turbo-Charged-By: LiteSpeed CF-Cache-Status: DYNAMIC Server: cloudflare CF-RAY: 55caed36f8f7bd2b-PHL HTTP/2 301 date: Wed, 29 Jan 2020 11:39:39 GMT content-type: text/html; charset=UTF-8 set-cookie: __cfduid=d7159ec370b8c36761d83a6707b372d891580297977; expires=Fri, 28-Feb-20 11:39:37 GMT; path=/; domain=.winsysadminblog.com; HttpOnly; SameSite=Lax x-redirect-by: WordPress location: https://www.winsysadminblog.com/ x-litespeed-cache: miss x-turbo-charged-by: LiteSpeed cf-cache-status: DYNAMIC expect-ct: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct" server: cloudflare cf-ray: 55caed3a0bd3bd3a-PHL HTTP/2 200 date: Wed, 29 Jan 2020 11:39:41 GMT content-type: text/html; charset=UTF-8 set-cookie: __cfduid=d6de9fc4ee1707449e9271c76b21453191580297979; expires=Fri, 28-Feb-20 11:39:39 GMT; path=/; domain=.winsysadminblog.com; HttpOnly; SameSite=Lax link: <https://www.winsysadminblog.com/wp-json/>; rel="https://api.w.org/" link: <https://wp.me/2rXiH>; rel=shortlink x-litespeed-cache: miss vary: Accept-Encoding x-turbo-charged-by: LiteSpeed cf-cache-status: DYNAMIC expect-ct: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct" server: cloudflare cf-ray: 55caed4379b7bd1c-PHL |
Domain Name: WINSYSADMINBLOG.COM Registry Domain ID: 1616422490_DOMAIN_COM-VRSN Registrar WHOIS Server: whois.synergywholesale.com Registrar URL: http://synergywholesale.com Updated Date: 2019-08-31T01:56:04Z Creation Date: 2010-09-19T01:13:12Z Registry Expiry Date: 2020-09-19T01:13:12Z Registrar: Synergy Wholesale Pty Ltd Registrar IANA ID: 1609 Registrar Abuse Contact Email: abuse-registry@synergywholesale.com Registrar Abuse Contact Phone: +61.383999483 Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited Name Server: GINA.NS.CLOUDFLARE.COM Name Server: HANK.NS.CLOUDFLARE.COM DNSSEC: unsigned URL of the ICANN Whois Inaccuracy Complaint Form: https://www.icann.org/wicf/ Domain Name: winsysadminblog.com Registry Domain ID: 1616422490_DOMAIN_COM-VRSN Registrar WHOIS Server: whois.synergywholesale.com Registrar URL: http://whois.synergywholesale.com Updated Date: 2019-08-31 01:56:04 Creation Date: 2010-09-19 01:13:12 Registrar Registration Expiration Date: 2020-09-19 01:13:12 Registrar: Synergy Wholesale Registrar IANA ID: 1609 Registrar Abuse Contact Email: noc@synergywholesale.com Registrar Abuse Contact Phone: +61 3 8399 9483 Reseller: R4 Web Design Reseller: https://www.r4design.com.au/ Reseller: info@r4design.com.au Domain Status: clientTransferProhibited http://www.icann.org/epp#clientTransferProhibited Registry Registrant ID: Not Available From Registry Registrant Name: Domain Privacy Registrant Organization: Registrant Street: PO BOX 119 Registrant Street: Registrant Street: Registrant City: Beaconsfield Registrant State/Province: VIC Registrant Postal Code: 3807 Registrant Country: AU Registrant Phone: +61.385145121 Registrant Fax: Registrant Email: winsysadminblogcom@obscure.me Registry Admin ID: Not Available From Registry Admin Name: Domain Privacy Admin Organization: Admin Street: PO BOX 119 Admin Street: Admin Street: Admin City: Beaconsfield Admin State/Province: VIC Admin Postal Code: 3807 Admin Country: AU Admin Phone: +61.385145121 Admin Fax: Admin Email: winsysadminblogcom@obscure.me Registry Tech ID: Not Available From Registry Tech Name: Domain Privacy Tech Organization: Tech Street: PO BOX 119 Tech Street: Tech Street: Tech City: Beaconsfield Tech State/Province: VIC Tech Postal Code: 3807 Tech Country: AU Tech Phone: +61.385145121 Tech Fax: Tech Email: winsysadminblogcom@obscure.me Name Server: GINA.NS.CLOUDFLARE.COM Name Server: HANK.NS.CLOUDFLARE.COM DNSSEC: unsigned URL of the ICANN WHOIS Data Problem Reporting System: http://wdprs.internic.net/ Domain Service Provider: R4 Web Design, info@r4design.com.au 0402 301 914 https://www.r4design.com.au/ Please contact the provider listed above for assistance with your domain name, such as updating your name servers or WHOIS contact information. |