Provider Hosted App-Not able to get data from list using JSOM or Javascript in sharepoint 2016 On-Premise

My Provider-Hosted App published and hosted on IIS with https. The URL is like:


How can I get list data using JavaScript or JSOM.

Please share the helpful code snippet.

Why did conservatives decide in 2016 that electing an incompetent jackazz president was a good idea?

Conservatives did no such thing. They decided that Donald Trump was preferable to Hillary Clinton. And remember none of the  4,489,233 Gary Johnson got were siphoned off from the Hillary Campaign. Millions more people did not vote for Hillary than did vote for her. 

The world is an imperfect place, and the least perfect in the political arena. 

sql server 2016 – Get values from table if this or that applies, but not when both apply

I’m currently struggling with a seemingly simple task.

The goal is to get the corresponding prices according to the customer number – OR – the customer price group if the customer number does not exist in the table. I think my problem here is that those values are saved in the same table.
The table looks like this (shortened):

Sales Code | Item No | Unit price

SC1 | 711111 | 345.12

SC2 | 711111 | 501.24

SC3 | 711111 | 242.70

CustomerNo1 | 711111 | 242.70

CustomerNo2 | 711111 | 250.00

SC1 | 711112 | 345.12

SC2 | 711112 | 501.24

SC3 | 711112 | 242.70

CustomerNo2 | 711112 | 250.00

I am using a parameter for the customer number and I already got the customer price group of the customer, for the case if the customer number is not available in the table for the sales prices.

A short snipped of my code so far:

-- Get the customer price group
SET @query = 
    'SELECT @CustomerPriceGroup = (CASE (Customer Price Group) WHEN '''' THEN ''SC1'' ELSE (Customer Price Group) END)
    FROM (customers) 
    WHERE (No) = ''' + @CustomerNo + ''''
EXEC sp_executesql @query, N'@CustomerPriceGroup NVARCHAR(3) OUTPUT', @CustomerPriceGroup = @CustomerPriceGroup OUTPUT

-- Get the item data
    SET @query = 'SELECT sp.(Sales Code) AS (SalesCode),
            i.(No) AS (ItemNo),
            i.(Name) AS (ItemName),
            sp.(Unit Price) AS (UnitPrice)
    FROM (items) i
    INNER JOIN (salesprices) sp ON i.(No) = sp.(ItemNo)
    WHERE (sp.(Sales Code) = ''' + @CustomerNo + ''' OR sp.(Sales Code) = ''' + @CustomerPriceGroup + ''')'

    EXEC (@query)

I already tried to use EXIST or a window function (example from here, but I was not successful. I got the prices for the customer itself without the customer price group, but not the customer price group if no customer number is available (always nothing, both or only the customer price).

I need to get the following fields:

  • Sales Code
  • Item number
  • Item name
  • Unit price (according to the sales code, either CustomerNo or sales code)
  • Grouped by the item number

I am using Microsoft SQL Server 2016.

Any idea how I can solve that?

BR Raphi

Anti-spam whitelisting by sender IP in Exchange 2016 on-prem

I can’t seem to find the way to bypass the anti-spam filter by IP address in the Exchange 2016.

The goal is to allow POS tills to send automated emails to accounts when the bill is closed.

The IPAllowListEntry is a part of Connection Filter Agent that is only installed on Edge Transport servers which we don’t have (it’s a small org with 25-ish email addresses), so it’s not an option.

I have created the transport rule to bypass the filter (this image) but it still rejects the email with “550 5.7.1 Message rejected as spam by Content Filtering”.

Am I missing something or is it just not possible and I need to look for another way to get emails in?

The relevant Content Filter entry:

RunspaceId      : 48313825-e2e1-4519-aa46-4912cb226c0c
Timestamp       : 26/06/2020 12:25:15 PM
SessionId       : 08D7F137C2E9E894
IPAddress       :
MessageId       : <>
P1FromAddress   :
P2FromAddresses : {}
Recipients      : {}
Agent           : Content Filter Agent
Event           : OnEndOfData
Action          : RejectMessage
SmtpResponse    : 550 5.7.1 Message rejected as spam by Content Filtering.
Reason          : SclAtOrAboveRejectThreshold
ReasonData      : 7
Diagnostics     : DV:3.3.5705.600;SID:SenderIDStatus None
NetworkMsgID    : 5829a30a-4a41-430e-3aa7-08d8196765ee
TenantID        : 00000000-0000-0000-0000-000000000000
Directionality  : Incoming

sql server 2016 – Can’t load reportserver in browser

The issue is most likely that you haven’t configured your Service Principal Names for the Report Server, so it is encountering an error trying to utilise Kerberos Authentication.

Firstly, you need to confirm your SPNs are configured correctly for the Report Server. You can use Kerberos Configuration Manager for SQL Server to identify any issues with your SPNs and fix those issues.

Once your SPNs are corrected, add the address (http://servername/) to your trusted sites to enable your Windows identity to be passed through automatically and facilitate SSO. | Lifetime file storing, no deletion due to inactivity – Clean Ads – 24Hrs Payouts – Oldest video host since 2016 | Proxies-free


The GO Unlimited service, which may be known by the name of many of you, is one of the oldest services specialized in the field of video hosting. The goal of the service has always been to ensure the provision of a secure and stable platform for its long-term partners, in addition to providing features and characteristics commensurate with their aspirations and of course renewed development in order to ensure keeping pace with industry requirements.

GO Unlimited, 2020

In the year 2020, we seek to transfer the service from the field of traditional video hosting to integrated solutions in this field, by providing advanced tools, some of which were not previously proposed or used in this field, in order to keep pace with the development contained in this industry and its requirements.


Our Goal

Our primary goal is to ensure the long-term stability of the platform and the stability of the services the tools it provides to its partners. We work in GO Unlimited on the basis of long-term plans and not short so as to ensure the opportunity to work for many years and successfully meets the aspirations and aspirations of our partners.

Our work since 2016 and our accomplishments are evidence of this goal that we seek. We will always continue to work on this goal.​

If you have any suggestions, or inquiries, we will always be glad to hear.

active directory – Is it possible to give windows 10 access to a sql server hosted on windows server 2016?

Is it possible to give windows 10 access to a sql server hosted on windows server 2016?
Let me elaborate. I have found resources for setting up a domain for my pcs using a windows server.
The windows server will host an instance of SQL Server Express. I have Windows PC’s that will need access to the SQL server. Each Windows 10 machines will have Visual Studios and thus will need the access to the data from the SQL Servers installed on the Windows Server 2016.

Is it possible to do this without giving each user access to the domain on the Windows Server over a Network connection or do I need to give each user access to the domain and thus allowing for individual users to be given access to using the SQL Server from the domain?

I read literature on Microsofts Documentation that states nothing about Active Directory and giving access through a domain.

So currently I am confused. I keep finding a lot of AZURE Active Directory articles and none for Microsoft Docs explaining Active Directory Domains for this setup I am going to setup.

SharePoint 2016 – No search service instances found in the farm

Not sure what happened but my Search Service Application Proxy is missing and I can’t delete Search Service Application.

Error when attempting to delete: Sorry, Something went wrong. No search service instances found in the farm.

I added the search service proxy back via powershell but it disappeared.

Search Service Topology stuck on “loading.”

Taken from ULS log:

Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005): Exception of type ‘System.Web.HttpUnhandledException’ was thrown. —> System.Exception: No search service instances found in the farm.
at Microsoft.Office.Server.Search.Administration.Topology.SearchTopologyUtils.DeleteAllActiveNodes(SearchServiceApplication searchApp)
at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.Unprovision(Boolean deleteData)
at Microsoft.SharePoint.ApplicationPages.ServiceApplicationDeletePage.OkButton_Click(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

How can delete the ssa?